localhost
|
ID | User | Host | Database | Command | Time | Status | SQL query |
|---|---|---|---|---|---|---|---|---|
| Kill | 19467223 | debian-sys-maint | localhost | 3rs | Query | 7728 | Sorting index | OPTIMIZE TABLE `items` |
| Kill | 19467233 | threeruser1 | localhost | 3rs | Query | 7727 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19469823 | threeruser1 | localhost | 3rs | Query | 7415 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470300 | threeruser1 | localhost | 3rs | Query | 7349 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470817 | threeruser1 | localhost | 3rs | Query | 7287 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19471719 | threeruser1 | localhost | 3rs | Query | 7221 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19472570 | threeruser1 | localhost | 3rs | Query | 7158 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473392 | threeruser1 | localhost | 3rs | Query | 7096 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473735 | threeruser1 | localhost | 3rs | Query | 7033 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19474538 | threeruser1 | localhost | 3rs | Query | 6973 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19475380 | threeruser1 | localhost | 3rs | Query | 6910 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476200 | threeruser1 | localhost | 3rs | Query | 6848 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476832 | threeruser1 | localhost | 3rs | Query | 6783 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19477551 | threeruser1 | localhost | 3rs | Query | 6721 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19478375 | threeruser1 | localhost | 3rs | Query | 6660 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19479205 | threeruser1 | localhost | 3rs | Query | 6598 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480097 | threeruser1 | localhost | 3rs | Query | 6533 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480940 | threeruser1 | localhost | 3rs | Query | 6469 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19481743 | threeruser1 | localhost | 3rs | Query | 6409 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19482592 | threeruser1 | localhost | 3rs | Query | 6346 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483408 | threeruser1 | localhost | 3rs | Query | 6286 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483898 | threeruser1 | localhost | 3rs | Query | 6221 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19484742 | threeruser1 | localhost | 3rs | Query | 6158 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19485585 | threeruser1 | localhost | 3rs | Query | 6095 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19486419 | threeruser1 | localhost | 3rs | Query | 6033 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487180 | threeruser1 | localhost | 3rs | Query | 5970 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487653 | threeruser1 | localhost | 3rs | Query | 5908 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19488253 | threeruser1 | localhost | 3rs | Query | 5846 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489091 | threeruser1 | localhost | 3rs | Query | 5783 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489953 | threeruser1 | localhost | 3rs | Query | 5719 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19490825 | threeruser1 | localhost | 3rs | Query | 5654 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19491681 | threeruser1 | localhost | 3rs | Query | 5588 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492197 | threeruser1 | localhost | 3rs | Query | 5523 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492820 | threeruser1 | localhost | 3rs | Query | 5461 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493465 | threeruser1 | localhost | 3rs | Query | 5395 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493969 | threeruser1 | localhost | 3rs | Query | 5335 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19494785 | threeruser1 | localhost | 3rs | Query | 5274 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19495607 | threeruser1 | localhost | 3rs | Query | 5213 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19496203 | threeruser1 | localhost | 3rs | Query | 5150 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497048 | threeruser1 | localhost | 3rs | Query | 5087 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497855 | threeruser1 | localhost | 3rs | Query | 5027 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19498528 | threeruser1 | localhost | 3rs | Query | 4962 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19499400 | threeruser1 | localhost | 3rs | Query | 4896 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19500246 | threeruser1 | localhost | 3rs | Query | 4833 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501127 | threeruser1 | localhost | 3rs | Query | 4768 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501916 | threeruser1 | localhost | 3rs | Query | 4705 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19502793 | threeruser1 | localhost | 3rs | Query | 4640 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19503668 | threeruser1 | localhost | 3rs | Query | 4576 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504484 | threeruser1 | localhost | 3rs | Query | 4510 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504895 | threeruser1 | localhost | 3rs | Query | 4447 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19505741 | threeruser1 | localhost | 3rs | Query | 4384 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506593 | threeruser1 | localhost | 3rs | Query | 4321 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506742 | threeruser1 | localhost | 3rs | Query | 4310 | 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 | 4256 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508243 | threeruser1 | localhost | 3rs | Query | 4192 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508614 | threeruser1 | localhost | 3rs | Query | 4131 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19509267 | threeruser1 | localhost | 3rs | Query | 4071 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19510142 | threeruser1 | localhost | 3rs | Query | 4006 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511018 | threeruser1 | localhost | 3rs | Query | 3940 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511659 | threeruser1 | localhost | 3rs | Query | 3880 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19512496 | threeruser1 | localhost | 3rs | Query | 3818 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19513332 | threeruser1 | localhost | 3rs | Query | 3756 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19514134 | threeruser1 | localhost | 3rs | Query | 3693 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515017 | threeruser1 | localhost | 3rs | Query | 3628 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515820 | threeruser1 | localhost | 3rs | Query | 3568 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19516503 | threeruser1 | localhost | 3rs | Query | 3504 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19517301 | threeruser1 | localhost | 3rs | Query | 3442 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518150 | threeruser1 | localhost | 3rs | Query | 3378 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518982 | threeruser1 | localhost | 3rs | Query | 3317 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19519471 | threeruser1 | localhost | 3rs | Query | 3252 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520101 | threeruser1 | localhost | 3rs | Query | 3189 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520947 | threeruser1 | localhost | 3rs | Query | 3126 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19521789 | threeruser1 | localhost | 3rs | Query | 3064 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19522630 | threeruser1 | localhost | 3rs | Query | 3001 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523317 | threeruser1 | localhost | 3rs | Query | 2936 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523767 | threeruser1 | localhost | 3rs | Query | 2871 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19524494 | threeruser1 | localhost | 3rs | Query | 2809 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19525339 | threeruser1 | localhost | 3rs | Query | 2746 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526158 | threeruser1 | localhost | 3rs | Query | 2686 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526878 | threeruser1 | localhost | 3rs | Query | 2624 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19527550 | threeruser1 | localhost | 3rs | Query | 2559 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19528396 | threeruser1 | localhost | 3rs | Query | 2495 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19529173 | threeruser1 | localhost | 3rs | Query | 2435 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19530445 | threeruser1 | localhost | 3rs | Query | 2306 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19531263 | threeruser1 | localhost | 3rs | Query | 2245 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532149 | threeruser1 | localhost | 3rs | Query | 2180 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532687 | threeruser1 | localhost | 3rs | Query | 2116 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19533438 | threeruser1 | localhost | 3rs | Query | 2050 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19534273 | threeruser1 | localhost | 3rs | Query | 1988 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535127 | threeruser1 | localhost | 3rs | Query | 1923 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535898 | threeruser1 | localhost | 3rs | Query | 1858 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19536500 | threeruser1 | localhost | 3rs | Query | 1793 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19537320 | threeruser1 | localhost | 3rs | Query | 1731 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19538166 | threeruser1 | localhost | 3rs | Query | 1669 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539023 | threeruser1 | localhost | 3rs | Query | 1604 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539826 | threeruser1 | localhost | 3rs | Query | 1544 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19540662 | threeruser1 | localhost | 3rs | Query | 1482 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19541464 | threeruser1 | localhost | 3rs | Query | 1420 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542292 | threeruser1 | localhost | 3rs | Query | 1358 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542872 | threeruser1 | localhost | 3rs | Query | 1297 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543359 | threeruser1 | localhost | 3rs | Query | 1235 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543610 | threeruser1 | localhost | 3rs | Query | 1172 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19544477 | threeruser1 | localhost | 3rs | Query | 1107 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545191 | threeruser1 | localhost | 3rs | Query | 1042 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545818 | threeruser1 | localhost | 3rs | Query | 980 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19546696 | threeruser1 | localhost | 3rs | Query | 915 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547373 | threeruser1 | localhost | 3rs | Query | 854 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547694 | threeruser1 | localhost | 3rs | Query | 788 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19548426 | threeruser1 | localhost | 3rs | Query | 726 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19549300 | threeruser1 | localhost | 3rs | Query | 661 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550149 | threeruser1 | localhost | 3rs | Query | 597 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550962 | threeruser1 | localhost | 3rs | Query | 537 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19551791 | threeruser1 | localhost | 3rs | Query | 475 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19552673 | threeruser1 | localhost | 3rs | Query | 411 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19553473 | threeruser1 | localhost | 3rs | Query | 351 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19554318 | threeruser1 | localhost | 3rs | Query | 287 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555044 | threeruser1 | localhost | 3rs | Query | 223 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555874 | threeruser1 | localhost | 3rs | Query | 161 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19556662 | threeruser1 | localhost | 3rs | Query | 98 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557045 | threeruser1 | localhost | 3rs | Query | 33 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557233 | threeruser1 | localhost | mysql | Query | 0 | --- | SHOW PROCESSLIST |
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize