Applicable to:
- Plesk for Linux
Question
Why is the size of a cloned MySQL database differs from the size of the original database?
Answer
The disk space occupied by the local MySQL databases is a sum of the two parts:
- Database directory size.
-
Sum of tables data and index sizes reported by the MySQL command
SHOW TABLE STATUS
(only valid in case of InnoDB engine and the parameterinnodb_file_per_table
set tofalse
).
The size of the database can differ due to the inner structure of the database (e.g. contains different amount of empty space between the units of data) or different storage engines used in the tables.
For more details, please check Official MySQL documentation .
Comments
0 comments
Please sign in to leave a comment.