localhost
|
ID | User | Host | Database | Command | Time | Status | SQL query |
|---|---|---|---|---|---|---|---|---|
| Kill | 19467223 | debian-sys-maint | localhost | 3rs | Query | 8555 | Sorting index | OPTIMIZE TABLE `items` |
| Kill | 19467233 | threeruser1 | localhost | 3rs | Query | 8554 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19469823 | threeruser1 | localhost | 3rs | Query | 8242 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470300 | threeruser1 | localhost | 3rs | Query | 8176 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470817 | threeruser1 | localhost | 3rs | Query | 8114 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19471719 | threeruser1 | localhost | 3rs | Query | 8048 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19472570 | threeruser1 | localhost | 3rs | Query | 7985 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473392 | threeruser1 | localhost | 3rs | Query | 7923 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473735 | threeruser1 | localhost | 3rs | Query | 7860 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19474538 | threeruser1 | localhost | 3rs | Query | 7800 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19475380 | threeruser1 | localhost | 3rs | Query | 7737 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476200 | threeruser1 | localhost | 3rs | Query | 7675 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476832 | threeruser1 | localhost | 3rs | Query | 7610 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19477551 | threeruser1 | localhost | 3rs | Query | 7548 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19478375 | threeruser1 | localhost | 3rs | Query | 7487 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19479205 | threeruser1 | localhost | 3rs | Query | 7425 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480097 | threeruser1 | localhost | 3rs | Query | 7360 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480940 | threeruser1 | localhost | 3rs | Query | 7296 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19481743 | threeruser1 | localhost | 3rs | Query | 7236 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19482592 | threeruser1 | localhost | 3rs | Query | 7173 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483408 | threeruser1 | localhost | 3rs | Query | 7113 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483898 | threeruser1 | localhost | 3rs | Query | 7048 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19484742 | threeruser1 | localhost | 3rs | Query | 6985 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19485585 | threeruser1 | localhost | 3rs | Query | 6922 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19486419 | threeruser1 | localhost | 3rs | Query | 6860 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487180 | threeruser1 | localhost | 3rs | Query | 6797 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487653 | threeruser1 | localhost | 3rs | Query | 6735 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19488253 | threeruser1 | localhost | 3rs | Query | 6673 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489091 | threeruser1 | localhost | 3rs | Query | 6610 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489953 | threeruser1 | localhost | 3rs | Query | 6546 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19490825 | threeruser1 | localhost | 3rs | Query | 6481 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19491681 | threeruser1 | localhost | 3rs | Query | 6415 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492197 | threeruser1 | localhost | 3rs | Query | 6350 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492820 | threeruser1 | localhost | 3rs | Query | 6288 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493465 | threeruser1 | localhost | 3rs | Query | 6222 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493969 | threeruser1 | localhost | 3rs | Query | 6162 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19494785 | threeruser1 | localhost | 3rs | Query | 6101 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19495607 | threeruser1 | localhost | 3rs | Query | 6040 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19496203 | threeruser1 | localhost | 3rs | Query | 5977 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497048 | threeruser1 | localhost | 3rs | Query | 5914 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497855 | threeruser1 | localhost | 3rs | Query | 5854 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19498528 | threeruser1 | localhost | 3rs | Query | 5789 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19499400 | threeruser1 | localhost | 3rs | Query | 5723 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19500246 | threeruser1 | localhost | 3rs | Query | 5660 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501127 | threeruser1 | localhost | 3rs | Query | 5595 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501916 | threeruser1 | localhost | 3rs | Query | 5532 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19502793 | threeruser1 | localhost | 3rs | Query | 5467 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19503668 | threeruser1 | localhost | 3rs | Query | 5403 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504484 | threeruser1 | localhost | 3rs | Query | 5337 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504895 | threeruser1 | localhost | 3rs | Query | 5274 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19505741 | threeruser1 | localhost | 3rs | Query | 5211 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506593 | threeruser1 | localhost | 3rs | Query | 5148 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506742 | threeruser1 | localhost | 3rs | Query | 5137 | 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 | 5083 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508243 | threeruser1 | localhost | 3rs | Query | 5019 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508614 | threeruser1 | localhost | 3rs | Query | 4958 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19509267 | threeruser1 | localhost | 3rs | Query | 4898 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19510142 | threeruser1 | localhost | 3rs | Query | 4833 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511018 | threeruser1 | localhost | 3rs | Query | 4767 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511659 | threeruser1 | localhost | 3rs | Query | 4707 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19512496 | threeruser1 | localhost | 3rs | Query | 4645 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19513332 | threeruser1 | localhost | 3rs | Query | 4583 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19514134 | threeruser1 | localhost | 3rs | Query | 4520 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515017 | threeruser1 | localhost | 3rs | Query | 4455 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515820 | threeruser1 | localhost | 3rs | Query | 4395 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19516503 | threeruser1 | localhost | 3rs | Query | 4331 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19517301 | threeruser1 | localhost | 3rs | Query | 4269 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518150 | threeruser1 | localhost | 3rs | Query | 4205 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518982 | threeruser1 | localhost | 3rs | Query | 4144 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19519471 | threeruser1 | localhost | 3rs | Query | 4079 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520101 | threeruser1 | localhost | 3rs | Query | 4016 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520947 | threeruser1 | localhost | 3rs | Query | 3953 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19521789 | threeruser1 | localhost | 3rs | Query | 3891 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19522630 | threeruser1 | localhost | 3rs | Query | 3828 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523317 | threeruser1 | localhost | 3rs | Query | 3763 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523767 | threeruser1 | localhost | 3rs | Query | 3698 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19524494 | threeruser1 | localhost | 3rs | Query | 3636 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19525339 | threeruser1 | localhost | 3rs | Query | 3573 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526158 | threeruser1 | localhost | 3rs | Query | 3513 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526878 | threeruser1 | localhost | 3rs | Query | 3451 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19527550 | threeruser1 | localhost | 3rs | Query | 3386 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19528396 | threeruser1 | localhost | 3rs | Query | 3322 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19529173 | threeruser1 | localhost | 3rs | Query | 3262 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19530445 | threeruser1 | localhost | 3rs | Query | 3133 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19531263 | threeruser1 | localhost | 3rs | Query | 3072 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532149 | threeruser1 | localhost | 3rs | Query | 3007 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532687 | threeruser1 | localhost | 3rs | Query | 2943 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19533438 | threeruser1 | localhost | 3rs | Query | 2877 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19534273 | threeruser1 | localhost | 3rs | Query | 2815 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535127 | threeruser1 | localhost | 3rs | Query | 2750 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535898 | threeruser1 | localhost | 3rs | Query | 2685 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19536500 | threeruser1 | localhost | 3rs | Query | 2620 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19537320 | threeruser1 | localhost | 3rs | Query | 2558 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19538166 | threeruser1 | localhost | 3rs | Query | 2496 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539023 | threeruser1 | localhost | 3rs | Query | 2431 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539826 | threeruser1 | localhost | 3rs | Query | 2371 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19540662 | threeruser1 | localhost | 3rs | Query | 2309 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19541464 | threeruser1 | localhost | 3rs | Query | 2247 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542292 | threeruser1 | localhost | 3rs | Query | 2185 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542872 | threeruser1 | localhost | 3rs | Query | 2124 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543359 | threeruser1 | localhost | 3rs | Query | 2062 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543610 | threeruser1 | localhost | 3rs | Query | 1999 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19544477 | threeruser1 | localhost | 3rs | Query | 1934 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545191 | threeruser1 | localhost | 3rs | Query | 1869 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545818 | threeruser1 | localhost | 3rs | Query | 1807 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19546696 | threeruser1 | localhost | 3rs | Query | 1742 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547373 | threeruser1 | localhost | 3rs | Query | 1681 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547694 | threeruser1 | localhost | 3rs | Query | 1615 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19548426 | threeruser1 | localhost | 3rs | Query | 1553 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19549300 | threeruser1 | localhost | 3rs | Query | 1488 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550149 | threeruser1 | localhost | 3rs | Query | 1424 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550962 | threeruser1 | localhost | 3rs | Query | 1364 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19551791 | threeruser1 | localhost | 3rs | Query | 1302 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19552673 | threeruser1 | localhost | 3rs | Query | 1238 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19553473 | threeruser1 | localhost | 3rs | Query | 1178 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19554318 | threeruser1 | localhost | 3rs | Query | 1114 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555044 | threeruser1 | localhost | 3rs | Query | 1050 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19555874 | threeruser1 | localhost | 3rs | Query | 988 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19556662 | threeruser1 | localhost | 3rs | Query | 925 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557045 | threeruser1 | localhost | 3rs | Query | 860 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557389 | threeruser1 | localhost | 3rs | Query | 795 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557456 | threeruser1 | localhost | 3rs | Query | 734 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557562 | threeruser1 | localhost | 3rs | Query | 699 | 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 | 674 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19557844 | threeruser1 | localhost | 3rs | Query | 609 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558034 | threeruser1 | localhost | 3rs | Query | 548 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558238 | threeruser1 | localhost | 3rs | Query | 484 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19558583 | threeruser1 | localhost | 3rs | Query | 414 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19559347 | threeruser1 | localhost | 3rs | Query | 355 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19560205 | threeruser1 | localhost | 3rs | Query | 290 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19560848 | threeruser1 | localhost | 3rs | Query | 230 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19561588 | threeruser1 | localhost | 3rs | Query | 169 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19562467 | threeruser1 | localhost | 3rs | Query | 104 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19563333 | threeruser1 | localhost | 3rs | Query | 38 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19563770 | threeruser1 | localhost | 3rs | Query | 5 | Waiting for table metadata lock | SELECT * FROM items WHERE TYPE = "Lessons" AND categories LIKE "%120%" ORDER BY id ASC |
| Kill | 19563837 | threeruser1 | localhost | mysql | Query | 0 | --- | SHOW PROCESSLIST |
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize