Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how much every mysql database record takes from diskspace

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
 
PREVIOUS NEXT
Tagged: #mysql #database #record #takes #diskspace
ADD COMMENT
Topic
Name
3+4 =