How do you know MySQL is the bottleneck?

rackaid

• February 26, 2014 13:58

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:

• 

  Infopro

  • February 26, 2014 19:41

  I've moved this to its own thread. It deserves it's own thread. Thanks!

  0
• 

  thinkbot

  • February 27, 2014 10:37

  it's partially an advert ;p

  0
• 

  Infopro

  • February 27, 2014 11:06

  [quote="thinkbot, post: 1583262">it's partially an advert ;p
  What part?

  0

Please sign in to leave a comment.