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.

MySQL Load high

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

  1. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    300
    Likes Received:
    1
    Trophy Points:
    18
    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?
     
  2. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    300
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page