Bobbe
10/4/2013 - 9:47 AM

Get the mysql table size

Get the mysql table size

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE User = 'flirchi' Order by Time
SELECT table_name AS "Table", 
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
FROM information_schema.TABLES 
WHERE table_schema = "$DB"
 AND table_name = "$tbl";