Incorrect database disk usage

Islam Apon

• August 12, 2024 08:48

Hello,

We are checking our server disk usage and found some mysterious stuff with the database disk usage.

On /var/lib/mysql some databases are occupying over 10g disk space:

https://prnt.sc/HB6sS9oVi8Yx

But when we check the cPanel disk usage or database usage. it shows 0 byte usage. What could be wrong here, the /var/lib/mysql directory or the cPanel disk usage?

https://prnt.sc/H-0ZSf6UEcE8

• 

  Islam Apon

  • August 12, 2024 08:59

  I can see WP options database table is consuming this much of disk space.

  https://prnt.sc/VkRm2nbpb_J5

  Is this for real?

  0
• 

  cPRex Jurassic Moderator

  • August 12, 2024 13:51

  Hey there!  It sounds like this could be an issue with "slack space" in the database.  We have some additional details on this here:

  https://support.cpanel.net/hc/en-us/articles/1500002568681-How-to-determine-the-size-of-a-MySQL-database-via-command-line

  but could you try using the PHPMyAdmin >> Optimize Table tool to see if that changes the reported disk usage?

  0
• 

  CyberLynk Software

  • August 12, 2024 17:02

  Islam Apon Go into PHPMyAdmin (at either WHM or cPanel) and look at the database.  We have seen buggy WordPress plugins that can create 100's of 1000's of rows in the wp_options table.  From PHPMyAdmin you can see approximate row counts for the tables.

  You'll also want to look at the storage engine.  I don't believe you can optimize INNODB (the default) like cPRex suggested.

  0
• 

  Islam Apon

  • August 12, 2024 21:26

  We’ve resolved the issue by installing WP optimization plugins on the affected websites and optimizing their database tables. We’ll continue to monitor the situation closely for any further problems.

  Thanks cPRex & CyberLynk Software for the help.

  0
• 

  cPRex Jurassic Moderator

  • August 13, 2024 13:36

  Nice!

  0

Please sign in to leave a comment.