MySQL Load high

sahostking

• October 12, 2014 10:44

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?

• 

  sahostking

  • October 12, 2014 15:55

  Would this work [url=http://howto.biapy.com/en/debian-gnu-linux/servers/mysql/setup-a-regular-analyze-and-optimization-defragmentation-of-mysql-tables]Setup a regular analyze and optimization / defragmentation of MySQL tables — Biapy Help Desk ./mysql-defragger --innodb --analyze

  0
• 

  cPanelMichael

  • October 13, 2014 17:48

  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.

  0

Please sign in to leave a comment.