• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

MySQL database size in statistics is bigger than real when using InnoDB engine

Franky@

New Pleskian
---------------------------------------------------------------
PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Plesk Panel, 10.4.4, #50, Centos 6.4, x64

PROBLEM DESCRIPTION
Statistics page reports a database size that is almost doubled when using InnoDB engine in MySQL.

STEPS TO REPRODUCE
Create a database and fill it with data.

ACTUAL RESULT
Database reported size is almost double than real (verified on command line using du -sh on database directory).

EXPECTED RESULT
Database size should be reported correctly.

ANY ADDITIONAL INFORMATION
Changing the table engine to MyISAM solves the problem.
--------------------------------------------------------------
 
This is the screenshot taken from statistics page using InnoDB engine:
statistics-with-innodb.jpg
and this is the real database size on disk:
du-with-innodb.jpg

Same as above using MyISAM:
statistics-with-myisam.jpg
du-with-myisam.jpg
 
Back
Top