Skip to main content

MySQL

Comments

9 comments

  • cPanelMichael
    Hello :) Try reviewing the MySQL error log (/var/lib/mysql/$hostname.err) to determine the reason it failed. It should not have caused your DNS-Only server to fail. What exactly happened with the cluster? The amount of space used depends on how large your databases are. Thank you.
    0
  • popeye
    When the MySQL went down on my vps it effected another cpanel server that i have in the cluster. and it restarted itself ? then i went and restarted the MySQL on the vps and it all worked again. i have 8TB of space on the server so will MySQL just use what it needs.
    0
  • cPanelMichael
    MySQL databases are stored in: /var/lib/mysql/ It will use whatever space is permitted to the /var partition, or whichever partition is associated with the /var directory. Thank you.
    0
  • popeye
    Is there a way i check or make it bigger if needed ?
    0
  • cPanelMichael
    Sure, use the following command to determine how much space is used: du -sh /var/lib/mysql Then, use "df -h" to see the overall capacity of the partitions. Thank you.
    0
  • popeye
    Hi it says this 1.1G /var/lib/mysql does that mean its only 1gb
    0
  • cPanelMichael
    Could you post the full output? I'm not sure which command you are references with that output. Thank you.
    0
  • popeye
    [~]# du -sh /var/lib/mysql 1.1G /var/lib/mysql root@tow [~]# 1.1G /var/lib/mysql^C
    0
  • cPanelMichael
    [quote="popeye, post: 1533661">Hi it says this 1.1G /var/lib/mysql does that mean its only 1gb
    It means it's 1.1G of usage. You can compare this to the available space on the partition when using the "df -h" command. Thank you.
    0

Please sign in to leave a comment.