Optimize All Tables In A MySQL Database

Submitted by:Jhon Jhon

Date added:02 November, 2011


If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

Tags: optimize mysql database

Code Snippet:

$alltables = mysql_query("SHOW TABLES");
while ($table = mysql_fetch_assoc($alltables))
foreach ($table as $db => $tablename)
mysql_query("OPTIMIZE TABLE '".$tablename."'")
or die(mysql_error());