Verificare la dimensione dei database in MySQL: Difference between revisions
Jump to navigation
Jump to search
m New page: Per verificare la dimensione di tutti i database, lanciare la query: <source lang=sql> SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 ... |
(No difference)
|
Latest revision as of 09:55, 8 September 2008
Per verificare la dimensione di tutti i database, lanciare la query:
<source lang=sql> SELECT
table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM
information_schema.TABLES
GROUP BY
table_schema ;
</source>