User Tools

Site Tools


mysql_database_sizes

Warning: Undefined variable $html in /usr/share/nginx/html/lib/plugins/tabinclude/helper.php on line 240

Database/Table Sizes

  • database size
  • table size

# mysql --silent --table
or

[mysql]
silent
table


Size of ALL databases

Note: You do not need to change the 'Database Name' entry

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 ; 

File size of a specific db

The following commands should be run inside mysql
Note: replace “Data Base Name” with the db name.

SELECT table_schema "Data Base Name",

    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",

    sum( data_free )/ 1024 / 1024 "Free Space in MB"

FROM information_schema.TABLES

WHERE table_schema = "$DATABASE_NAME";


mysql_database_sizes.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki