The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How do you know MySQL is the bottleneck?

Discussion in 'Workarounds and Optimization' started by rackaid, Feb 26, 2014.

  1. rackaid

    rackaid Active Member

    Joined:
    Jan 18, 2003
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    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/
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,470
    Likes Received:
    198
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    I've moved this to its own thread. It deserves it's own thread.

    Thanks!
     
  3. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    it's partially an advert ;p
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,470
    Likes Received:
    198
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    What part?
     
Loading...

Share This Page