如何获取MySQL数据库的真实大小？ [英] How to Get True Size of MySQL Database?

问题描述

我想知道MySQL数据库使用多少空间，以便选择一个网络主机。
我发现命令 SHOW TABLE STATUS LIKE'table_name'所以当我做查询，我得到这样：

I would like to know how much space does my MySQL database use, in order to select a web host. I found the command SHOW TABLE STATUS LIKE 'table_name' so when I do the query, I get something like this:

Name       | Rows | Avg. Row Length | Data_Length | Index Length
----------   ----   ---------------   -----------   ------------
table_name   400          55            362000        66560

因此，我拥有 362000 或400 * 362000 = 144800000 个字节的数据？
索引长度是什么意思？
谢谢！

So do I have 362000 or 400*362000 = 144800000 bytes of data for this table? And what does Index Length mean? Thanks !

推荐答案

来自S. Prakash在 MySQL论坛：

From S. Prakash found at the MySQL forum:

SELECT table_schema "Data Base Name",
    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; 

这篇关于如何获取MySQL数据库的真实大小？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！