Return to Question

improved formatting

Source Link

edit approved Sep 14, 2012 at 13:06

70.5k
22
177
321

withoutWithout having to script an 'optimize table' query to do all the databases/tables, we would like to run mysqlcheck --optimize --all-databasemysqlcheck --optimize --all-database instead.

What are the drawbacks of doing this through mysqlcheck ?

mysqlcheck; both would defragment the tables right, correct?

tia

without having to script an 'optimize table' query to do all the databases/tables, we would like to run mysqlcheck --optimize --all-database instead.

What are the drawbacks of doing this through mysqlcheck ?

both would defragment the tables right?

tia

Without having to script an 'optimize table' query to do all the databases/tables, we would like to run mysqlcheck --optimize --all-database instead.

What are the drawbacks of doing this through mysqlcheck; both would defragment the tables, correct?

Source Link

asked Aug 22, 2012 at 23:45

Tom C

MySQL Innodb: What is the difference between running 'mysqlcheck --optimize --all-database' compared to running 'optimize table' in the mysql client?

without having to script an 'optimize table' query to do all the databases/tables, we would like to run mysqlcheck --optimize --all-database instead.

What are the drawbacks of doing this through mysqlcheck ?

both would defragment the tables right?

tia

mysql innodb