code-diesel

/* PHP & MySQL Journal */

Getting MySQL table size with PHP

Posted in: mysql | Save to del.icio.us | Twit This! 4 Feb 2009

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
)

Share this post

	Share on Facebook
	Share on Twitter
	Share on StumbleUpon
	Share on Delicious

	Share on Digg
	Share on Technorati
	Share on Reddit
	Subscribe to site Feed

Other related posts

1 Response

1

February 5th, 2009 at 5:29 am

Great script, simple and useful!

Comment Form

Subscribe (RSS)

About this blog

This site is a digital habitat of Sameer, a freelance web developer working from Pune.More

Recent Posts

Reading Google Analytics data from PHP

‘isset’ construct and multiple parameters

Adding custom commands to Selenium

Test dependencies in PHPUnit 3.4

Creating win/win projects using Project Value Analysis

7 essential php command-line options

Sorting PHP arrays with substrings

Scanning web pages for malicious scripts

Reading MP3 file tags in PHP

The myth of Tableless design

Recent Comments

harendra: Please let me know if I can set the "Highlight Elements" option checked by default. Thanks, [...]
kiran aghor: wow great. thanks for sharing this. [...]
jcal: hello can you send me a tutorial in backward compatibility in browser [...]
yaver: helpppppp please ı dont understand because my english not very good but ı must learn selenium plea [...]
uberVU - social comments: Social comments and analytics for this post... This post was mentioned on Twitter [...]
Jonas: Nice, thanks a lot ! :) [...]
sameer: You are welcome to translate, Jonas! [...]
Jonas: Very good tutorial :) Can I translate it into French for my blog (xoodeo.com) ? [...]

Users Online

9 Users Online
8 Guests, 1 Bot