mysql> show processlist; +-------+------+----------------+-----------+---------+------+--------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------+----------------+-----------+---------+------+--------+------------------------------------------------------------------------------------------------------+ | 1 | root | H3RMW090:1883 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7500 | | 2 | root | H3RMW090:1909 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 55.422680, last_outval = 1510 | | 3 | root | H3RMW090:1915 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 1.000000, last_outval = 1.000 | | 4 | root | H3RMW090:1905 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7543 | | 5 | root | H3RMW090:1889 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_t30m = 1219924800.000000, avg_30m_in = 165.209191, avg_30m_ou | | 6 | root | H3RMW090:1907 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 2.381443, last_outval = 2.381 | | 7 | root | H3RMW090:1916 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 0.000000, last_outval = 0.000 | | 8 | root | H3RMW090:1892 | NULL | Query | 139 | end | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7498 | | 9 | root | H3RMW090:1898 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 1501.965636, last_outval = 15 | | 10 | root | H3RMW090:1897 | NULL | Query | 137 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7464 | | 11 | root | H3RMW090:1904 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 5694.515464, last_outval = 12 | | 12 | root | H3RMW090:1895 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 150.852234, last_outval = 150 | | 13 | root | H3RMW090:1890 | NULL | Query | 137 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7463 | | 14 | root | H3RMW090:1912 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 16.054983, last_outval = 1555 | | 15 | root | H3RMW090:1906 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 0.587629, last_outval = 0.601 | | 16 | root | H3RMW090:1893 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925472, last_inval = 0.000000, last_outval = 0.000 | | 17 | root | H3RMW090:1885 | NULL | Query | 130 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925470, last_inval = 37002166.405498, last_outval | | 18 | root | H3RMW090:1886 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 978.419244, last_outval = 183 | | 19 | root | H3RMW090:1884 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 0.000000, last_outval = 0.000 | | 20 | root | H3RMW090:1910 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 16.054983, last_outval = 1564 | | 21 | root | H3RMW090:1914 | NULL | Sleep | 812 | | NULL | | 22 | root | H3RMW090:1887 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 6.790378, last_outval = 441.2 | | 23 | root | H3RMW090:1899 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7499 | | 24 | root | H3RMW090:1891 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 16.054983, last_outval = 1564 | | 25 | root | H3RMW090:1888 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 1.000000, last_outval = 1.000 | | 26 | root | H3RMW090:1917 | NULL | Sleep | 158 | | NULL | | 27 | root | H3RMW090:1894 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 690.694158, last_outval = 458 | | 28 | root | H3RMW090:1913 | NULL | Query | 138 | Locked | SELECT inventario.id as i_id, inventario.*, apparati.*, lastsnmp.*, ((1219925472 - (lastpoll - (las | | 29 | root | H3RMW090:1911 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 346550.982818, last_outval = | | 30 | root | H3RMW090:1903 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 55.422680, last_outval = 2009 | | 31 | root | H3RMW090:1908 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7540 | | 32 | root | H3RMW090:1882 | NULL | Sleep | 166 | | NULL | | 33 | root | H3RMW090:1896 | NULL | Query | 135 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7466 | | 34 | root | H3RMW090:1901 | NULL | Query | 136 | Locked | UPDATE dbmonitor.inventario SET lastpoll = 1219925471 WHERE id = 7465 | | 35 | root | H3RMW090:1902 | NULL | Query | 139 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 120.549828, last_outval = 963 | | 36 | root | H3RMW090:1900 | NULL | Query | 138 | Locked | UPDATE dbmonitor.inventario SET last_time = 1219925471, last_inval = 0.000000, last_outval = 443.6 | | 2612 | root | localhost:4187 | NULL | Query | 0 | NULL | show processlist | | 8700 | root | H3RMW090:3370 | dbmonitor | Query | 139 | Locked | SELECT * FROM inventario WHERE id = 6174 | | 11420 | root | H3RMW090:2119 | dbmonitor | Query | 109 | Locked | UPDATE dbmonitor.inventario SET web_pok = 0, web_pwarn=0, web_pko=39, web_timeavg = 0, web_timemin = | | 11421 | root | H3RMW090:2121 | dbmonitor | Query | 139 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11422 | root | H3RMW090:2122 | dbmonitor | Query | 139 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11423 | root | H3RMW090:2124 | dbmonitor | Query | 137 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11424 | root | H3RMW090:2127 | dbmonitor | Query | 137 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11436 | root | H3RMW090:2155 | dbmonitor | Query | 49 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11437 | root | H3RMW090:2156 | dbmonitor | Query | 49 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11438 | root | H3RMW090:2157 | dbmonitor | Query | 49 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11439 | root | H3RMW090:2160 | dbmonitor | Query | 47 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | | 11440 | root | H3RMW090:2161 | dbmonitor | Query | 46 | Locked | SELECT * FROM dbmonitor.inventario, dbmonitor.apparati WHERE inventario.apparato = apparati.apparato | +-------+------+----------------+-----------+---------+------+--------+------------------------------------------------------------------------------------------------------+ 48 rows in set (0.02 sec)