… in the comments and I promised to follow up with more SSB tests at a later date. I also promised more low concurrency SSB tests when Peter blogged about the importance … and found that InnoDB does more IO than MyISAM when the database is cold, but uses less CPU time when the database…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… an empty transaction list when creating read views. However, the more general descriptors optimization in Percona Server showed fairly close results… 5.5 and MySQL 5.6. In order to understand more about differences between results we have rerun tests on several…. We ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows a results comparison…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…’s pretty fast. But it’s still significantly slower (and more CPU-intensive under high load) than PCIe flash For example, see…
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… CPU-bound case. As you can see there is a very slight difference between servers at 64 threads but a much more… operations per second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see…
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… ? Add my vote on compression as we are facing more and more big data challenges where innoDB and TokuDB will have to…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… the Dell PowerEdge R420 with two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz, 48GB of RAM and SATA… see what results we have. The results are in TPS (more is better) and we start with empty tables. Now, before… there we see the strong side of TokuDB: it has more than 4x data compression on this dataset. We can easily…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them… applied to the other nodes, that is if you have more than one PXC node. This is because before Galera can…, other factors affecting async replication like if your workload is CPU or IO bound. Peter wrote some good details about it…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… very soon. Please refer to the bug #1168032 description for more details. Thanks to Mark McKinstry for reporting the bug and… Percona Live MySQL Conference and Expo for walking through this. — More info on Percona Server 5.5.30-30.2 — New…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid… issue but not all. With Numa systems, the picture is more complex and swapping can occur because of a memory imbalance… 10:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22 UTC 2013 r b…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… the more cores we get the more idle CPU we’re getting. It is also very interesting to see the corellation between CPU usage… uses less CPU with 8 cores and has less performance – this usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so it is probably better with latching too though it is hard to say anything about CPU…
