$ mysql -u foo -p # 実行中のクエリ一覧 mysql> show processlist; +----+--------+-----------+------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+--------+-----------+------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 3 | foo | localhost | bar | Execute | 60 | Copying to tmp table | select * from baz ... # let's kill mysql> kill 3