Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

13
votes
2answers
5k views

How do I properly perform a MySQL bake-off?

I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better ...
7
votes
2answers
883 views

Investigate peak in MySQL throughput

Recently one of our servers has ran out of memory and crashed. After reviewing the munin graphs, it appears that the only metric (other than memory usage) that peaked just before the crash was the ...
6
votes
2answers
2k views

Scaling Percona datacenters: setup and replication

Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you. We have already scaled alot of our application stack: we offloaded ...
5
votes
1answer
2k views

What is the difference between XtraBackup and rsync?

Yes, I'm going to run strace on them both... However, I would like to know ... What is XtraBackup is doing over and above rsync -ac src dest ? What's so special about XtraBbackup ? How is XtraBackup ...
5
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 ...
4
votes
1answer
4k views

Why default character_set_server is latin1?

I am using MySQL 5.5 and when I show variables about charset, I have +--------------------------+----------------------------+ | Variable_name | Value | ...
3
votes
1answer
73 views

Percona MySQL 5.5 Unique key is duplicated

I'm totally out from ideas, so maybe somebody else could answer my question. We have a MySQL 5.5 server from Percona with high traffic. The application is in PHP and writes always to master. We have ...
3
votes
3answers
397 views

Is it possible to pass parameters to pt-table-checksum using an options file?

We're using Percona's pt-table-checksum for MySQL replication integrity check. Is it possible to pass some or all of the options using some sort of configuration file? For instance, can we write the ...
3
votes
1answer
4k views

Should a MySQL replication slave be set to read only?

I've got replication running on Percona Server 5.5 by following this guide and wondered if I should add read-only=1 to my slave's my.cnf to make it read only? The guide sets up replication for the ...
3
votes
1answer
134 views

Backup and off-site restore setup

I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one. Our current situation is ~100 GB of InnoDB and MySAM data in ...
3
votes
1answer
4k views

Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working

I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands: $ pt-table-checksum h=master,u=user,p=password ...
3
votes
1answer
479 views

Does this make my XtraDB Cluster hang?

After seeing the following in the error log on the second node: 121003 7:16:06 [Note] WSREP: Member 0 (joiner) synced with group. 121003 7:16:06 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) ...
3
votes
1answer
650 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
324 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 ...
3
votes
2answers
96 views

Percona Toolkit Installation Error

[root@localhost ~]# rpm -ivh percona-toolkit-2.2.7-1.noarch.rpm error: Failed dependencies: perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.7-1.noarch perl(Time::HiRes) is needed ...
2
votes
2answers
490 views

What is an “empty query” in information_schema.CLIENT_STATISTICS?

The client stats table has an "empty queries" column. What does that mean? Simple googling just tells me "The number of times this client's connections sent empty queries to the server." /facepalm
2
votes
2answers
570 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
2answers
878 views

Percona XtraDB Cluster and MySQL Replication

I've setup a 3-node multi master replication with percona xtradb cluster, it works perfectly. Now I've tried to add some read-only slaves setting up replication as usual but it seems the binlog ...
2
votes
1answer
203 views

Why are my queries getting really slow?

I own a WordPress installation, and Updated to 3.4.1. After the upgrade, I experienced a very strange slow-down. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
2
votes
1answer
3k views

query_cache_type = 0 vs query_cache_type = 1

Recently, I moved from standard MySQL to Percona, and used the Percona Wizard to generate my.cnf. However, I can see that, by default, the generated settings for my.cnf use query_cache_type = 0. ...
2
votes
1answer
300 views

MySQL InnoDB issue not using indexes correctly [Percona 5.6]

I just installed Percona 5.6 on my new CentOS 6.4 server. It's a fast machine 32 core xenon, 72GB ram, 8x SAS RAID 10 setup. So far so good My old server is a bit less powerful, and was running ...
2
votes
1answer
323 views

Percona XtraDB Cluster: How to skip SST when starting?

Is there a way to skip State Snapshot Transfer (SST) at startup on Percona XtraDB Cluster Server? wsrep_sst_mode=skip doesn't work: 121003 6:49:55 Percona XtraDB (http://www.percona.com) ...
2
votes
1answer
42 views

MySQL Replication - Master Master - Single Master write

I am looking to improve our fault tolerance for our persistent store. After reading several online docs about how to set-up master <> master replication, I'd still like to ask the experts about the ...
2
votes
1answer
160 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
1answer
1k views

Percona Node fails to join: Operation not permitted

Joining a new Percona node fails with: 130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group ...
2
votes
1answer
333 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
1answer
2k views

MySQL requires FORCE INDEX on huge table and simple SELECTs

We have an application which stores articles from different sources in a MySQL table and allows users to retrieve those articles ordered by date. Articles are always filtered by source, so for client ...
2
votes
0answers
870 views

How to prevent “ibdata files do not match the log sequence number”?

I am dealing with a very large set of databases that are all innodb. I've enountered this on mysql restart too many times for my comfort: ibdata files do not match the log sequence number But I've ...
2
votes
1answer
185 views

innobackupex is failing while exporting backup

I am using perl script which is working fine in one of my other box which used to take individual schema backups & finally take all schema together using percona innobackupex. I have following ...
1
vote
2answers
296 views

