MySQL

[popeye]

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]

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]

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]

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.

 

[popeye]

Is there a way i check or make it bigger if needed ?

 

[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.

 

[popeye]

Hi it says this 1.1G /var/lib/mysql does that mean its only 1gb

 

[cPanelMichael]

Could you post the full output? I'm not sure which command you are references with that output.

Thank you.

 

[popeye]

[~]# du -sh /var/lib/mysql
1.1G /var/lib/mysql
[email protected] [~]# 1.1G /var/lib/mysql^C

 

[cPanelMichael]

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.