maria-developers team mailing list archive

[Axel Schwenke <axel@xxxxxxxxxxxx>]

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