1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| <?php
mysql_connect('localhost','username','password');
$alldbs=mysql_query("SHOW DATABASES");
while ($dbs = mysql_fetch_assoc($alldbs)) {
foreach($dbs as $db_name){
if($db_name=='information_schema' || $db_name=='mysql')continue;
mysql_select_db($db_name);
echo '<strong>database: '.$db_name.'</strong><br />';
$alltables = mysql_query("SHOW TABLES");
while ($table = mysql_fetch_assoc($alltables)) {
foreach ($table as $db => $tablename) {
echo 'optimising '.$tablename.'<br />';
mysql_query("OPTIMIZE TABLE `".$tablename."`") or die(mysql_error());
}
}
}
}
?>
|
轉載自 : http://verens.com/archives/2009/01/25/optimise-all-tables-in-all-mysql-dbs-on-your-server/
