PHP / MySQL Database Optimization Function
After frequent record deletion from your MySQL database tables, your tables can acquire overhead. Overhead is empty space left inside the database table due to the deletions. A great way to speed up your MySQL database, not to mention keep it compact, is to use a simple PHP function to optimize your database tables:
/* OPTIMIZE ALL TABLES */
function optimize_database($DATABASE_LINK) {
$result = mysql_query('SHOW TABLES', $DATABASE_LINK) or die('Cannot get tables');
while($table = mysql_fetch_row($result)) {
mysql_query('OPTIMIZE TABLE '.$table[0], $DATABASE_LINK) or die('Cannot optimize '.$table[0]);
}
}
I use the $DATABASE_LINK variable to keep my connection throughout my PHP script. Obviously it's not required, so you can modify the above function if you don't keep that variable.
![9 Mind-Blowing Canvas Demos]()
The <canvas> element has been a revelation for the visual experts among our ranks. Canvas provides the means for incredible and efficient animations with the added bonus of no Flash; these developers can flash their awesome JavaScript skills instead. Here are nine unbelievable canvas demos that...
![CSS Animations Between Media Queries]()
CSS animations are right up there with sliced bread. CSS animations are efficient because they can be hardware accelerated, they require no JavaScript overhead, and they are composed of very little CSS code. Quite often we add CSS transforms to elements via CSS during...
![HTML5’s placeholder Attribute]()
HTML5 has introduced many features to the browser; some HTML-based, some in the form of JavaScript APIs, but all of them useful. One of my favorites if the introduction of the placeholder attribute to INPUT elements. The placeholder attribute shows text in a field until the...
![PHP Woot Checker – Tech, Wine, and Shirt Woot]()
If you haven't heard of Woot.com, you've been living under a rock. For those who have been under the proverbial rock, here's the plot:
Every day, Woot sells one product.
Once the item is sold out, no more items are available for purchase.
You don't know how many...
Dear sir,
where we use this function?
i need help, my hosting SQl is overhead
i use this function in my function Class php file and upload it
but i see it still overhead
let me know how to use it
reply back
With a PHP script, you can have it as a stand alone (with connection info), or you can put it as part of your code, as I have.
Great script. I was looking for a way to compact a MySQL database, and this is perfect. Thanks.
This article is like my ass,
its big shit
@trimd: hei trimd, you so stupid!
if you want fast compact you can make a program with delphi or VB6 to compact it. i make a application to compact my mysql database 370MB (7years period) become 90MB. Look more carefully trimd.
make a little application to compact it, use Delphi or VB6
don’t look others samples
grow trimd !
for more explanation go to mysql site.
or dev forum for VB
try to become great programmer.
not like junior!
Thanks, for the scripts because so far I have only seen two, the one for backing up the tables and this one above. They all look to be great and I’m use them in the my project.
Thanks. I grabbed this code and created a WP plugin. Thanks again. :-)