Server MySql Crash

[AlexisMeroni]

Hello ,
I don't understand why my server MySql (local) in 5.5 always crash .
Can you help me please ? :D
Thanks You, Alexis

 

[AlexisMeroni]

You don't know ? :'(

 

[TheVisitors]

Hello ,
I don't understand why my server MySql (local) in 5.5 always crash .
Can you help me please ? :D
Thanks You, Alexis

Have you checked the error logs?

Telling people that its crashing, but not giving us at least a breadcrumb isn't going to get us to help. We need a hint.

 

[AlexisMeroni]

Hello,
Tanks you for your reply
Where is the error Log of mysql ?

 

[kdean]

At:

/var/lib/mysql/

You should find a file named after your host name with a .err extension.

 

[AlexisMeroni]

Okey.

Mysql Crash - Pastebin.com <------- The "cpanel.yo**-h*****.us.err" .

Mysql version is 5.5 .

 

[AlexisMeroni]

Up Please :s

 

[InterServed]

Up Please :s

Hi,

At first look it seems that you are reaching the open files limit. You will need to increase the limit for max open files:

1) add to /etc/my.cnf ([mysqld] section) (replace 65K with desired maximum open files limit)
open_files_limit = 65K

2)
echo "mysql soft nofile 65536" >>/etc/security/limits.conf
echo "mysql hard nofile 65536" >>/etc/security/limits.conf

3) Stop and restart your mysql service.

The examples i provided should allow mysql service to accept a maximum of 65K open files. Replace/edit to reflect your environment if needed. Note that I'm not responsible for possible issues , use at your own risk.

 

[AlexisMeroni]

2)
echo "mysql soft nofile 65536" >>/etc/security/limits.conf
echo "mysql hard nofile 65536" >>/etc/security/limits.conf

I don't understand this lines.....

 

[InterServed]

I don't understand this lines.....

You can just copy paste them and they should work. It will ensure that your open files limits will be applied at OS level. You could also manually edit the file /etc/security/limits.conf with your favorite editor. Example with nano:

nano /etc/security/limits.conf (you will see examples on how to configure that file) , at the end of the file you can add the configuration i provided:

mysql soft nofile 65536
mysql hard nofile 65536

or

* soft nofile 65536
* hard nofile 65536

You can also check what's your mysql open files limit and how many open files there are:

mysql -e "show status like '%open_files%';" && mysql -e "show variables like '%open_files_limit%';"

 

[AlexisMeroni]

Ok Thanks you.

I go test.

 

[InterServed]

Hope it will solve your problem.