📜 ⬆️ ⬇️

mysqlcheck and optimize InnoDB tables

Just noticed that if you do
mysqlcheck -o --repair db_name
and your tables in InnoDB, not only repair does not occur (which should not, since the engine does not support this function), but optimize does not work either.
That is, the base remains without optimize and you do not notice!

If you do this:
mysqlcheck -o db_name
, then recreate each table.

Because of this, my optimize has not been executed by a crown script for half a year already, since the transition from MyISAM to InnoDB.
')
PS: In my case, innodb_file_per_table is used.

Source: https://habr.com/ru/post/138324/


All Articles