DB size is double in cPanel than actual size

Adarsh Khatri

• July 13, 2021 21:46

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?

• 

  cPRex Jurassic Moderator

  • July 14, 2021 15:30

  Hey there! Can you run this command on the server to check and see if there is slack space in the database? 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.

  0
• 

  Adarsh Khatri

  • July 14, 2021 23:11

  Hi Yes, it does show some free:

  0
• 

  cPRex Jurassic Moderator

  • July 15, 2021 12:48

  It's possible that could be misleading the disk space calculation tools, although Innodb tables do always have some amount of data_free usage, although that seems like a large amount in your output.

  0

Please sign in to leave a comment.