but: df -h /tmp
tmpfs 4.0G 2.9G 1.2G 71% /tmp

lsof -a +L1 /tmp
mysqld 814658 mysql 5u REG 0,18 6909 0 129877498 (deleted)/tmp/ibDs7ppL
mysqld 814658 mysql 6u REG 0,18 550 0 129877499 (deleted)/tmp/ibdkEKwG
mysqld 814658 mysql 7u REG 0,18 0 0 129877500 (deleted)/tmp/ibJv84DB
mysqld 814658 mysql 8u REG 0,18 0 0 129877581 (deleted)/tmp/ibVsY6gs
mysqld 814658 mysql 22u REG 0,18 0 0 129953780 (deleted)/tmp/ibFXQ0vR
mysqld 814658 mysql 7109u REG 0,18 1511325696 0 130050097 (deleted)/tmp/MYVbKwmg
mysqld 814658 mysql 7138u REG 0,18 1511325696 0 130043510 (deleted)/tmp/MYdDNZUq

mysqladmin processlist

| 13962 | cphulkd | localhost | cphulkd | Query | 27931 | Sorting result | SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(S |
| 24119 | cphulkd | localhost | cphulkd | Query | 25842 | Sorting result | SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(S |
| 31029 | cphulkd | localhost | cphulkd | Query | 24435 | Sorting result | SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(S |
| 120593 | root | localhost | cphulkd | Query | 8229 | Waiting for table flush | LOCK TABLES `auths` READ /*!32311 LOCAL */,`ip_lists` READ /*!32311 LOCAL */,`known_netblocks` READ |
| 152512 | cphulkd | localhost | cphulkd | Query | 2154 | Waiting for table flush | SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(S |

mysql -e "SELECT CONCAT('KILL ',ID,';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'cphulkd' AND COMMAND = 'Query' AND TIME > 100 INTO OUTFILE '/tmp/kill_list.txt';" && mysql -e "source /tmp/kill_list.txt" && rm -rf /tmp/kill_list.txt