« What port numbers are configured on WebSphere?Being Lars Monsen »

Check MySQL Database Size Using SQL Query

Plain and simple

Code:

SELECT
CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2))," MB")
AS Size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA
LIKE '%YOUR_DB_NAME%' ;

All thanks to mendesdomnic

This entry was posted on April 10th, 2012 at 02:10:00 am and is filed under Work/Geek. Tags: mysql, sql

No feedback yet

Comments are closed for this post.