PHP method to calculate the size of the entire mysql database, PHP calculation mysql database_PHP tutorial

How PHP calculates the size of the entire mysql database, PHP calculates the size of the mysql database

The example in this article describes how PHP calculates the size of the entire mysql database. Share it with everyone for your reference. The details are as follows:

The calculation result is returned here in the format of MB, KB or GB.

function CalcFullDatabaseSize($database, $db) {
  $tables = mysql_list_tables($database, $db);
  if (!$tables) { return -1; }
  $table_count = mysql_num_rows($tables);
  $size = 0;
  for ($i=0; $i < $table_count; $i++) {
    $tname = mysql_tablename($tables, $i);
    $r = mysql_query("SHOW TABLE STATUS FROM ".$database." LIKE '".$tname."'");
    $data = mysql_fetch_array($r);
    $size += ($data['Index_length'] + $data['Data_length']);
  };
  $units = array(' B', ' KB', ' MB', ' GB', ' TB');
  for ($i = 0; $size > 1024; $i++) { $size /= 1024; }
  return round($size, 2).$units[$i];
}
/*
** Example:
*/
// open mysql connection:
$handle = mysql_connect('localhost', 'user', 'password'); 
if (!$handle) { die('Connection failed!'); }
// get the size of all tables in this database:
print CalcFullDatabaseSize('customer1234', $handle);
// --> returns something like: 484.2 KB
// close connection:
mysql_close($handle);

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/1019453.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1019453.htmlTechArticleHow to calculate the size of the entire mysql database in php, how to calculate the size of the entire mysql database in php. This article explains how to calculate the size of the entire mysql database in php. method. Share it with everyone for your reference. The details are as follows...