Page History
If you need to determine how much data a MySQL database is consuming, use the information_schema database and run the following command:
| Code Block | ||
|---|---|---|
| ||
mysql> use information_schema; |
...
mysql> select table_schema, sum(data_length)/1024/1024 from tables group by table_schema; |
...
table_schema |
...
sum(data_length)/1024/1024 |
...
---------------------------- +
information_schema |
...
0.00000000 |
...
mysql |
...
0.41797256 |
...
uptime |
...
4031.60937500 |
...
3 rows in set (1.04 sec) |
In the example above, Uptime Infrastructure Monitor UIM is using ~ 4~4.03 GB. 
Note
| Info |
|---|
This does not necessarily mean that the MySQL database file is 4.03 GB as it is generally much larger. |
...