2

MySQL Server crashed every hours and this logs submited.

MySQL Version : 5.6 + cPanel

my.cnf :

Ram of SERVER : 128GB Cpu : 2x 8core with thareds : 32Core Hard Disk : SSD Pro

Logs :

http://paste.ubuntu.com/12646771/

How to solve the problem now?!

My.cnf :

http://paste.ubuntu.com/12646776/

I set a cron every hours with MySQL -e 'FLUSH QUERY CACHE;' in the crontab server. Because the size query cache full and all websites slowed, after flush all website working fast and fine.

4

Having a query cache of 45GB is definitely not a good idea. It should not be more than say 128MB, usually much lower numbers are suggested, or even totally disabling it. Query cache of this size makes everything slow because on any update to any table it has to be traversed and entries invalidated, and you can have many entries to invalidate in 45GB.

The crash itself looks like a bug in the server for handling the big cache (signal 11 is a segfault afaik). You can check if it is known and if not then submit a bug report.

But definitely set the cache size well under 1GB, it is better to give that memory to innodb buffer pool.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.