DB size is double in cPanel than actual size

Operating System & Version
linux (apache) V 2.4.48
cPanel & WHM Version
cPanel v 96.0.11

Adarsh Khatri

Registered
Aug 4, 2016
4
0
51
NSW, Australia
cPanel Access Level
Website Owner
I know cPanel doesn't show actual DB size right away, it will calculate every several hours.

I have a database (3GB). It shows correctly in MYPhpAdmin and from the terminal (check attached image).

However, in cPanel it shows double size: 6GB. And yes, I have waited a few hours/days but it never comes close to the actual size of the DB.

Because of this, my quote is always more than 100%. But hey, the site still runs. However, Google does complain sometimes that it was 500 error.

So something weird going on here. Any suggestions?
 

Attachments

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
6,923
911
313
cPanel Access Level
Root Administrator
Hey there! Can you run this command on the server to check and see if there is slack space in the database?

Code:
mysql -e 'select sum(DATA_FREE) from information_schema.TABLES where TABLE_SCHEMA = "username_database"'
You can run this directly from SSH without going into the mysql prompt, and you'll just need to update the "username_database" portion of the command so it is checking the correct database.