I have a large Mysql database. Its size is more than what I expected.
How can I find size of its tables ? I need to find that table makes the database size huge.
Thank you.
- what you mean size herePSR– PSR2013-04-19 06:44:52 +00:00Commented Apr 19, 2013 at 6:44
- 1Do you use phpmyadmin? It should have this info available in the tables' list.Andrius Naruševičius– Andrius Naruševičius2013-04-19 06:47:26 +00:00Commented Apr 19, 2013 at 6:47
- Or this query from stackoverflow.com/questions/1733507/…Andrius Naruševičius– Andrius Naruševičius2013-04-19 06:49:26 +00:00Commented Apr 19, 2013 at 6:49
Add a comment |
2 Answers
You can do it as below.
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema Read Here
Comments
use this query
show table status from <db_name>; if your database name is users; then use this :
show table status from users; 