MySql optimiser les tables

shell> myisamchk -r tbl_name

< ?php
echo '
' . "\n\n";
set_time_limit( 160 );

$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$start = $time;

//Connection variables (A MODIFIER):
$h = 'localhost';
$u = 'root';
$p = "MON_PASSWORD";
//
$dummy_db = 'mysql';

/*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";
?>


	

59 comments

1. 

   kd 12 26 avril 2022 at 19:58

   I must show my gratitude for your kind-heartedness for men and women that must have guidance on this important idea. Your real dedication to getting the solution all through turned out to be exceedingly significant and have made guys and women much like me to attain their pursuits. Your own warm and helpful hints and tips indicates a lot a person like me and a whole lot more to my colleagues. Best wishes; from each one of us.

2. 

   g spot toy 5 mai 2022 at 13:37

   Im obliged for the blog. Really Great.

3. 

   Canadak 11 mai 2022 at 23:55

   ed meds online without doctor prescription prescription drugs best non prescription ed pills

4. 

   Edpills 13 mai 2022 at 2:01

   impotence pills ed pills comparison medication for ed

5. 

   supreme new york 13 mai 2022 at 19:50

   Thanks a lot for giving everyone remarkably remarkable opportunity to check tips from here. It’s always very great and as well , stuffed with a great time for me personally and my office acquaintances to search the blog not less than 3 times in a week to study the newest guidance you have. And lastly, I’m just at all times amazed with the perfect methods you give. Certain 1 facts in this posting are in fact the most suitable we’ve had.

6. 

   Onlikoel 17 mai 2022 at 2:48

   india pharmacy india pharmacies shipping to usa india pharmacies shipping to usa

7. 

   nike x off white 24 mai 2022 at 22:05

   I would like to express my admiration for your generosity giving support to women who really need help on the matter. Your real commitment to passing the solution around had become astonishingly advantageous and have truly made women much like me to get to their ambitions. Your informative recommendations means a great deal a person like me and especially to my office colleagues. With thanks; from each one of us.

8. 

   Cedric 25 mai 2022 at 15:04

   I didn’t know that.

9. 

   prescription meds without the prescription 29 mai 2022 at 10:01

   canada rx