dansku/mysql notes.md

Last active March 26, 2019 15:40

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/dansku/d1ac47f8ed47f8c65cba53885a4e2c05.js"></script>
Save dansku/d1ac47f8ed47f8c65cba53885a4e2c05 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

mysql notes.md

Calculate database size:

SELECT table_schema "db_name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Count total rows in database:

SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'db_name';

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