+----+------------+----------------------------+-------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------------+----------------------------+-------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 1 | root | cwczc42812wc.ibacc.es:3315 | [NULL] | Sleep | 2 | | [NULL] | | 3 | root | ibesrv1018.IBACC.ES:1705 | scarab | Sleep | 5 | | [NULL] | | 4 | root | ibesrv1018.IBACC.ES:1710 | scarab | Query | 5 | Locked | SELECT SCARAB_ISSUE.ISSUE_ID, SCARAB_ISSUE.ID_PREFIX, SCARAB_ISSUE.ID_COUNT, SCARAB_ISSUE.ID_DOMAIN, | | 5 | root | ibesrv1018.IBACC.ES:1711 | scarab | Query | 4 | Locked | INSERT INTO SCARAB_ACTIVITY ( ACTIVITY_ID, ISSUE_ID, ATTRIBUTE_ID, TRANSACTION_ID, OLD_NUMERIC_VALUE | | 6 | root | ibesrv1018.IBACC.ES:1723 | scarab | Sleep | 6 | | [NULL] | | 7 | root | ibesrv1018.IBACC.ES:1739 | scarab | Query | 6 | Locked | UPDATE SCARAB_ISSUE SET ID_PREFIX = 'NT', ID_COUNT = 1150, ID_DOMAIN = 'scarab', TYPE_ID = 384, MODU | | 8 | root | ibesrv1018.IBACC.ES:1740 | scarab | Sleep | 6 | | [NULL] | | 9 | root | ibesrv1018.IBACC.ES:1741 | scarab | Query | 39 | Sending data | SELECT count(DISTINCT SCARAB_ISSUE.ISSUE_ID) FROM SCARAB_ISSUE INNER JOIN SCARAB_ACTIVITY srchcobya | | 10 | root | ibesrv1018.IBACC.ES:1744 | scarab | Sleep | 3 | | [NULL] | | 11 | root | ibesrv1018.IBACC.ES:1752 | scarab | Query | 6 | Locked | SELECT SCARAB_ISSUE.ISSUE_ID, SCARAB_ISSUE.ID_PREFIX, SCARAB_ISSUE.ID_COUNT, SCARAB_ISSUE.ID_DOMAIN, | | 12 | root | ibesrv1018.IBACC.ES:1753 | scarab | Sleep | 6 | | [NULL] | | 13 | root | cwczc42812wc.ibacc.es:3379 | scarab | Query | 0 | [NULL] | SHOW PROCESSLIST | +----+------------+----------------------------+-------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+