запрос для оптимизации

всем привет,подскажите запрос на оптимизацию таблиц в базе данных

DROP DATABASE name

Dark_AKC , ето для оптимизации таблицы?

Trashed ,

 <?php 
 echo '<pre>' . "\n\n"; 
 set_time_limit( 100 ); 
 // 
 $time = microtime(); 
 $time = explode(' ', $time); 
 $time = $time[1] + $time[0]; 
 $start = $time; 
 // 
 //Connection variables : 
 $h = 'localhost'; 
 $u = ''; 
 $p = ''; 
 // 
 $dummy_db = ''; 
 // 
 /*The php->mysql API needs to connect to a database even when executing scripts like this. 
 If you got an error from this(permissions), 
 just replace this with the name of your database*/ 
 // 
 $db_link = mysql_connect($h,$u,$p); 
 // 
 $res = mysql_db_query($dummy_db, 'SHOW DATABASES', $db_link) or die('Could not connect: ' . mysql_error()); 
 echo 'Found '. mysql_num_rows( $res ) . ' databases' . "\n"; 
 $dbs = array(); 
 while ( $rec = mysql_fetch_array($res) ) 
 { 
 $dbs [] = $rec [0]; 
 } 
 // 
 foreach ( $dbs as $db_name ) 
 { 
 echo "Database : $db_name \n\n"; 
 $res = mysql_db_query($dummy_db, "SHOW TABLE STATUS FROM `" . $db_name . "`", $db_link) or die('Query : ' . mysql_error()); 
 $to_optimize = array(); 
 while ( $rec = mysql_fetch_array($res) ) 
 { 
 if ( $rec['Data_free'] > 0 ) 
 { 
 $to_optimize [] = $rec['Name']; 
 echo $rec['Name'] . ' needs optimization' . "\n"; 
 } 
 } 
 if ( count ( $to_optimize ) > 0 ) 
 { 
 foreach ( $to_optimize as $tbl ) 
 { 
 mysql_db_query($db_name, "OPTIMIZE TABLE `" . $tbl ."`", $db_link ); 
 } 
 } 
 } 
 // 
 $time = microtime(); 
 $time = explode(' ', $time); 
 $time = $time[1] + $time[0]; 
 $finish = $time; 
 $total_time = round(($finish - $start), 6); 
 echo 'Parsed in ' . $total_time . ' secs' . "\n\n"; 
 ?>

Trashed (01.04.2019 в 14:08)
Dark_AKC , ето для оптимизации таблицы?

Я пошутил