20 Mar
2013
20 Mar
'13
4:42 p.m.
Axel Schwenke wrote:
http://yoshinorimatsunobu.blogspot.fi/2012/12/non-persistent-connection-perf... My results don't match Yoshis otherwise. See yourself.
OK, I found what makes the difference between Yoshis results and mine. It's the performance schema. It defaults to being enabled in 5.6.10 and has a rather huge impact. The attached graph shows how different privilege types and enabling/disabling performance schema affect the connect performance of MySQL-5.6.10. The workload is connect, point-select, disconnect. Single InnoDB table with just 1000 rows. Mysqld using tcmalloc. I'm collecting more data and will publish this on the MariaDB blog by the end of the week. XL
