Dimensioni di database e tabelle MySQL

← Torna a MySQL

Tramite query

Dimensione di un database

SELECT 
    table_schema AS `Database`, 
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS `Size_MB`
FROM 
    information_schema.TABLES
WHERE 
    table_schema = 'nome_database'
GROUP BY 
    table_schema;

Dettaglio tabelle del database

SELECT 
    table_name AS `Table`, 
    ROUND((data_length + index_length) / 1024 / 1024, 2) AS `Size_MB`
FROM 
    information_schema.TABLES
WHERE 
    table_schema = 'nome_database'
ORDER BY 
    `Size_MB` DESC;

Usare du (se hai accesso al filesystem)

du -sh /var/lib/mysql/nome_database