… and suddenly you can update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t…
Comment: MySQL and Percona Server in LinkBench benchmark
May 13, 2013 By 18 Comments
… unstable and inaccurate for me. It often wastes 100% of cpu and nothing to do for mysqld, and it continues in…
Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 13, 2013 By 5 Comments
Anthony, that’s an excellent question. The supported method is to use the Galera arbitration daemon and you can find documentation on that here: http://www.codership.com/wiki/doku.php?id=data_backup This is a good topic for a followup blog post, stay tuned…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… not be related to primary key worth distribution, memory or CPU as repeating the same test on uncompressed table scale as…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
Thanks for sharing this! seems like I have a new headache now.. 
) stay tuned.. Rgds, -Dimitri
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… how these servers will handle such OLTP workloads in the CPU and IO-bound cases. For this test we used a… of buffer pool is 30GB). So basically this is a CPU-bound case. As you can see there is a very… operations per second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… inconsistencies, but that is beyond the scope of this post. Tuning flow control Flow control is triggered when a Synced node… replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…, other factors affecting async replication like if your workload is CPU or IO bound. Peter wrote some good details about it…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. Hardware: HP ProLiant DL380 G6 (8cores/16 cpu threads) Cisco UCS C250 (12cores/24 cpu threads) Dell PowerEdge R720 (16 cores/32 cpu threads) All are NUMA boxes, but the second…. We ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows a results comparison…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used…
