Segmented key cache performance results for MariaDB 5.2.2-gamma
Recently I tested our new segmented key cache feature for MyISAM in MariaDB 5.2.2-gamma for performance gains. You can check our new features in MariaDB 5.2 in our Ask Monty Knowledge Base
You will also find the details about the segmented key cache feature in our Knowledge Base at:
We wrote a test in LUA for SysBench v0.5 called select_random_points.lua, to figure out the performance gain of splitting the key cache’s global mutex into several mutex under multi user load.
You can find all the details about the benchmark in our Knowledge Base article here:
The results were quite surprising, because we found up to 250% performance gain depending on the amount of concurrent users. On a side note we also found out that our new Intel system with 24 virtual cores has more than a 10 times performance advantage compared to our older 4 core system.
I already thought about this when looking at mariadb-tools, but also now looking at the results from Pitbull: I think 128 connections is not enough anymore! You barely reach the plateu after 64. You would need at least 512 or 1024 connections to verify that the performance doesn’t degrade (or increase, who knows?) with a large number of connections.
Great benchmarks and nice to have a powerful machine up there.
Henrik,
good input. Next round on pitbull will be with a lot more connections to see where our limits are.