localhost
|
ID | User | Host | Database | Command | Time | Status | SQL query |
|---|---|---|---|---|---|---|---|---|
| Kill | 19467223 | debian-sys-maint | localhost | 3rs | Query | 7385 | Sorting index | OPTIMIZE TABLE `items` |
| Kill | 19467233 | threeruser1 | localhost | 3rs | Query | 7384 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19469823 | threeruser1 | localhost | 3rs | Query | 7072 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470300 | threeruser1 | localhost | 3rs | Query | 7006 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19470817 | threeruser1 | localhost | 3rs | Query | 6944 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19471719 | threeruser1 | localhost | 3rs | Query | 6878 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19472570 | threeruser1 | localhost | 3rs | Query | 6815 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473392 | threeruser1 | localhost | 3rs | Query | 6753 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19473735 | threeruser1 | localhost | 3rs | Query | 6690 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19474538 | threeruser1 | localhost | 3rs | Query | 6630 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19475380 | threeruser1 | localhost | 3rs | Query | 6567 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476200 | threeruser1 | localhost | 3rs | Query | 6505 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19476832 | threeruser1 | localhost | 3rs | Query | 6440 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19477551 | threeruser1 | localhost | 3rs | Query | 6378 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19478375 | threeruser1 | localhost | 3rs | Query | 6317 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19479205 | threeruser1 | localhost | 3rs | Query | 6255 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480097 | threeruser1 | localhost | 3rs | Query | 6190 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19480940 | threeruser1 | localhost | 3rs | Query | 6126 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19481743 | threeruser1 | localhost | 3rs | Query | 6066 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19482592 | threeruser1 | localhost | 3rs | Query | 6003 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483408 | threeruser1 | localhost | 3rs | Query | 5943 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19483898 | threeruser1 | localhost | 3rs | Query | 5878 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19484742 | threeruser1 | localhost | 3rs | Query | 5815 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19485585 | threeruser1 | localhost | 3rs | Query | 5752 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19486419 | threeruser1 | localhost | 3rs | Query | 5690 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487180 | threeruser1 | localhost | 3rs | Query | 5627 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19487653 | threeruser1 | localhost | 3rs | Query | 5565 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19488253 | threeruser1 | localhost | 3rs | Query | 5503 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489091 | threeruser1 | localhost | 3rs | Query | 5440 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19489953 | threeruser1 | localhost | 3rs | Query | 5376 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19490825 | threeruser1 | localhost | 3rs | Query | 5311 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19491681 | threeruser1 | localhost | 3rs | Query | 5245 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492197 | threeruser1 | localhost | 3rs | Query | 5180 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19492820 | threeruser1 | localhost | 3rs | Query | 5118 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493465 | threeruser1 | localhost | 3rs | Query | 5052 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19493969 | threeruser1 | localhost | 3rs | Query | 4992 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19494785 | threeruser1 | localhost | 3rs | Query | 4931 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19495607 | threeruser1 | localhost | 3rs | Query | 4870 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19496203 | threeruser1 | localhost | 3rs | Query | 4807 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497048 | threeruser1 | localhost | 3rs | Query | 4744 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19497855 | threeruser1 | localhost | 3rs | Query | 4684 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19498528 | threeruser1 | localhost | 3rs | Query | 4619 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19499400 | threeruser1 | localhost | 3rs | Query | 4553 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19500246 | threeruser1 | localhost | 3rs | Query | 4490 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501127 | threeruser1 | localhost | 3rs | Query | 4425 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19501916 | threeruser1 | localhost | 3rs | Query | 4362 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19502793 | threeruser1 | localhost | 3rs | Query | 4297 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19503668 | threeruser1 | localhost | 3rs | Query | 4233 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504484 | threeruser1 | localhost | 3rs | Query | 4167 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19504895 | threeruser1 | localhost | 3rs | Query | 4104 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19505741 | threeruser1 | localhost | 3rs | Query | 4041 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506593 | threeruser1 | localhost | 3rs | Query | 3978 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19506742 | threeruser1 | localhost | 3rs | Query | 3967 | 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 | 3913 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508243 | threeruser1 | localhost | 3rs | Query | 3849 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19508614 | threeruser1 | localhost | 3rs | Query | 3788 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19509267 | threeruser1 | localhost | 3rs | Query | 3728 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19510142 | threeruser1 | localhost | 3rs | Query | 3663 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511018 | threeruser1 | localhost | 3rs | Query | 3597 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19511659 | threeruser1 | localhost | 3rs | Query | 3537 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19512496 | threeruser1 | localhost | 3rs | Query | 3475 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19513332 | threeruser1 | localhost | 3rs | Query | 3413 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19514134 | threeruser1 | localhost | 3rs | Query | 3350 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515017 | threeruser1 | localhost | 3rs | Query | 3285 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19515820 | threeruser1 | localhost | 3rs | Query | 3225 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19516503 | threeruser1 | localhost | 3rs | Query | 3161 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19517301 | threeruser1 | localhost | 3rs | Query | 3099 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518150 | threeruser1 | localhost | 3rs | Query | 3035 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19518982 | threeruser1 | localhost | 3rs | Query | 2974 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19519471 | threeruser1 | localhost | 3rs | Query | 2909 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520101 | threeruser1 | localhost | 3rs | Query | 2846 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19520947 | threeruser1 | localhost | 3rs | Query | 2783 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19521789 | threeruser1 | localhost | 3rs | Query | 2721 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19522630 | threeruser1 | localhost | 3rs | Query | 2658 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523317 | threeruser1 | localhost | 3rs | Query | 2593 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19523767 | threeruser1 | localhost | 3rs | Query | 2528 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19524494 | threeruser1 | localhost | 3rs | Query | 2466 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19525339 | threeruser1 | localhost | 3rs | Query | 2403 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526158 | threeruser1 | localhost | 3rs | Query | 2343 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19526878 | threeruser1 | localhost | 3rs | Query | 2281 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19527550 | threeruser1 | localhost | 3rs | Query | 2216 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19528396 | threeruser1 | localhost | 3rs | Query | 2152 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19529173 | threeruser1 | localhost | 3rs | Query | 2092 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19530445 | threeruser1 | localhost | 3rs | Query | 1963 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19531263 | threeruser1 | localhost | 3rs | Query | 1902 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532149 | threeruser1 | localhost | 3rs | Query | 1837 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19532687 | threeruser1 | localhost | 3rs | Query | 1773 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19533438 | threeruser1 | localhost | 3rs | Query | 1707 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19534273 | threeruser1 | localhost | 3rs | Query | 1645 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535127 | threeruser1 | localhost | 3rs | Query | 1580 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19535898 | threeruser1 | localhost | 3rs | Query | 1515 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19536500 | threeruser1 | localhost | 3rs | Query | 1450 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19537320 | threeruser1 | localhost | 3rs | Query | 1388 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19538166 | threeruser1 | localhost | 3rs | Query | 1326 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539023 | threeruser1 | localhost | 3rs | Query | 1261 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19539826 | threeruser1 | localhost | 3rs | Query | 1201 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19540662 | threeruser1 | localhost | 3rs | Query | 1139 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19541464 | threeruser1 | localhost | 3rs | Query | 1077 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542292 | threeruser1 | localhost | 3rs | Query | 1015 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19542872 | threeruser1 | localhost | 3rs | Query | 954 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543359 | threeruser1 | localhost | 3rs | Query | 892 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19543610 | threeruser1 | localhost | 3rs | Query | 829 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19544477 | threeruser1 | localhost | 3rs | Query | 764 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545191 | threeruser1 | localhost | 3rs | Query | 699 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19545818 | threeruser1 | localhost | 3rs | Query | 637 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19546696 | threeruser1 | localhost | 3rs | Query | 572 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547373 | threeruser1 | localhost | 3rs | Query | 511 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19547694 | threeruser1 | localhost | 3rs | Query | 445 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19548426 | threeruser1 | localhost | 3rs | Query | 383 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19549300 | threeruser1 | localhost | 3rs | Query | 318 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550149 | threeruser1 | localhost | 3rs | Query | 254 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19550962 | threeruser1 | localhost | 3rs | Query | 194 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19551791 | threeruser1 | localhost | 3rs | Query | 132 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19552673 | threeruser1 | localhost | 3rs | Query | 68 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19553473 | threeruser1 | localhost | 3rs | Query | 8 | Waiting for table metadata lock | SELECT * FROM `items` LIMIT 0 , 30 |
| Kill | 19553582 | threeruser1 | localhost | mysql | Query | 0 | --- | SHOW PROCESSLIST |
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize