Improving on MySQL

Garp · 18-11-2009, 17:19

In between documentation work recently, I've been looking at MySQL performance stuff.

I seem to be spending more and more of my time doing DBA work (despite not really being a forte of mine) so over the last 3-4 months I've been trying to broaden my knowledge of the area as much as possible.
One of the things I've routinely come across references to are Percona, Facebook and Google who between them are causing serious driving forward of MySQL development and all three have released various patches for MySQL that have resulted in significant performance improvements at their end, usually revolving around InnoDB. There is a group out there called OurDelta which includes Monty Widenius, the original author of MySQL, who produce a release of MySQL with all the patches rolled in and I thought I'd give it a shot by doing a direct swap in test, with no config changes to see the performance boost.

This is rather trivial and far from any absolute guaranteed performance measurement, but it's interesting to see how much faster a standard demo version of Magento can behave just using the OurDelta builds of MySQL:

That's a 35% increase in the throughput of queries per second. The test scenario was the same, using Siege to carry out 5 simultaneous page requests against the localhost requesting 1 of 14 different urls, and left running constantly overnight.
I'm hoping at some point to get to run it against my full barrage of Magento data (100k products) on a dedicated server. Could be interesting to see how much better it handles significant load.

18-11-2009, 17:19	#1
Garp Preparing more tumbleweed Join Date: Jun 2006 Location: Hawaii Posts: 6,038	Improving on MySQL In between documentation work recently, I've been looking at MySQL performance stuff. I seem to be spending more and more of my time doing DBA work (despite not really being a forte of mine) so over the last 3-4 months I've been trying to broaden my knowledge of the area as much as possible. One of the things I've routinely come across references to are Percona, Facebook and Google who between them are causing serious driving forward of MySQL development and all three have released various patches for MySQL that have resulted in significant performance improvements at their end, usually revolving around InnoDB. There is a group out there called OurDelta which includes Monty Widenius, the original author of MySQL, who produce a release of MySQL with all the patches rolled in and I thought I'd give it a shot by doing a direct swap in test, with no config changes to see the performance boost. This is rather trivial and far from any absolute guaranteed performance measurement, but it's interesting to see how much faster a standard demo version of Magento can behave just using the OurDelta builds of MySQL: That's a 35% increase in the throughput of queries per second. The test scenario was the same, using Siege to carry out 5 simultaneous page requests against the localhost requesting 1 of 14 different urls, and left running constantly overnight. I'm hoping at some point to get to run it against my full barrage of Magento data (100k products) on a dedicated server. Could be interesting to see how much better it handles significant load. __________________ Mal: Define "interesting"? Wash: "Oh, God, oh, God, we're all gonna die"?