Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.

learn more… | top users | synonyms

12
votes
4answers
12k views

How do you identify InnoDB table corruption?

I have some tables that are partitioned and have several indexes on a replicated slave. After copying the snap shot (verified safe) to a new slave and upgrading mysqld from 5.1.42 to 5.5.15 and ...
6
votes
1answer
871 views

Tuning dedicated Percona Server with XtraDB for OLTP

Hardware specs for an OLTP DB dual quad core xeon with hyperthreading 24GB ram Hardware RAID10 BBU Software specs Standard install of Ubuntu 10.04LTS with default LVM partitioning Installed ...
5
votes
1answer
2k views

Capabilities of InnoDB INSERT Performance

Hi I am running the most recent version of Percona Server. Server version: 5.5.24-55 Percona Server (GPL), Release 26.0 I have a 10 cpu box of these characteristics. processor : 0 vendor_id ...
4
votes
2answers
4k views

Percona vs MySQL

What is Percona? How does it differ from MySQL? When should we consider switching (or upgrading) from stock MySQL to Percona? To add some specifics in our situation we almost exclusively use ...
3
votes
1answer
18 views

Is the innodb_lazy_drop_table problem solved?

I'm researching database configuration for MySQL/MariaDB. I've been reading the configuration chapter in "High Performance MySQL". In there, it suggests that innodb_lazy_drop_table can be used to ...
3
votes
1answer
58 views

Online Schema migration in MySQL : When to start?

I'm the tech lead of a Social Media SAAS, where we're currently experiencing a big increase in data amount we're storing in our mySQL-database. We're having a single MySQL db, and besides many ...
3
votes
1answer
79 views

MySQL Replication not proceeding

I have a weird replication problem I have not seen before. It's basic mysql replication with single master and two slaves. One of the slaves is not executing replication events and seems just stuck ...
3
votes
1answer
581 views

MySQL Handler_read_rnd_next == tablescans without indexes?

I am in the process of tuning our Percona 5.5 server, and have been using percona's tools to plot our database's performance. In the MySQL Handlers Plot, i have been noticing alot of ...
3
votes
0answers
296 views

XtraDB Cluster Error : “IST first seqno 7 not found from cache, falling back to SST” in replication [closed]

I have a problem with MySQL clustering. My systems consist of: xtrabackup: version 2.0.2 MySQL: version 5.5.27 Distro: CentOS 5.7 64-bit my.cnf on the donor: [mysqld] binlog_format=ROW ...
2
votes
2answers
294 views

Is there any reason not to use Percona 'innodb_fast_checksum'?

I recently came across a change that Percona Server implemented over normal MySQL InnoDB. The new feature is innodb_fast_checksum XtraDB can use a more CPU-efficient algorithm, based on 4-byte ...
2
votes
2answers
362 views

any documentation on tpcc-mysql benchmark tool

Where can I find tpcc-mysql documentation? I google it but I can't find any documentation about it.
2
votes
1answer
2k views

Very poor insert performance MySQL / Percona Server

I'm running a Percona-Server instance off an Ubuntu server install. I'm using an application that needs to access this database, and its having VERY poor performance. Once the database has been ...
2
votes
1answer
470 views

MySQL: mysqld_safe options

Is there a way to specify these options in configuration file? I've tried to add them into [mysqld_safe] section but it doesn't work: [mysqld_safe] numa-interleave = 1 flush-caches = 1 - # ps -ww ...
2
votes
1answer
775 views

InnoDB temporary table location

I have a busy InnoDB table that expands and contracts regularly in size on a daily basis based on it's load. Typically, we'd see the table grow to 80GB in size (50/50 data and indexes) and then shrink ...
2
votes
1answer
122 views

How big can innodb_doublewrite_file grow?

When I use the enable innodb_doublewrite_file ... How big can this file grow ? How can I calculate the optimal disk size, if it would be used only for this file?
2
votes
2answers
438 views

Slow INSERTs to MEMORY table

I've been trying to work this issue out, been really killing me! We've been experiencing some slow database queries for a Prestashop installation that we host, and a look into the query log revealed ...
2
votes
1answer
312 views

Assertion failure from InnoDB while restoring using Innobackupex

I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes: We recently upgraded our production DBs ...
2
votes
2answers
767 views

MySQL information_schema doesn't update

I have a database, say abc, in mysql server. It has only one table named test. test uses innodb engine and I've set innodb_file_per_table to true. After I run the query delete from abc.test, I want ...
1
vote
1answer
265 views

Unknown storage engine 'XtraDB'

I installed Percona Server 5.6.12-rc60.4, when I want create table such as : CREATE TABLE IF NOT EXISTS `mydb`.`table` ( `id` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR( 64 ) NOT NULL , PRIMARY ...
1
vote
2answers
76 views

Baffled with MySQL LEFT JOIN query that I have to speed it up

I am kind of a puzzled with this query trying to optimize it but no way I am able to (due to my limited knowledge as a DBA). So, I asked the experts. In my setup I have three (primary) tables. ...
1
vote
2answers
143 views

Is there a way to get slow-query-log-like profiling information on a single query?

Specifically, I'm looking for this information: # Query_time: 0.011922 Lock_time: 0.000088 Rows_sent: 107 Rows_examined: 663 Rows_affected: 0 Rows_read: 107 # Bytes_sent: 4152 Tmp_tables: 3 ...
1
vote
1answer
206 views

MySQL InnoDB does not return the last row on select with DESC order

We have a table scheme like following: CREATE TABLE IF NOT EXISTS `offers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `price` double ...
0
votes
0answers
105 views

trouble installing percona 5.6 on google compute engine debian

I've been trying to install percona server on a fresh google compute engine instance. I havent installed mysql server previously. i followed the instructions from here ...
0
votes
0answers
20 views

Anyone know the fix for an older innodb inspection query

This post talked about an information_schema query to give you a nice report of how much percentage wise indexes are fitting into the buffer pool The query looked like > SELECT `schema` ...
0
votes
0answers
45 views

Recurring locks and slowdowns on a Percona XtraDB Cluster

I have 5 dedicated servers (identical machines: 32 cores, 96GB of RAM, SSD drives in RAID and gigabit ethernet link) configured with Percona XtraDB Cluster. There's a recurring problem causing a ...
0
votes
0answers
58 views

mysqldump with multiple thread

How can I dump Percona mysql server database with multiple thread ? I don't want to use any third party tool or script for safety. Suggest me best, fastest,and safe way to dump and restore my largest ...
0
votes
0answers
55 views

Percona mysql server slow queries

Recently I bought new database server and installed percona mysql server 5.5.32-31 and transferred my /var/lib/mysql directory from old database server having Percona mysql server 5.5.28 to new ...
0
votes
1answer
248 views

Strange Locking issues while playing back logs via percona playback

Problem while replaying logs I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior: As described here i: Created a dump (innobackupex ftw) ...