How do you know MySQL is the bottleneck?

rackaid

Well-Known Member
Jan 18, 2003
89
27
168
Jacksonville, FL
cPanel Access Level
DataCenter Provider
How do you know MySQL is the bottleneck?

I often find that people jump into the database layer without getting a good view of what's happening.

You can waste a lot of time trying to tune settings for tuning's sake.

If you really want to make WP fly, then you need to profile your application to understand what's causing the loads and set realistic goals for performance.


I always use tools like NewRelic and webpagetest.org to get as close as I can a real-world view of the user experience. Using these tools, I think tune the systems for better load times and especially start render times.

For example ...

After a recent case a customer contacted me and complained that after our optimizations his server was using more RAM and CPU than it ever had in the past -- assuming this was a bad thing.

In fact, this was true. CPU and RAM usage were up about 25% over baseline but max throughout was increased by 3.5X and page render times cut by 40%.

So always tune with the end user in mind and change things slowly to assure you are getting the real-world result you want.

Lastly, when it comes to WP the biggest problem is plugins.

I recently blogged about this:
http://www.rackaid.com/blog/wordpress-slow-speed-up/