/* PHP & MySQL Journal */
Below is a small script that lets you read the table sizes of a MySQL database.
<?php $link = mysql_connect('host', 'username', 'password'); $db_name = "your database name here"; $tables = array(); mysql_select_db($db_name, $link); $result = mysql_query("SHOW TABLE STATUS"); while($row = mysql_fetch_array($result)) { /* We return the size in Kilobytes */ $total_size = ($row[ "Data_length" ] + $row[ "Index_length" ]) / 1024; $tables[$row['Name']] = sprintf("%.2f", $total_size); } print_r($tables); ?> |
It will return data like the following for a ‘wordpress’ database:
Array ( [wp_comments] => 80.00 [wp_links] => 48.00 [wp_options] => 224.00 [wp_pollsa] => 16.00 [wp_pollsip] => 16.00 [wp_pollsq] => 16.00 [wp_postmeta] => 48.00 [wp_posts] => 112.00 [wp_term_relationships] => 32.00 [wp_term_taxonomy] => 32.00 [wp_terms] => 48.00 [wp_usermeta] => 48.00 [wp_users] => 48.00 ) |
2 Responses
1
Pablo
February 5th, 2009 at 5:29 am
Great script, simple and useful!
2
Jo
April 6th, 2010 at 8:28 pm
so far this the best i found on internet. useful even i’m not fully understand how it work. but this is want i want. thanks