Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +-----+----------+-----------+----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +-----+----------+-----------+----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
- | 38 | librenms | localhost | librenms | Query | 3474 | Waiting for table metadata lock | SELECT `type`,COUNT(`type`) AS total_type FROM `devices` AS D WHERE 1 GROUP BY `type` ORDER BY `type |
- | 39 | librenms | localhost | librenms | Query | 3342 | Waiting for table metadata lock | SELECT `type`,COUNT(`type`) AS total_type FROM `devices` AS D WHERE 1 GROUP BY `type` ORDER BY `type |
- | 40 | librenms | localhost | librenms | Sleep | 1059 | | NULL |
- | 41 | librenms | localhost | librenms | Sleep | 3794 | | NULL |
- | 42 | librenms | localhost | librenms | Query | 3626 | Waiting for table metadata lock | SELECT COUNT(`device_id`) FROM `devices` WHERE `last_polled` <= DATE_ADD(NOW(), INTERVAL - 15 minute |
- | 43 | librenms | localhost | librenms | Sleep | 3786 | | NULL |
- | 47 | librenms | localhost | librenms | Sleep | 3794 | | NULL |
- | 49 | librenms | localhost | librenms | Sleep | 3743 | | NULL |
- | 53 | librenms | localhost | librenms | Sleep | 3773 | | NULL |
- | 55 | librenms | localhost | librenms | Query | 3647 | Waiting for table metadata lock | UPDATE `devices` set `uptime` ='7820735',`last_ping` =NOW(),`last_ping_timetaken` ='4.03',`last_poll |
- | 76 | librenms | localhost | librenms | Query | 3675 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 77 | librenms | localhost | librenms | Query | 3640 | Waiting for table metadata lock | SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_ |
- | 78 | librenms | localhost | librenms | Query | 3473 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 79 | librenms | localhost | librenms | Query | 3473 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 80 | librenms | localhost | librenms | Query | 3473 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 81 | librenms | localhost | librenms | Sleep | 3467 | | NULL |
- | 82 | librenms | localhost | librenms | Query | 3173 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 83 | librenms | localhost | librenms | Query | 3173 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 84 | librenms | localhost | librenms | Query | 3173 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 85 | librenms | localhost | librenms | Query | 2872 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 86 | librenms | localhost | librenms | Query | 2872 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 87 | librenms | localhost | librenms | Query | 2872 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 88 | librenms | localhost | librenms | Query | 2573 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 89 | librenms | localhost | librenms | Query | 2573 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 90 | librenms | localhost | librenms | Query | 2573 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 91 | librenms | localhost | librenms | Query | 2272 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 92 | librenms | localhost | librenms | Query | 2272 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 93 | librenms | localhost | librenms | Query | 2272 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 94 | librenms | localhost | librenms | Query | 1973 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 95 | librenms | localhost | librenms | Query | 1973 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 96 | librenms | localhost | librenms | Query | 1973 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 97 | librenms | localhost | librenms | Query | 1673 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 98 | librenms | localhost | librenms | Query | 1673 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 99 | librenms | localhost | librenms | Query | 1673 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 100 | librenms | localhost | librenms | Query | 1373 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 101 | librenms | localhost | librenms | Query | 1373 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 102 | librenms | localhost | librenms | Query | 1373 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 103 | librenms | localhost | librenms | Query | 1073 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 104 | librenms | localhost | librenms | Query | 1073 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 105 | librenms | localhost | librenms | Query | 1073 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 106 | librenms | localhost | librenms | Query | 773 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 107 | librenms | localhost | librenms | Query | 773 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 108 | librenms | localhost | librenms | Query | 773 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 109 | librenms | localhost | librenms | Query | 473 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 110 | librenms | localhost | librenms | Query | 473 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 111 | librenms | localhost | librenms | Query | 473 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 119 | librenms | localhost | librenms | Query | 173 | Waiting for table metadata lock | ALTER TABLE `devices` ADD `ip` VARBINARY( 16 ) NOT NULL AFTER `sysName` |
- | 120 | librenms | localhost | librenms | Query | 173 | Waiting for table metadata lock | SELECT * FROM `devices` AS D, `services` AS S WHERE S.device_id = D.device_id ORDER by D.device_id D |
- | 121 | librenms | localhost | librenms | Query | 173 | Waiting for table metadata lock | select device_id from devices where poller_group IN(0) and disabled = 0 order by last_polled_timetak |
- | 122 | root | localhost | NULL | Query | 0 | NULL | show processlist |
- +-----+----------+-----------+----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
- 50 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
