Customer Support

A quick script to show you how much disk space all your tables in a
database are using:

<?

  mysql_connect("db.modwest.com", "username", "password");
  mysql_select_db("yourdb");

  $result = mysql_query("show table status");

  $size = 0;
  $out = "";
  while($row = mysql_fetch_array($result)) {
      $size += $row["Data_length"];
      $out .= $row["Name"] .": ". 
                   round(($row["Data_length"]/1024)/1024, 2) ."<br>\n";
  }

  $size = round(($size/1024)/1024, 1);

  echo $out ."<br>\n";
  echo "Total MySQL db size: $size";
?>

Actually if you really want to know the total disk usage, you need to
add in the index_length as well as the data_length in the script above.

If you simply want to know the total size, the query below will do the
trick (in bytes): 

select SUM(data_length) from information_schema.tables where
table_schema = 'mydb';

there is missing on the above comment.. it only summed the data_lenght..
it should be 

select SUM(data_length) + SUM(index_length) as size from
information_schema.tables where table_schema = 'mydb';