Troubleshooting
Problem
You may found the RTM Web portal is very slow and there are thousands of PHP processes in the RTM server.
Resolving The Problem
The issue caused by the MySQL dead lock.
Please follow the procedure below to resolve the issue:
1. Log in into the MySQL database.
Please note, as each PHP process will take a database connection, the database connection may has been used up. You can use kill or killall command to kill some PHP processes to get a chance to log into MySQL database.
2. In MySQL database, use the following command to list all active tasks:
show processlist
3. Sort the result by the Time column.
4. Identify the Id which hang for a long time.
5. Kill all the Id which run for a long time.
6. Kill all the PHP process and wait for the crond schedule the PHP process in another interval and check if the issue resolved or not.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
isg3T1025935