* ''show full processlist'' wyświetla listę procesów, które korzystają z bazy danych: 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 | +--------+-----------+-----------------+-----------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+