SELECT table_name, round(((data_length + index_length) / (1024*1024)), 2) AS "Size (MiB)" FROM information_schema.tables WHERE table_schema = "your_schema_name";
4 February 2011
MySQL Tables Sizes
Labels:
mysql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment