MySQL excess size

psytanium

• October 28, 2016 11:24

Hello, I was checking the Disk Usage of 1 of my accounts on cPanel, I found 2 weird things

]
• the mysql size is 185.68 MB while it should be around 24 MB
• What is Files in hidden sub directories ?

Image attached. Thanks :)

• 

  cPanelMichael

  • October 28, 2016 18:27

  Hello,

  What is Files in hidden sub directories ?

  
  Hidden subdirectories are directories within your account's home directory and below with a leading period in the name (e.g. /home/$username/public_html/.12345).

  the mysql size is 185.68 MB while it should be around 24 MB

  
  Could you let us know what steps you are using to verify the MySQL disk space usage? You can check the MySQL disk space usage via a command such as:
  du -sh /var/lib/mysql/database_name
  Thank you.

  0
• 

  psytanium

  • October 28, 2016 20:00

  Could you let us know what steps you are using to verify the MySQL disk space usage? Thank you.

  
  From phpmyadmin, and databases. see the attached photo. Thank you.

  0
• 

  cPanelMichael

  • October 28, 2016 20:02

  Hello, Does that size correspond with the output from the "du -sh /var/lib/mysql/database_name" command? Thanks.

  0
• 

  psytanium

  • October 29, 2016 09:36

  Hello, Does that size correspond with the output from the "du -sh /var/lib/mysql/database_name" command? Thanks.

  
  14MB

  0
• 

  cPanelMichael

  • November 01, 2016 19:10

  Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  psytanium

  • November 03, 2016 17:18

  I logged in to cPanel and find everything is normal, it was temporary. thanks anyway :)

  0
• 

  cPanelMichael

  • November 03, 2016 18:14

  Hello, I'm happy to see the issue is now resolved. Note that MySQL disk space usage is updated via the following root cron job:
  30 */4 * * * /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache
  It's likely you were viewing cached MySQL disk space usage and it was updated after this cron job ran. Thanks!

  0

Please sign in to leave a comment.