… and CPU core count. He looked for a balance between utilizing the hardware as much as possible, limiting the system complexity, and lowering… more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price-to-performance ratio and increase the utilization of the…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…MySQL 5.6 use the sysbench OLTP workload. I wanted to test a set of queries which, unlike sysbench, utilize… was a lower buffer pool hit ratio during the MySQL 5.6 runs and MySQL 5.6….duration, p2.duration, p1.cpu_user + p1.cpu_system p1_cpu, p2.cpu_user + p2.cpu_system p2_cpu, p1.context_voluntary …
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…, but later Dimitri in his article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt that it… RAM and with FusionIO 320GB MLC card, and run tpcc-mysql benchmark with 500W using Percona Server 5.5.8. Here… 4096 block size USER and SYS CPU is utilized much better, meaning that IDLE is much lower. Is this contention issue in FusionIO…
Comment: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
I have been testing MySQL 5.0.45 as distributed by Sun on a T5120 … and Sysbench (latest versions). I’ve been using mainly the MySQL config to tune, and haven’t delved into filesystem and… machine. The main difference is the resource utilization on the T5120 is much lower: 20% CPU versus 80-85% on the X4100. I…
