How to get the sizes of the tables in mysql database?

Question: How to get the sizes of the tables in mysql database?

SELECT table_name "Table Name",SUM( data_length + index_length ) / 1024 / 1024 "Table Size (MB)",SUM( data_free )/ 1024 / 1024 "Free Space(MB)" FROM information_schema.TABLES WHERE table_schema='mydb' GROUP BY table_name ORDER BY SUM(TABLE_ROWS) DESC

(Replace mydb with Your Database Name)

Output

Question: Get record counts for all tables along with size in MySQL database?

SELECT table_name "Table Name",SUM( data_length + index_length ) / 1024 / 1024 "Table Size (MB)",SUM( data_free )/ 1024 / 1024 "Free Space(MB)", SUM(TABLE_ROWS) AS "Total Record(S)" FROM information_schema.TABLES WHERE table_schema='mydb' GROUP BY table_name ORDER BY SUM(TABLE_ROWS) DESC

(Replace mydb with Your Database Name)

Output

Best Related Posts are Following:

1. How to install and Connect to MySQL in NodeJS?.
2. What is Super Key, Candidate keys and Alternate Key?.
3. MySQL Query Optimization Tips and Techniques.
4. How can I make SQL Query case sensitive string comparison on MySQL?.
5. DBMS Interview Questions and Answers for Freshers.
6. MySQL Interview Questions and Answers for Experienced.
7. Difference between inner join and outer join in MySQL.
8. How to get a list of MySQL user accounts?.
9. How to delete MySQL Binary logs Files in Wamp Server?.