Friday, February 1, 2013

How to get database size in MySql

SELECT table_schema "DB Name", sum( data_length + index_length ) / 1024 / 1024 "DB Size in MB" 
FROM information_schema.TABLES GROUP BY table_schema ;


No comments:

Post a Comment

The baffling IQ test

Getting 100 per cent means you “have a passion for perfection and you like to challenge yourself. You excel in finding problems and solutio...