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!

MySQL Load high

Discussion in 'Database Discussion' started by sahostking, Oct 12, 2014.

  1. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    330
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    Hi guys,

    I'm trying to get load down a bit in mysql and optimized my.cnf quite considerably.

    However one thing I cannot figure out is when I run the following:

    /usr/bin/mysqlcheck --auto-repair --optimize --all-databases

    It seems to return this message alot:

    Table does not support optimize, doing recreate + analyze instead

    I want to run a cron every night so what is the best way to optimize tables that return the above?

    Any ideaS?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    330
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Have you verified that repairing/optimizing your databases on a nightly basis leads to increased performance? You may want to try it out for a few nights and see if makes a difference before setting it to happen on a regular basis.

    Thank you.
     
    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