[문제해결] mysql process 가 너무 많이 띄워졌을때..
ps aux 를 해 보면 mysql 데몬이 엄청 떠 있을때가 있습니다..
이때는 mysql 관리 console 로 로긴후
mysql> show processlist; 와 같이 하시면 아래와 같은 정보가 나오게 됩
니다.
아래와 같은 정보를 확인시에는 해당 도메인 소유자에게 통지를 하시기 바
랍니다.
그럼…..
+——+————-+———–+————–+———+——+—
—-+——
————+
| Id | User | Host | db | Command | Time | State | Info
|
+——+————-+———–+————–+———+——+—
—-+——
————+
| 117 | memory | localhost | memorygamedb | Sleep | 4891 | NULL |
NULL
|
| 144 | memory | localhost | memorygamedb | Sleep | 2744 | NULL |
NULL
|
| 241 | memory | localhost | memorygamedb | Sleep | 4542 | NULL |
NULL
|
| 244 | memory | localhost | memorygamedb | Sleep | 4536 | NULL |
NULL
|
| 247 | memory | localhost | memorygamedb | Sleep | 4528 | NULL |
NULL
|
| 250 | memory | localhost | memorygamedb | Sleep | 4527 | NULL |
NULL
|
| 301 | digitalrose | localhost | digitalrose | Sleep | 4407 | NULL
| NULL
|
| 585 | memory | localhost | memorygamedb | Sleep | 3651 | NULL |
NULL
|
| 667 | memory | localhost | memorygamedb | Sleep | 3412 | NULL |
NULL
|
| 712 | memory | localhost | memorygamedb | Sleep | 3287 | NULL |
NULL
|
| 725 | digitalrose | localhost | digitalrose | Sleep | 3267 | NULL
| NULL
|
| 740 | memory | localhost | memorygamedb | Sleep | 2453 | NULL |
NULL
|
| 743 | memory | localhost | memorygamedb | Sleep | 3217 | NULL |
NULL
|
| 757 | memory | localhost | memorygamedb | Sleep | 3191 | NULL |
NULL
|
| 761 | memory | localhost | memorygamedb | Sleep | 2387 | NULL |
NULL
|
| 783 | memory | localhost | memorygamedb | Sleep | 3133 | NULL |
NULL
|
| 801 | digitalrose | localhost | digitalrose | Sleep | 3087 | NULL
| NULL
|
| 921 | memory | localhost | memorygamedb | Sleep | 2692 | NULL |
NULL
|
| 962 | memory | localhost | memorygamedb | Sleep | 2592 | NULL |
NULL
|
| 969 | memory | localhost | memorygamedb | Sleep | 2582 | NULL |
NULL
|
| 1005 | memory | localhost | memorygamedb | Sleep | 11 | NULL |
NULL
|
| 1019 | memory | localhost | memorygamedb | Sleep | 2341 | NULL |
NULL
|
| 1036 | memory | localhost | memorygamedb | Sleep | 2360 | NULL |
NULL
|
| 1038 | memory | localhost | memorygamedb | Sleep | 568 | NULL |
NULL
|
| 1040 | memory | localhost | memorygamedb | Sleep | 2327 | NULL |
NULL
|
| 1041 | memory | localhost | memorygamedb | Sleep | 2326 | NULL |
NULL
|
| 1049 | memory | localhost | memorygamedb | Sleep | 2288 | NULL |
NULL
|
| 1078 | memory | localhost | memorygamedb | Sleep | 2085 | NULL |
NULL
|
| 1082 | memory | localhost | memorygamedb | Sleep | 2109 | NULL |
NULL
|
| 1083 | memory | localhost | memorygamedb | Sleep | 2097 | NULL |
NULL
|
| 1141 | digitalrose | localhost | digitalrose | Sleep | 1807 | NULL
| NULL
|
| 1224 | root | localhost | mysql | Query | 0 | NULL | show
processlist |
| 1403 | memory | localhost | memorygamedb | Sleep | 595 | NULL |
NULL
|
| 1404 | memory | localhost | memorygamedb | Sleep | 589 | NULL |
NULL
|
| 1414 | memory | localhost | memorygamedb | Sleep | 559 | NULL |
NULL
|
| 1427 | memory | localhost | memorygamedb | Sleep | 490 | NULL |
NULL
|
+——+————-+———–+————–+———+——+—
—-+——
————+
36 rows in set (0.00 sec)