How much MySQL disk space is being used

So that we can quote accurately, it's important that we know how much MySQL disk space you are currently consuming for your Magento or Adobe Commerce store.

You can easily find out 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.

Data Size + Index Size = MySQL usage

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