Optimize My SQL
Table, clear Overhead
Command optimize table:
OPTIMIZE TABLE history;
1.You will see a list of tables and the “Overhead” column on
the right. Click on one of the sizes under the “Overhead” column.
2. Click on “Optimize Table
3. Most PHPMyAdmin tools provide the option to optimize your
database tables. You should see a significant increase in performance if you’ve
never done this before.
Optimize My SQL Database
Simple command to
automatically check, repair and optimize all tables in all databases when
you're running a My SQL server
mysqlcheck -u root -p --auto-repair --optimize
--all-databases
