SELECT table_schema "[Data Base Name Which you want o know]", sum( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Enjoy querying, cheers.
Powered by MySQL:
Friday
Check the size of your database, MySQL
Hello, folks, often times, we might want to know, how big a particular database size is. Here is a very simple, one-line query for you to check a database size on MySQL.
SELECT table_schema "[Data Base Name Which you want o know]", sum( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Enjoy querying, cheers.
Powered by MySQL:
SELECT table_schema "[Data Base Name Which you want o know]", sum( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Enjoy querying, cheers.
Powered by MySQL:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment