I've encounter some strange issue with a update cache_update sql which caused the mysql connection link to be disconnected.
But when i execute it in my mysql query analyser, it seems to be okay...
I'm not sure why it happen in drupal, but it seems to the 250th++ query it is executing via the same connection.
It seems to disconnect very often after that...
What i did was that, i do a mysql_ping before executing any queries...
But i'm concern if the disconnected connection query is successful or not.
Anyone got any idea?
btw, here was my fix, for those who encounter similar issue:
http://mercstudio-tech.blogspot.com/2009/11/drupal-admin-mysql-has-gone-...
**
The discussion content type is usually a better choice to post questions than a wiki.
"MySQL has gone away" is usually caused by MySQL timeouts being too short. interactive_timeout and wait_timeout are the timeouts in question (depending on how you have your server configured). A good place to start is to set them both to 180 and see if that works for you. That means that MySQL will wait for 3 minutes of inactivity before closing the connection. If you are doing something in PHP that takes longer than 3 minutes between database queries, then you probably have bigger problems.