MySQL 5.5 / 5.6 / 5.7 in sysbench READ-ONLY CPU burning workload ================================================================ Setup ----- - Client (sysbench) and server are on different servers, connected via 10Gb network. - CPU for both: 56 logical CPU threads servers Intel(R) Xeon(R) CPU E5-2683 v3 @ 2.00GHz MySQL 5.5 / 5.6 / 5.7 , innodb\_thread\_concurrency=0 ----------------------------------------------------- ![](summary-2_files/figure-markdown_github/unnamed-chunk-1-1.png) MySQL 5.6 and MySQL 5.5 with innodb\_thread\_concurrency=75 ----------------------------------------------------------- ![](summary-2_files/figure-markdown_github/innodbthreadconcurrency-1.png) MySQL 5.6 and MySQL 5.5 with innodb\_thread\_concurrency=75 ----------------------------------------------------------- ### Threads <= 10 ![](summary-2_files/figure-markdown_github/lowthreads-1.png) Tabular format -------------- | Threads| MySQL 5.5| MySQL 5.6| MySQL 5.7| MySQL 5.5 / MySQL 5.6| MySQL 5.5 / MySQL 5.7| MySQL 5.6 / MySQL 5.7| |--------:|----------:|----------:|----------:|----------------------:|----------------------:|----------------------:| | 1| 461.33| 436.07| 428.48| 1.06| 1.08| 1.02| | 2| 934.90| 886.13| 866.53| 1.06| 1.08| 1.02| | 3| 1377.05| 1345.82| 1276.64| 1.02| 1.08| 1.05| | 4| 1813.37| 1778.41| 1711.92| 1.02| 1.06| 1.04| | 5| 2235.01| 2153.97| 2096.90| 1.04| 1.07| 1.03| | 6| 2645.74| 2570.87| 2478.63| 1.03| 1.07| 1.04| | 8| 3493.05| 3359.21| 3278.08| 1.04| 1.07| 1.02| | 10| 4242.61| 4107.91| 4007.28| 1.03| 1.06| 1.03| | 13| 5486.04| 5276.60| 5125.12| 1.04| 1.07| 1.03| | 16| 6593.49| 6397.08| 6099.44| 1.03| 1.08| 1.05| | 20| 8213.80| 7892.04| 7620.54| 1.04| 1.08| 1.04| | 25| 9741.36| 9384.96| 9147.84| 1.04| 1.06| 1.03| | 31| 11451.32| 11187.64| 10800.05| 1.02| 1.06| 1.04| | 38| 13011.22| 12667.32| 12291.01| 1.03| 1.06| 1.03| | 46| 14476.64| 14696.75| 14148.79| 0.99| 1.02| 1.04| | 56| 15384.29| 16719.64| 16129.38| 0.92| 0.95| 1.04| | 68| 16009.93| 17314.29| 16661.99| 0.92| 0.96| 1.04| | 82| 16306.16| 18031.60| 17343.99| 0.90| 0.94| 1.04| | 100| 16473.30| 18829.94| 18174.39| 0.87| 0.91| 1.04| | 120| 16211.14| 19339.61| 18820.19| 0.84| 0.86| 1.03| | 145| 15154.42| 19709.99| 19047.21| 0.77| 0.80| 1.03| | 175| 14703.15| 19847.54| 19112.94| 0.74| 0.77| 1.04| | 210| 14521.28| 19763.78| 19106.66| 0.73| 0.76| 1.03| | 250| 14334.64| 19592.67| 19063.99| 0.73| 0.75| 1.03| | 300| 14111.23| 19443.93| 18972.00| 0.73| 0.74| 1.02| | 360| 13994.61| 19301.72| 18799.99| 0.73| 0.74| 1.03| | 430| 13763.52| 19174.62| 18630.59| 0.72| 0.74| 1.03| | 520| 13485.27| 19270.05| 18622.28| 0.70| 0.72| 1.03|