Slow query responce on different mysql versions, percona, MariaDB

LEFT JOIN is supposed to be faster than a NOT IN query. This is what I've read online. But practically, this seems to be opposite. I have the following query here, INSERT IGNORE INTO callrequests ...
1
vote
2answers
57 views

Any way to force “garbage collection” in TokuDB?

Playing around with TokuDB I'm finding even after "optimize table" for things such as changing row compression or other DDLs it takes a non deterministic amount of time for freed space to be reflected ...
1
vote
1answer
391 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
1answer
819 views

Compressing Base64 Encoded Image in Database Field. Table Size too Large

Database Info Database Type - Percona MySQL. Table engine - InnoDB. I have a database table that is currently using 17GB at 400,000 rows. This size is mainly because I'm storing a 40kb base64 ...
1
vote
1answer
276 views

Percona xtrabackup Prepare Fails

I made a backup and according to Percona it completed successfully. Now I'm trying to prepare it and having the following issue: ./xtrabackup_55 --defaults-file="/etc/my.cnf" ...
1
vote
1answer
45 views

percona xtrabackup to backup mysql database

I'm trying to use percona xtrabackup to backup a mysql database. in the restoring the database according to the documentation: rsync -avrP /data/backup/ /var/lib/mysql/ this will copy the ibdata1 ...
1
vote
2answers
103 views

What variable(s) to look to maintain MySQL speed of scanning through all database tables while it starts?

We have few thousand small databases with total .ibd files of about 800000. We noticed that MySQL takes couple of minutes to stop but about two hours to start. For e.g. while MySQL is starting and ...
1
vote
1answer
168 views

Debugging error report percona 5.6

I'm running percona 5.6 on a new centos 6.4 server. Things seem to work OK. I personally only really use InnoDB tables for my databases, but only the standard 'mysql' table is in MyISAM format. I ...
1
vote
1answer
142 views

one node in cluster got crashed ,how to recover it?

we are using percona galera cluster with 3 nodes. In my cluster one node got crashed due to low disk space ,we have cleared some log files and provided sufficient disk space.Now we are trying to start ...
1
vote
1answer
388 views

GeomFromText in trigger has error

I have this trigger: DELIMITER $$ CREATE TRIGGER geometrytrigger BEFORE INSERT ON users FOR EACH ROW BEGIN SET NEW.user_geometry=GeomFromText(NEW.user_geometry); END$$ DELIMITER ; when I insert a ...
1
vote
1answer
111 views

xtrabackup backup grants?

I'm using MySQL 5.5 + Opensuse 12.3 . After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution. I found the xtrabackup from ...
1
vote
1answer
114 views

Archive partition before delete it?

I have manage to create an event and with the following scripts could both create and delete the partition. The issue now I need help on how to save the partition before its deleted? Should I use ...
1
vote
3answers
878 views

Ubuntu / MySQL / Percona XtraBackup gives error “sh: 1: xtrabackup_55: not found”

Hello I installed Ubuntu 12.04.2 LTS on a fresh box. This installed MySQL 5.5.29. I installed percona-xtrabackup-2.0.6-521.tar.gz, and moved the executables to /usr/bin/ But innobackupex is ...
1
vote
1answer
235 views

xtrabackup “failed to read metadata” [closed]

Doing a staging run setting up a new xtrabackup restore script I'm running into a somewhat cryptic error I can't readily google a solution for. I'm working with an incremental backup design. During ...
1
vote
1answer
188 views

Design for active/passive Master-Master mysql Setup

I have a dozen virtual machines running application + mysql instances (version 5.1 up to 5.5). Due to the bad I/O of the virtualization I want to buy a physical server for mysql and move all mysqldata ...
1
vote
2answers
179 views

Upgrading to MySQL 5.6, benefits to switching to GTID replication?

We have the most basic of MySQL replication setups, a single Master doing statement-based replication to a single Slave, a 90/10 mix of innodb/myisam tables. Both run Percona MySQL 5.5 at the moment ...
1
vote
1answer
137 views

Innodb buffer pool indexes versus data usage

The server has 128GB of RAM. The innodb_buffer_pool_size is set to 106GB. mysql> show global variables like 'innodb_buffer_pool_size'; +-------------------------+--------------+ | Variable_name ...
1
vote
1answer
282 views

Can I use a Percona Xtrabackup backup to restore a single table?

I've been playing around with the Xtrabackup tool for a month now, and I got to admit : it is really powerful ! I'm still testing it to backup database servers between 5 and 150 GB and the ...
1
vote
0answers
70 views

pt-table-checksum generates no output

I've been using pt-table-checksum on our staging server successfully, but when I run ./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod It just sits there. No ...
0
votes
3answers
178 views

xtrabackup prepare - after dump or before restore?

i have doubts about xtrabackup --apply-log. is there any difference when use it? should it be done right after dump or before restore (even few months later)? seems stupid, but maybe i missing ...
0
votes
1answer
188 views

Is using the alpha version of Percona 5.6 safe? [closed]

I'm really sorry if my question is kind of very basic, but is something that is really making me thinking a lot about it for a long time. As Percona has a lot of lines of optimizing codes, I run it ...