I've created a client-server application. The server is running on Linux Redhat 7.0 and the client is on windows. there are heavy database interactions (MySQL version 3.23), nearly realtime.
How can I distribute the load.
I have found that services of MySQL stops after indefinite interval of time regardless of load and automatically starts. I really don't know why. There is no specific query which may be terminating the services. I also have seen the error log file (<hostname>.err) which only says that the services were stopped and startedand nothing else. How can I figure out the reason.