mysql gone away

Portal Home > Knowledgebase > Articles Database > mysql gone away

Posted by Calibaba, 09-15-2008, 09:30 PM
WordPress database error: [MySQL server has gone away] My my.cnf file For now, I simply did a killall -9 mysqld and restarted mysql. That resolved the issue, but not sure why it gave off that error with the above settings.
Posted by Murtaza_t, 09-15-2008, 09:41 PM
Any idea exactly when do you get that error..?
Posted by Calibaba, 09-15-2008, 09:43 PM
In this case, on this certain server - only now. First time seen this on this certain box in a very long time, so its unusual basically.
Posted by Murtaza_t, 09-15-2008, 09:55 PM
You get this error specially when either of the below setting gets exceeded: max_connect_errors=20 max_allowed_packet=16M Did you try searching the web logs (httpd)..? Also if you check your MySQL error logs you may find the exact reason on which setting actually got exhausted.
Posted by HWC-khalemi, 09-15-2008, 10:39 PM
try changing this to a higher value (seconds) interactive_timeout=30 wait_timeout=45 connect_timeout=30 max_connect_errors=20 hope this one helps
Posted by CNSERVERS, 09-15-2008, 11:06 PM
when wordpress plugin try to connect to outside servers for data due to slow connection or slow name resolving it may take long time and may result in a mysql wait timeout. you can either increase the wait_timeout value in my.cnf or use this wordpress patch: http://robsnotebook.com/wordpress-mysql-gone-away