Database Size Calculation
Using following steps you can calculate the size of the existing MySQL database:-
1. Open Terminal/Command prompt(Window)
In window, Goto start-->Search cmd-->Click to open
-
2. Change to MySQL directory
-
3. Connect to MySQL Database
mysql -h localhost -p -u alfresco Enter Password:
-
4. Type select command to get size of a Database
select table_schema, sum(data_length+index_length)
/1024 /1024 as MB from informaation_schema.tables
where table_schema ="datbase_name";
