MyISAM uses table-level locking so possibly either the php side or the java side or both sides are having trouble perhaps with one using (and locking) a table so the other can’t access it.
Try commenting out in PHP the mysql_close() line the the equivilant line in the Java
I’m not sure.
Do you have any monitoring for your network? especially between the db server and the IPs that are reporting problems?
Is the client program crashing or not exiting cleanly?
110222 21:42:19 [ERROR] Can’t create thread to kill server
is a worry though. It sounds like your server was so busy it couldn’t even shutdown cleanly.
http://dev.mysql.com/doc/refman/5.0/en/server-shutdown.html
do you have any logs of ‘show full processlist’ or ‘show status’ around the time the server was shutdown? this should tell us what was running.
Dear Space,
I have too many php file which will need to comment out mysql_close so I dont think so I can do that either because once I close then I got to reopen which is going to be hell too.
You should be able to do a bulk “find and replace” across files, the editor I use can do a “find and replace” across all files it has open.
Dear Space,
What editor are you using? Can you recommend it to me? Then maybe I can try over here. What is the reason to comment it actually?
I’m using Emerald Editor (it took over from Crimson Editor).
The reason for commenting out the occurances of mysql_close() is because PHP normally closes open connections to MySQL when a script is finished, it may be the overhead of opening and closing connections.
Try disabling php for a while, does MySQL still keep restarting with php disabled?
Dear Space,
Now with the increase in number of connection the number of restart have gone less only unfortunately today the main table which record all the gps data crash and I manage to recover it. So when you say disable the php means disable the apache server itself is it. I dont think cause this system is being use. Another question in your experience how do you copy large data in million from one table to another table?
Dear Jurn,
I dont have have any monitoring for my network. I am not too sure is the client crashing or not exiting cleanly I just saw this in the log file I am not too sure either. The problem why I can not give you ‘show full processlist’ or ‘show status’ because I do not know when it will restart too.