# MySQL

htop 看到 mysqld 佔100%

```bash
mysql -u root
```

進入後執行

```mysql
SHOW FULL PROCESSLIST;
```

會列出下面的內容，有問題的就會長很長

```mysql
| 32892 | root | localhost | NULL | Query   |    0 | starting     | SHOW FULL PROCESSLIST
```

然後執行

```mysql
KILL 32892;
```