localhost
|
ID | User | Host | Database | Command | Time | Status | SQL query |
|---|---|---|---|---|---|---|---|---|
| Kill | 19467223 | debian-sys-maint | localhost | 3rs | Query | 8224 | Sorting index | OPTIMIZE TABLE `items` |
| Kill | 19467233 | threeruser1 | localhost | 3rs | Query | 8223 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19469823 | threeruser1 | localhost | 3rs | Query | 7911 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470300 | threeruser1 | localhost | 3rs | Query | 7845 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470817 | threeruser1 | localhost | 3rs | Query | 7783 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19471719 | threeruser1 | localhost | 3rs | Query | 7717 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19472570 | threeruser1 | localhost | 3rs | Query | 7654 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473392 | threeruser1 | localhost | 3rs | Query | 7592 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473735 | threeruser1 | localhost | 3rs | Query | 7529 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19474538 | threeruser1 | localhost | 3rs | Query | 7469 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19475380 | threeruser1 | localhost | 3rs | Query | 7406 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476200 | threeruser1 | localhost | 3rs | Query | 7344 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476832 | threeruser1 | localhost | 3rs | Query | 7279 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19477551 | threeruser1 | localhost | 3rs | Query | 7217 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19478375 | threeruser1 | localhost | 3rs | Query | 7156 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19479205 | threeruser1 | localhost | 3rs | Query | 7094 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480097 | threeruser1 | localhost | 3rs | Query | 7029 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480940 | threeruser1 | localhost | 3rs | Query | 6965 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19481743 | threeruser1 | localhost | 3rs | Query | 6905 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19482592 | threeruser1 | localhost | 3rs | Query | 6842 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483408 | threeruser1 | localhost | 3rs | Query | 6782 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483898 | threeruser1 | localhost | 3rs | Query | 6717 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19484742 | threeruser1 | localhost | 3rs | Query | 6654 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19485585 | threeruser1 | localhost | 3rs | Query | 6591 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19486419 | threeruser1 | localhost | 3rs | Query | 6529 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487180 | threeruser1 | localhost | 3rs | Query | 6466 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487653 | threeruser1 | localhost | 3rs | Query | 6404 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19488253 | threeruser1 | localhost | 3rs | Query | 6342 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489091 | threeruser1 | localhost | 3rs | Query | 6279 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489953 | threeruser1 | localhost | 3rs | Query | 6215 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19490825 | threeruser1 | localhost | 3rs | Query | 6150 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19491681 | threeruser1 | localhost | 3rs | Query | 6084 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492197 | threeruser1 | localhost | 3rs | Query | 6019 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492820 | threeruser1 | localhost | 3rs | Query | 5957 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493465 | threeruser1 | localhost | 3rs | Query | 5891 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493969 | threeruser1 | localhost | 3rs | Query | 5831 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19494785 | threeruser1 | localhost | 3rs | Query | 5770 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19495607 | threeruser1 | localhost | 3rs | Query | 5709 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19496203 | threeruser1 | localhost | 3rs | Query | 5646 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497048 | threeruser1 | localhost | 3rs | Query | 5583 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497855 | threeruser1 | localhost | 3rs | Query | 5523 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19498528 | threeruser1 | localhost | 3rs | Query | 5458 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19499400 | threeruser1 | localhost | 3rs | Query | 5392 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19500246 | threeruser1 | localhost | 3rs | Query | 5329 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501127 | threeruser1 | localhost | 3rs | Query | 5264 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501916 | threeruser1 | localhost | 3rs | Query | 5201 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19502793 | threeruser1 | localhost | 3rs | Query | 5136 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19503668 | threeruser1 | localhost | 3rs | Query | 5072 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504484 | threeruser1 | localhost | 3rs | Query | 5006 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504895 | threeruser1 | localhost | 3rs | Query | 4943 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19505741 | threeruser1 | localhost | 3rs | Query | 4880 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506593 | threeruser1 | localhost | 3rs | Query | 4817 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506742 | threeruser1 | localhost | 3rs | Query | 4806 | Waiting for table metadata lock | SELECT * FROM items WHERE TYPE = "Lessons" AND categories LIKE "%460%" ORDER BY id ASC |
| Kill | 19507467 | threeruser1 | localhost | 3rs | Query | 4752 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508243 | threeruser1 | localhost | 3rs | Query | 4688 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508614 | threeruser1 | localhost | 3rs | Query | 4627 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19509267 | threeruser1 | localhost | 3rs | Query | 4567 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19510142 | threeruser1 | localhost | 3rs | Query | 4502 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511018 | threeruser1 | localhost | 3rs | Query | 4436 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511659 | threeruser1 | localhost | 3rs | Query | 4376 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19512496 | threeruser1 | localhost | 3rs | Query | 4314 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19513332 | threeruser1 | localhost | 3rs | Query | 4252 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19514134 | threeruser1 | localhost | 3rs | Query | 4189 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515017 | threeruser1 | localhost | 3rs | Query | 4124 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515820 | threeruser1 | localhost | 3rs | Query | 4064 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19516503 | threeruser1 | localhost | 3rs | Query | 4000 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19517301 | threeruser1 | localhost | 3rs | Query | 3938 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518150 | threeruser1 | localhost | 3rs | Query | 3874 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518982 | threeruser1 | localhost | 3rs | Query | 3813 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19519471 | threeruser1 | localhost | 3rs | Query | 3748 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520101 | threeruser1 | localhost | 3rs | Query | 3685 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520947 | threeruser1 | localhost | 3rs | Query | 3622 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19521789 | threeruser1 | localhost | 3rs | Query | 3560 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19522630 | threeruser1 | localhost | 3rs | Query | 3497 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523317 | threeruser1 | localhost | 3rs | Query | 3432 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523767 | threeruser1 | localhost | 3rs | Query | 3367 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19524494 | threeruser1 | localhost | 3rs | Query | 3305 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19525339 | threeruser1 | localhost | 3rs | Query | 3242 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526158 | threeruser1 | localhost | 3rs | Query | 3182 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526878 | threeruser1 | localhost | 3rs | Query | 3120 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19527550 | threeruser1 | localhost | 3rs | Query | 3055 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19528396 | threeruser1 | localhost | 3rs | Query | 2991 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19529173 | threeruser1 | localhost | 3rs | Query | 2931 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19530445 | threeruser1 | localhost | 3rs | Query | 2802 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19531263 | threeruser1 | localhost | 3rs | Query | 2741 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532149 | threeruser1 | localhost | 3rs | Query | 2676 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532687 | threeruser1 | localhost | 3rs | Query | 2612 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19533438 | threeruser1 | localhost | 3rs | Query | 2546 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19534273 | threeruser1 | localhost | 3rs | Query | 2484 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535127 | threeruser1 | localhost | 3rs | Query | 2419 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535898 | threeruser1 | localhost | 3rs | Query | 2354 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19536500 | threeruser1 | localhost | 3rs | Query | 2289 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19537320 | threeruser1 | localhost | 3rs | Query | 2227 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19538166 | threeruser1 | localhost | 3rs | Query | 2165 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539023 | threeruser1 | localhost | 3rs | Query | 2100 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539826 | threeruser1 | localhost | 3rs | Query | 2040 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19540662 | threeruser1 | localhost | 3rs | Query | 1978 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19541464 | threeruser1 | localhost | 3rs | Query | 1916 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542292 | threeruser1 | localhost | 3rs | Query | 1854 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542872 | threeruser1 | localhost | 3rs | Query | 1793 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543359 | threeruser1 | localhost | 3rs | Query | 1731 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543610 | threeruser1 | localhost | 3rs | Query | 1668 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19544477 | threeruser1 | localhost | 3rs | Query | 1603 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545191 | threeruser1 | localhost | 3rs | Query | 1538 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545818 | threeruser1 | localhost | 3rs | Query | 1476 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19546696 | threeruser1 | localhost | 3rs | Query | 1411 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547373 | threeruser1 | localhost | 3rs | Query | 1350 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547694 | threeruser1 | localhost | 3rs | Query | 1284 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19548426 | threeruser1 | localhost | 3rs | Query | 1222 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19549300 | threeruser1 | localhost | 3rs | Query | 1157 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550149 | threeruser1 | localhost | 3rs | Query | 1093 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550962 | threeruser1 | localhost | 3rs | Query | 1033 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19551791 | threeruser1 | localhost | 3rs | Query | 971 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19552673 | threeruser1 | localhost | 3rs | Query | 907 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19553473 | threeruser1 | localhost | 3rs | Query | 847 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19554318 | threeruser1 | localhost | 3rs | Query | 783 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555044 | threeruser1 | localhost | 3rs | Query | 719 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555874 | threeruser1 | localhost | 3rs | Query | 657 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19556662 | threeruser1 | localhost | 3rs | Query | 594 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557045 | threeruser1 | localhost | 3rs | Query | 529 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557389 | threeruser1 | localhost | 3rs | Query | 464 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557456 | threeruser1 | localhost | 3rs | Query | 403 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557562 | threeruser1 | localhost | 3rs | Query | 368 | Waiting for table metadata lock | SELECT * FROM items WHERE TYPE = "Resources" AND categories LIKE "%130%" ORDER BY id ASC |
| Kill | 19557643 | threeruser1 | localhost | 3rs | Query | 343 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557844 | threeruser1 | localhost | 3rs | Query | 278 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558034 | threeruser1 | localhost | 3rs | Query | 217 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558238 | threeruser1 | localhost | 3rs | Query | 153 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558583 | threeruser1 | localhost | 3rs | Query | 83 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19559347 | threeruser1 | localhost | 3rs | Query | 24 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19559665 | threeruser1 | localhost | mysql | Query | 0 | --- | SHOW PROCESSLIST |
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize