popeye

Well-Known Member
May 23, 2013
368
2
68
Texas
cPanel Access Level
Root Administrator
Hi last night i had to restart MySQL on a vps as something made it crash, but when it did it effected my other server in the dns cluster is this what its meant to do ?


Also how can i check how much room i have for MySQL the server as 8TB space
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.
 

popeye

Well-Known Member
May 23, 2013
368
2
68
Texas
cPanel Access Level
Root Administrator
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
Could you post the full output? I'm not sure which command you are references with that output.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.