Windows or Linux?
If Windows, consider moving to Linux. Windows is not an ideal operating system if you have many users & labs.
Check Tomcat memory allocation
Open the 'setenv.sh' file lies in the '<tomcat directory>/bin' directory, and check below lines are present in the file or not.
export JAVA_OPTS="-Dfile.encoding=UTF-8 -Xms128m -Xmx2048m -XX:PermSize=64m -XX:MaxPermSize=512m" export CATALINA_OPTS="$CATALINA_OPTS -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=<path to dump file>"
Check DB memory allocation
Please refer to MySQL prerequisites page.
Check CPU and memory utilization.
- Open Task Manager (Windows) or top command (Linux).
- Check if any process entirely consumes CPU or memory. If some process is hogging all the resources, identify the process, and check what is going on with it.
- Repeat this on both app and DB server.
Check database transactions
- Login into the database.
- Run the following command for MySQL:
show full processlist;
- It will display current running transactions in the database.
- Check if any of the processes are long-running or hogging all the DB resources.
- If yes, identify the query and check if it was run by OpenSpecimen application.