Skip to main content

Incorrect database disk usage

Comments

5 comments

  • User Avatar
    Islam Apon

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

    https://prnt.sc/VkRm2nbpb_J5

    Is this for real?

    0
  • User Avatar
    cPRex Jurassic Moderator

    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
  • User Avatar
    CyberLynk Software

    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
  • User Avatar
    Islam Apon

    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
  • User Avatar
    cPRex Jurassic Moderator

    Nice!

    0

Please sign in to leave a comment.