Articles in this section

See more

Why the size of a cloned MySQL database differs from the size of the original database?

Avatar
Alexandr Tumanov
Updated
Follow

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 parameter innodb_file_per_table set to false ).

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.

Have more questions? Submit a request

Related articles