Difference in size shown between cpanel and in mysql folder

cpanzy

• May 30, 2023 19:52

Cpanel shows database size of 386MB, but when looking in shell in that accounts folder in /var/lib/mysql it shows 4.7GB with a 4.7GB .ibd file for one of the tables. When checking in their cpanel phypmyadmin this table shows as 200MB

• 

  cpanzy

  • May 31, 2023 02:07

  I solved this via phpmyadmin - optimize table

  0
• 

  kodeslogic

  • May 31, 2023 12:39

  Glad you were able to resolve it.

  0
• 

  cPRex Jurassic Moderator

  • May 31, 2023 13:35

  The optimize table routine clears up the slack space, which is an interesting thing that can happen with MySQL databases. I'm glad that automated tool took care of the issue!

  0

Please sign in to leave a comment.