article Query to retrieve MySQL database size

If you need to determine how much data a MySQL database is consuming, use the information_schema database and run the following command:

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, up.time is using ~ 4.03 GB. Note that this does not necessarily mean that the MySQL database file is 4.03 GB as it is generally much larger.

Related Articles


How to monitor MySQL Databases with up.time

RatingViews
article

Find out how to use up.time to effectively monitor your MySQL servers and database structures.

By: uptime Support | Date Created: 5-17-2007 | Last Modified: 6-28-2011 | Index: 176

  10967

Shrinking your MySQL DataStore

RatingViews
article

At times it may be necessary to reduce the disk space that your MySQL DataStore consumes on your monitoring station. The process of reducing your DataStore size follows the general steps that are...

By: uptime Support | Date Created: 7-31-2006 | Last Modified: 2-19-2014 | Index: 088

  11225

Securing the up.time MySQL Database

RatingViews
article

By: uptime Support | Date Created: 3-3-2006 | Last Modified: 7-28-2011 | Index: 058

  4042

Default MySQL Database Users and Permissions

RatingViews
article

This article outlines the MySQL database users that are installed with up.time and their permissions

By: uptime Support | Date Created: 7-6-2007 | Last Modified: 6-28-2011 | Index: 211

  3594

Migrating Your DataStore To a New Database

RatingViews
article

This article outlines how to move your DataStore between different database types.

By: uptime Support | Date Created: 2-21-2007 | Last Modified: 6-30-2011 | Index: 142

  4620

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement