tiller1010/mysql-measure-db.sql

Created April 10, 2024 17:06

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tiller1010/a1b0ddfa68053ff40b5657f17beee300.js"></script>
Save tiller1010/a1b0ddfa68053ff40b5657f17beee300 to your computer and use it in GitHub Desktop.

Download ZIP

Measure a database size in MySQL

Raw

mysql-measure-db.sql

select table_schema 'DB', ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"  FROM information_schema.tables where table_schema = 'SS_sitedb' GROUP BY table_schema;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment