mysql> show full processlist;
+--------+-----------+-----------------+-----------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id     | User      | Host            | db        | Command | Time | State        | Info                                                                                                                                                                                                                                                              |
+--------+-----------+-----------------+-----------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|    518 | iredadmin | localhost:56683 | iredadmin | Sleep   |    3 |              | NULL                                                                                                                                                                                                                                                              |
| 169166 | amavisd   | localhost:46676 | amavisd   | Query   |    0 | NULL         | commit                                                                                                                                                                                                                                                            |
| 169173 | amavisd   | localhost:46707 | amavisd   | Sleep   |    0 |              | NULL                                                                                                                                                                                                                                                              |
| 169174 | sogo      | localhost:46735 | sogo      | Sleep   |   45 |              | NULL                                                                                                                                                                                                                                                              |
| 169178 | sogo      | localhost:46767 | sogo      | Sleep   |   42 |              | NULL                                                                                                                                                                                                                                                              |
| 169182 | iredadmin | localhost:46850 | iredadmin | Sleep   |   80 |              | NULL                                                                                                                                                                                                                                                              |
| 169183 | amavisd   | localhost:46853 | amavisd   | Sleep   |   80 |              | NULL                                                                                                                                                                                                                                                              |
| 169184 | amavisd   | localhost:46855 | amavisd   | Query   |   75 | Sending data | DELETE msgrcpt.* FROM msgrcpt
                    INNER JOIN msgs ON msgrcpt.mail_id=msgs.mail_id
                    WHERE msgs.content IN ('U', 'M', 'H', 'O', 'C')
                        AND msgs.time_num < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) |
| 169185 | sogo      | localhost:46885 | sogo      | Sleep   |   42 |              | NULL                                                                                                                                                                                                                                                              |
| 169186 | root      | localhost       | NULL      | Query   |    0 | NULL         | show full processlist                                                                                                                                                                                                                                             |
+--------+-----------+-----------------+-----------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+