wilkice/a.md

Last active January 27, 2022 16:57

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

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

Download ZIP

常用SQL #sql

Raw

a.md

show db disk usage

select table_schema, sum((data_length+index_length)/1024/1024) AS "Total size(table+index) Mb", sum(data_length/1024/1024) as "table size", sum(index_length/1024/1024) as "index size" from information_schema.tables group by table_schema;