실행 중인 프로세스 확인하기

• 출처 : https://aws.amazon.com/ko/premiumsupport/knowledge-center/rds-mysql-running-queries/

SHOW FULL PROCESSLIST\G
-- 또는
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;

타임아웃 설정

• 출처 : https://kimdubi.github.io/mysql/timeout/
• 타임아웃 확인

mysql> show variables like 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.01 sec)

mysql> show variables like 'interactive%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| interactive_timeout | 28800 |
+---------------------+-------+
1 row in set (0.00 sec)

• 타임아웃 설정

mysql> set global wait_timeout=30;