How to Get True Size of MySQL Database?

by

From S. Prakash, found at the MySQL forum:

SELECT table_schema "database name",
    sum( data_length + index_length ) / 1024 / 1024 "database size in MB",
    sum( data_free )/ 1024 / 1024 "free space in MB"
FROM information_schema.TABLES
GROUP BY table_schema;

Or in a single line for easier copy-pasting:

SELECT table_schema "database name", sum( data_length + index_length ) / 1024 / 1024 "database size in MB", sum( data_free )/ 1024 / 1024 "free space in MB" FROM information_schema.TABLES GROUP BY table_schema;

More Related Contents:

  1. What column type/length should I use for storing a Bcrypt hashed password in a Database?
  2. Implementing Comments and Likes in database
  3. How to check if mysql database exists
  4. difference between primary key and unique key
  5. How to shrink/purge ibdata1 file in MySQL
  6. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  7. Difference Between Schema / Database in MySQL
  8. How do I add a custom CHECK constraint on a MySQL table?
  9. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  10. Implementing a hierarchical data structure in a database
  11. Does MySQL allows to create database with dot?
  12. Commit data in a mysql container
  13. Laravel join with 3 Tables
  14. Difference between two table structure
  15. When to use MyISAM and InnoDB? [duplicate]
  16. How to insert a file in MySQL database?
  17. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  18. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  19. Rename a table in MySQL
  20. Where does MySQL store database files on Windows and what are the names of the files?
  21. How to find all the relations between all mysql tables?
  22. Should I normalize my DB or not?
  23. How to speed up sql queries ? Indexes?
  24. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  25. How do I alter a mysql table column defaults?
  26. Selecting distinct 2 columns combination in mysql
  27. How to store a one to many relation in MySQL database?
  28. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  29. MySQL and PDO: Could PDO::lastInsertId theoretically fail?
  30. MySQL: Computed Column

Leave a Comment