localhost
|
ID | User | Host | Database | Command | Time | Status | SQL query |
|---|---|---|---|---|---|---|---|---|
| Kill | 19467223 | debian-sys-maint | localhost | 3rs | Query | 8311 | Sorting index | OPTIMIZE TABLE `items` |
| Kill | 19467233 | threeruser1 | localhost | 3rs | Query | 8310 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19469823 | threeruser1 | localhost | 3rs | Query | 7998 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470300 | threeruser1 | localhost | 3rs | Query | 7932 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470817 | threeruser1 | localhost | 3rs | Query | 7870 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19471719 | threeruser1 | localhost | 3rs | Query | 7804 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19472570 | threeruser1 | localhost | 3rs | Query | 7741 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473392 | threeruser1 | localhost | 3rs | Query | 7679 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473735 | threeruser1 | localhost | 3rs | Query | 7616 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19474538 | threeruser1 | localhost | 3rs | Query | 7556 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19475380 | threeruser1 | localhost | 3rs | Query | 7493 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476200 | threeruser1 | localhost | 3rs | Query | 7431 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476832 | threeruser1 | localhost | 3rs | Query | 7366 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19477551 | threeruser1 | localhost | 3rs | Query | 7304 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19478375 | threeruser1 | localhost | 3rs | Query | 7243 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19479205 | threeruser1 | localhost | 3rs | Query | 7181 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480097 | threeruser1 | localhost | 3rs | Query | 7116 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480940 | threeruser1 | localhost | 3rs | Query | 7052 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19481743 | threeruser1 | localhost | 3rs | Query | 6992 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19482592 | threeruser1 | localhost | 3rs | Query | 6929 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483408 | threeruser1 | localhost | 3rs | Query | 6869 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483898 | threeruser1 | localhost | 3rs | Query | 6804 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19484742 | threeruser1 | localhost | 3rs | Query | 6741 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19485585 | threeruser1 | localhost | 3rs | Query | 6678 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19486419 | threeruser1 | localhost | 3rs | Query | 6616 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487180 | threeruser1 | localhost | 3rs | Query | 6553 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487653 | threeruser1 | localhost | 3rs | Query | 6491 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19488253 | threeruser1 | localhost | 3rs | Query | 6429 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489091 | threeruser1 | localhost | 3rs | Query | 6366 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489953 | threeruser1 | localhost | 3rs | Query | 6302 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19490825 | threeruser1 | localhost | 3rs | Query | 6237 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19491681 | threeruser1 | localhost | 3rs | Query | 6171 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492197 | threeruser1 | localhost | 3rs | Query | 6106 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492820 | threeruser1 | localhost | 3rs | Query | 6044 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493465 | threeruser1 | localhost | 3rs | Query | 5978 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493969 | threeruser1 | localhost | 3rs | Query | 5918 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19494785 | threeruser1 | localhost | 3rs | Query | 5857 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19495607 | threeruser1 | localhost | 3rs | Query | 5796 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19496203 | threeruser1 | localhost | 3rs | Query | 5733 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497048 | threeruser1 | localhost | 3rs | Query | 5670 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497855 | threeruser1 | localhost | 3rs | Query | 5610 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19498528 | threeruser1 | localhost | 3rs | Query | 5545 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19499400 | threeruser1 | localhost | 3rs | Query | 5479 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19500246 | threeruser1 | localhost | 3rs | Query | 5416 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501127 | threeruser1 | localhost | 3rs | Query | 5351 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501916 | threeruser1 | localhost | 3rs | Query | 5288 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19502793 | threeruser1 | localhost | 3rs | Query | 5223 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19503668 | threeruser1 | localhost | 3rs | Query | 5159 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504484 | threeruser1 | localhost | 3rs | Query | 5093 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504895 | threeruser1 | localhost | 3rs | Query | 5030 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19505741 | threeruser1 | localhost | 3rs | Query | 4967 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506593 | threeruser1 | localhost | 3rs | Query | 4904 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506742 | threeruser1 | localhost | 3rs | Query | 4893 | 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 | 4839 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508243 | threeruser1 | localhost | 3rs | Query | 4775 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508614 | threeruser1 | localhost | 3rs | Query | 4714 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19509267 | threeruser1 | localhost | 3rs | Query | 4654 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19510142 | threeruser1 | localhost | 3rs | Query | 4589 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511018 | threeruser1 | localhost | 3rs | Query | 4523 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511659 | threeruser1 | localhost | 3rs | Query | 4463 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19512496 | threeruser1 | localhost | 3rs | Query | 4401 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19513332 | threeruser1 | localhost | 3rs | Query | 4339 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19514134 | threeruser1 | localhost | 3rs | Query | 4276 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515017 | threeruser1 | localhost | 3rs | Query | 4211 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515820 | threeruser1 | localhost | 3rs | Query | 4151 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19516503 | threeruser1 | localhost | 3rs | Query | 4087 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19517301 | threeruser1 | localhost | 3rs | Query | 4025 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518150 | threeruser1 | localhost | 3rs | Query | 3961 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518982 | threeruser1 | localhost | 3rs | Query | 3900 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19519471 | threeruser1 | localhost | 3rs | Query | 3835 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520101 | threeruser1 | localhost | 3rs | Query | 3772 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520947 | threeruser1 | localhost | 3rs | Query | 3709 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19521789 | threeruser1 | localhost | 3rs | Query | 3647 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19522630 | threeruser1 | localhost | 3rs | Query | 3584 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523317 | threeruser1 | localhost | 3rs | Query | 3519 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523767 | threeruser1 | localhost | 3rs | Query | 3454 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19524494 | threeruser1 | localhost | 3rs | Query | 3392 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19525339 | threeruser1 | localhost | 3rs | Query | 3329 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526158 | threeruser1 | localhost | 3rs | Query | 3269 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526878 | threeruser1 | localhost | 3rs | Query | 3207 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19527550 | threeruser1 | localhost | 3rs | Query | 3142 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19528396 | threeruser1 | localhost | 3rs | Query | 3078 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19529173 | threeruser1 | localhost | 3rs | Query | 3018 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19530445 | threeruser1 | localhost | 3rs | Query | 2889 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19531263 | threeruser1 | localhost | 3rs | Query | 2828 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532149 | threeruser1 | localhost | 3rs | Query | 2763 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532687 | threeruser1 | localhost | 3rs | Query | 2699 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19533438 | threeruser1 | localhost | 3rs | Query | 2633 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19534273 | threeruser1 | localhost | 3rs | Query | 2571 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535127 | threeruser1 | localhost | 3rs | Query | 2506 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535898 | threeruser1 | localhost | 3rs | Query | 2441 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19536500 | threeruser1 | localhost | 3rs | Query | 2376 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19537320 | threeruser1 | localhost | 3rs | Query | 2314 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19538166 | threeruser1 | localhost | 3rs | Query | 2252 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539023 | threeruser1 | localhost | 3rs | Query | 2187 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539826 | threeruser1 | localhost | 3rs | Query | 2127 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19540662 | threeruser1 | localhost | 3rs | Query | 2065 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19541464 | threeruser1 | localhost | 3rs | Query | 2003 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542292 | threeruser1 | localhost | 3rs | Query | 1941 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542872 | threeruser1 | localhost | 3rs | Query | 1880 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543359 | threeruser1 | localhost | 3rs | Query | 1818 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543610 | threeruser1 | localhost | 3rs | Query | 1755 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19544477 | threeruser1 | localhost | 3rs | Query | 1690 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545191 | threeruser1 | localhost | 3rs | Query | 1625 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545818 | threeruser1 | localhost | 3rs | Query | 1563 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19546696 | threeruser1 | localhost | 3rs | Query | 1498 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547373 | threeruser1 | localhost | 3rs | Query | 1437 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547694 | threeruser1 | localhost | 3rs | Query | 1371 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19548426 | threeruser1 | localhost | 3rs | Query | 1309 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19549300 | threeruser1 | localhost | 3rs | Query | 1244 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550149 | threeruser1 | localhost | 3rs | Query | 1180 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550962 | threeruser1 | localhost | 3rs | Query | 1120 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19551791 | threeruser1 | localhost | 3rs | Query | 1058 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19552673 | threeruser1 | localhost | 3rs | Query | 994 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19553473 | threeruser1 | localhost | 3rs | Query | 934 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19554318 | threeruser1 | localhost | 3rs | Query | 870 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555044 | threeruser1 | localhost | 3rs | Query | 806 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555874 | threeruser1 | localhost | 3rs | Query | 744 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19556662 | threeruser1 | localhost | 3rs | Query | 681 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557045 | threeruser1 | localhost | 3rs | Query | 616 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557389 | threeruser1 | localhost | 3rs | Query | 551 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557456 | threeruser1 | localhost | 3rs | Query | 490 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557562 | threeruser1 | localhost | 3rs | Query | 455 | 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 | 430 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557844 | threeruser1 | localhost | 3rs | Query | 365 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558034 | threeruser1 | localhost | 3rs | Query | 304 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558238 | threeruser1 | localhost | 3rs | Query | 240 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558583 | threeruser1 | localhost | 3rs | Query | 170 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19559347 | threeruser1 | localhost | 3rs | Query | 111 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19560205 | threeruser1 | localhost | 3rs | Query | 46 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19560663 | threeruser1 | localhost | mysql | Query | 0 | --- | SHOW PROCESSLIST |
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize