Axel Schwenke wrote:

> http://yoshinorimatsunobu.blogspot.fi/2012/12/non-persistent-connection-performance.html
> 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

<<inline: tps_mysql56.png>>

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to