SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", sum( data_free )/ 1024 / 1024 "Free Space in MB" FROM information_schema.TABLES WHERE table_schema = '<DATABASE NAME>' GROUP BY table_schema ;
In my blog, i would discuss the problem i face in daily routine. Following are some of them: mysql error, mysql replication, mysql database corrupted repair, innodb tablespace corruption, mysql storage engines, mysql optimization and tuning, reinstall mysql linux server, linux command for dummies, linux administration tips, mysql administration tips, Linux server benchmarking
Wednesday, February 9, 2011
MySQL - to check dabatase size
Labels:
MySQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment