how much every mysql database record takes from diskspace
snippet in sql

how much every mysql database record takes from diskspace

user8111

SELECT table_schema as 'Database Name', 
        sum( data_length + index_length ) as 'Size-Bytes',       
        round((sum(data_length + index_length) / 1024 / 1024), 4) as 'Size-MB'
 FROM     information_schema.TABLES
 GROUP BY table_schema