MySQL Crashed every hours

MySQL

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.

Best Answer

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.

Related Question