SHOW TABLE STATUS dbname

返回數組：

Name: xxx (表名)

Engine: MyISAM (表引擎)

Version: 10 (版本)

Row_format: Dynamic (行格式)

Rows: (表內總行數)

Avg_row_length: (平均每行大小，這里是4.7K)

Data_length: (該表總大小，單位字節)

Max_data_length: (該表可存儲上限)

Index_length: (索引大小)

Data_free: (數據多余)

Auto_increment: (自動累加ID 6W9，而前面的行數只有5W6，說明我有刪掉了1W3筆數據)

Create_time:

Update_time:

Check_time:

Collation: 編碼

Checksum:

Create_options: row_format=DYNAMIC

Comment: (注釋)

數據庫的大小=表結構+表數據+索引 實際情況大多采用Data_length+Index_length

實例代碼：test數據庫名，可以接 like 表。SHOW TABLE STATUS FROM `test` like biao

(注：+9000的意思，數據庫文件中有個.frm無法通過代碼取得其大小，而此文件的大約是9k，或者更大)

include ("comment.php");

$sql="SHOW TABLE STATUS FROM `cx_fcd` ";

$result = mysql_query($sql);

$array=mysql_fetch_array($result,MYSQL_ASSOC);

$t=0;

$result1 = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

$lycs[]=$row;

$t+=$row['Index_length']+$row['Data_length']+9000;

}//取得新聞列表

echo

"表名：".$array['Name']."，Data_length大

小：".$array['Data_length']."，Index_length大小：".$array['Index_length']."，總大

小：".($array['Data_length']+$array['Index_length'])."
";

echo "數據庫大小：".round($t/1024)."KB
";

print_r($lycs);

?>

下面是顯示部分結果，(實際數據庫大小為：258 KB 相差16KB)

表名：cx_admin_nav，Data_length大小：208，Index_length大小：2048，總大小：2256

數據庫大小：242KB

Array ( [0] => Array ( [Name] => cx_ejcontent [Engine] =>

MyISAM [Version] => 10 [Row_format] => Dynamic [Rows] => 0

[Avg_row_length] => 0 [Data_length] => 0 [Max_data_length] =>

281474976710655 [Index_length] => 1024 [Data_free] => 0

[Auto_increment] => 1 [Create_time] => 2010-06-24 08:30:24

[Update_time] => 2010-06-24 08:30:26 [Check_time] => [Collation]

=> utf8_general_ci [Checksum] => [Create_options] => [Comment]

=> ) [1] => Array ( [Name] => cx_ejsub_details [Engine] =>

MyISAM [Version] => 10 [Row_format] => Dynamic [Rows] => 0

[Avg_row_length] => 0 [Data_length] => 0 [Max_data_length] =>

281474976710655 [Index_length] => 1024 [Data_free] => 0

[Auto_increment] => 1 [Create_time] => 2010-06-24 08:31:18

[Update_time] => 2010-06-24 08:31:20 [Check_time] => [Collation]

=> utf8_general_ci [Checksum] => [Create_options] => [Comment]

=> ) )

總結

以上是生活随笔為你收集整理的MYSQL数据库表大小计算,计算mysql数据库数据表的大小，不精确，只是大略的数据...的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。