Hi

I read in "MySQL, Fifth Edition" by Paul DuBois that we should do a regular mysqlcheck.

We have all InnoDB tables. As far as I unterstand the tables get read and write locked during mysqlcheck.

The database will grow 100x in size, at the moment only initial load.

It means big downtime.

Code:
$ time mysqlcheck --all-databases
[...]

real    29m41.449s
user    0m0.019s
sys     0m0.015s
Code:
mysql> SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024
    -> "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
+--------------------+----------------------+
| Data Base Name     | Data Base Size in MB |
+--------------------+----------------------+
| imzweffefr         |       38420.97170544 |
| information_schema |           0.00781250 |
| mysql              |           0.63046169 |
+--------------------+----------------------+
3 rows in set (5.86 sec)
You all do mysqlcheck? Is it really mandatory? What's the risk if I don't do it regularly?

Other DBA do mysqlcheck?