Total members 11889 |It is currently Fri Mar 29, 2024 6:00 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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.

Code:

<?php



dbConnect
()



$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());

   }

   

}



?>





_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : Optimize All Tables In A MySQL Database
 Database Cashing tables results model     -  
 dump Mysql database     -  
 import Mysql database     -  
 Creating a Database in MySQL     -  
 IP Address Lookup in Bulk Using C-Sharp and MySQL Database     -  
 Add two tables     -  
 Generating Tables from XML by php     -  
 Persisting a class into two tables     -  
 need help in mysql     -  
 connect to MYSQL from ASP     -  



Topic Tags

PHP Database






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com