Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    158
    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/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

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

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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:
    16,170
    Likes Received:
    370
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    What part?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice