What is best and safe way to optimize all databases on server?

ditto

Verified User
Joined
Apr 27, 2009
Messages
2,505
I don't know the best way to do it, but I do it like this:
Code:
mysqlcheck --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --auto-repair --optimize --all-databases
What I would like, is to automatically exclude all innodb-tables from the command, because it is not possible to optimize those, and they are then being recreated instead, and that takes up a lot of time and cpu. It might not be possible exclude innodb in the command, but if somone know how to, please share it here. :)
 
Top