MySQL
keyboard_arrow_down 295 guides
chevron_leftDatabase Cookbook
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Checking size of databases in MySQL
schedule Aug 12, 2023
Last updated local_offer
Tags MySQL
Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
We can query the information_schema.tables table to check the size of databases in MySQL.
Syntax
The general syntax is as follows:
SELECT table_schema "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "Size in MB" FROM information_schema.tables GROUP BY table_schema;
Examples
To check the size of all databases:
SELECT table_schema "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "Size in MB" FROM information_schema.tables GROUP BY table_schema;
+--------------------+------------+| Database | Size in MB |+--------------------+------------+| mysql | 4.1 || information_schema | 0.0 || performance_schema | 0.0 || sys | 0.0 || people | 0.4 |+--------------------+------------+
To check the size of a database called people:
SELECT table_schema "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "Size in MB" FROM information_schema.tables WHERE table_schema = 'people';
+----------+------------+| Database | Size in MB |+----------+------------+| people | 0.4 |+----------+------------+
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
