Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

get size of mysql database

SELECT table_schema AS "Database", 
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" 
FROM information_schema.TABLES 
GROUP BY table_schema;
Source by jonathanstreet.com #
 
PREVIOUS NEXT
Tagged: #size #mysql #database
ADD COMMENT
Topic
Name
7+1 =