May 25, 2012

Post: MySQL 6.0 vs 5.1 in TPC-H queries

… benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting… reads. So let us see how perform 5.1 and 6.0 in cold mode…What is interesting is iostat -dx 5 output during query execution. For 5.1 I had: Device…1285 rkB/s is pretty small for RAID 10 system we have on this …

Post: How Percona does a MySQL Performance Audit

… a lot of information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output… 5 5 iostat -dx 5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…