MySQL » History » Version 1
Marc Dequènes, 2018-05-02 17:49
| 1 | 1 | Marc Dequènes | h1. MySQL |
|---|---|---|---|
| 2 | |||
| 3 | h2. Databases Sizes |
||
| 4 | |||
| 5 | <pre> |
||
| 6 | SELECT table_schema AS dbname, ROUND( SUM( data_length + index_length ) /1024 /1024, 1 ) AS size |
||
| 7 | FROM information_schema.tables |
||
| 8 | GROUP BY table_schema |
||
| 9 | ORDER BY size DESC |
||
| 10 | </pre> |