MySql:Bepaal MySQL Database grootte (Check MySQL database size)

Opvragen van de grootte van alle databases.

SELECT TABLE_SCHEMA AS 'Database',
ROUND(sum( data_length + index_length ) / 1024 / 1024,2) "Data Base Size in MB",
ROUND(sum( data_free )/ 1024 / 1024,2) "Free Space in MB"
FROM INFORMATION_SCHEMA.TABLES GROUP BY TABLE_SCHEMA ;

Op vragen van de grootte van alle tabellen van een specifieke database.
Vervanging YOUR_DB_NAME door de naam van de database

SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table',
CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024),2)," Data Base Size in MB ",ROUND((DATA_FREE / 1024 / 1024),2)," Free Space in MB") AS Size 
FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like '%YOUR_DB_NAME%' ;

Bronnen, noten en/of referenties:

Links

• novell
• hiox
• Tutorialized