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.
Asked
Active
Viewed 275 times
1
-
what you mean size here – PSR Apr 19 '13 at 06:44
-
1Do you use phpmyadmin? It should have this info available in the tables' list. – Andrius Naruševičius Apr 19 '13 at 06:47
-
Or this query from http://stackoverflow.com/questions/1733507/how-to-get-size-of-mysql-database – Andrius Naruševičius Apr 19 '13 at 06:49
2 Answers
2
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
Dipesh Parmar
- 27,090
- 8
- 61
- 90
-1
use this query
show table status from <db_name>;
if your database name is users; then use this :
show table status from users;
Suhel Meman
- 3,702
- 1
- 18
- 26