1.23 MySQL Production Issue Troubleshooting

CPU 100% 1. Use show processlist to list all processes and inspect the sessions that are running to see whether resource-consuming SQL is executing 2. Find the high-consumption SQL, kill those threads, and use explain to analyze the SQL

DatabasesCreated 03/14/2022Updated 07/11/20251 min readhistorical

This is a historical learning note and may contain outdated or incomplete understanding.

CPU 100%

Use show processlist to list all processes. Check the running sessions to see whether any resource-consuming SQL is executing.
Find the SQL with high resource consumption and kill those threads; use explain to analyze the SQL.

References

mysql: Detailed Explanation of show processlist - Zhihu