Brontekst bekijken van MySql:Bepaal MySQL Database grootte (Check MySQL database size)

Opvragen van de grootte van alle databases.<ref name="Tutorialized">Informatie afkomstig van [http://www.tutorialized.com/view/tutorial/Check-MySQL-database-size/43108  Tutorialized]</ref><br>
 <nowiki>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 ;</nowiki>

Op vragen van de grootte van alle tabellen van een specifieke database.<ref name="novel">Informatie afkomstig van [http://www.novell.com/communities/node/8706/check-mysql-database-size-using-sql-query Novell]</ref><br>
Vervanging <font color="red">''YOUR_DB_NAME''</font>  door de naam van de database<br>
 <nowiki>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%' ;
</nowiki>

{{sys:ref:reference}}
{{links}}
* [http://www.novell.com/communities/node/8706/check-mysql-database-size-using-sql-query novell]
* [http://hiox.org/2504-check-mysql-database-size-using-sql.php hiox]
* [http://www.tutorialized.com/view/tutorial/Check-MySQL-database-size/43108  Tutorialized]