How to index rebuild in MySQL for all tables in a database? -

5 , have index rebuild tables in database in innodb. know optimize did @ table level. there way tables in database in 1 go.

you can try this:

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases