Identifying current MySQL disk space

So that we can quote accurately, its important that we know how much MySQL disk space you are currently consuming for your Magento store.

Fortunately, you can quickly find out and serve us the information we need by running the following command.

SELECT 
IFNULL(B.engine,'Total') "Storage Engine", CONCAT(LPAD(REPLACE(FORMAT(B.DSize/POWER(1024,pw),3),',',''),17,' '),' ',SUBSTR(' KMGTP',pw+1,1),'B') "Data Size", CONCAT(LPAD(REPLACE(FORMAT(B.ISize/POWER(1024,pw),3),',',''),17,' '),' ',SUBSTR(' KMGTP',pw+1,1),'B') "Index Size", CONCAT(LPAD(REPLACE(FORMAT(B.TSize/POWER(1024,pw),3),',',''),17,' '),' ',SUBSTR(' KMGTP',pw+1,1),'B') "Table Size" FROM (SELECT engine,SUM(data_length) DSize,SUM(index_length) ISize,SUM(data_length+index_length) TSize 
FROM information_schema.tables 
  WHERE table_schema NOT IN ('mysql','information_schema','performance_schema') 
  AND engine IS NOT NULL 
GROUP BY engine 
WITH ROLLUP) B,(SELECT 3 pw) A 
ORDER BY TSize;

This command will then show summaries of all usage like so:

+----------------+----------------------+----------------------+----------------------+
| Storage Engine | Data Size            | Index Size           | Table Size           |
+----------------+----------------------+----------------------+----------------------+
| MEMORY         |             0.000 GB |             0.000 GB |             0.000 GB |
| InnoDB         |             0.189 GB |             0.109 GB |             0.297 GB |
| MyISAM         |             0.413 GB |             0.075 GB |             0.488 GB |
| Total          |             0.602 GB |             0.184 GB |             0.785 GB |
+----------------+----------------------+----------------------+----------------------+

Table size is produced by adding the data size to the index size.

In this case, your total MySQL usage would be 0.785GB.