java application
Not responsive Java process
A Java application has crashed and needs to be restarted. In order to be able to execute the application again, the not responsive process first needs to be stopped. The application is installed on a remote server, so the operations need to be performed via remote shell.
Slow MySQL execution over Network under Java
If an application and the connected database is developed and tested on one single machine, code optimization and design of queries may suffer due to instant access time and nearly no transfer time between database and application.
However, if you put the Application and Database on different machines such design flaws can lead to horrible processing times. There are several fields that may cause problems in that case. One problem is transferring of many records from or to database. Another problem is execution of hundreds of single independent SQL statements in a very short time, where the application always has to wait for response of database.
