October 2009
1 post
1 tag
How big is my MySQL database?
mysql> SELECT table_schema, sum(data_length) / 1024 / 1024 "data", sum(index_length) / 1024 / 1024 "index", sum( data_length + index_length ) / 1024 / 1024 "total" FROM information_schema.TABLES GROUP BY table_schema \G; *************************** 1. row *************************** table_schema: aardvarks_development data: 5297.32812500 index: 4407.93750000 total:...