Id User Host db Command Time State Info Progress 1 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000 3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 2 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 5 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000 7 event_scheduler localhost NULL Daemon 23920 Waiting on empty queue NULL 0.000 17 s51055 172.16.1.130:49315 s51055__anomiebot Sleep 118 NULL 0.000 21 root localhost heartbeat Sleep 0 NULL 0.000 54 s54438 172.16.0.119:1086 s54438__rwwiki Sleep 17 NULL 0.000 105 s55536 172.16.0.98:55432 s55536__qop Sleep 64 NULL 0.000 123 s51055 172.16.0.134:52942 s51055__anomiebot Sleep 20 NULL 0.000 129 s51055 172.16.1.173:1830 s51055__anomiebot Sleep 0 NULL 0.000 314 repl 172.16.4.121:35078 NULL Binlog Dump 23889 Master has sent all binlog to slave; waiting for binlog to be updated NULL 0.000 402 s54438 172.16.0.119:54371 s54438__rwwiki Sleep 9 NULL 0.000 839 s53213 172.16.2.77:33649 s53213__wmopbot Sleep 139 NULL 0.000 1879 s53685 172.16.2.67:63298 s53685__editgroups Sleep 7 NULL 0.000 2037 s54796 172.16.1.142:14638 s54796__mismatch_finder Sleep 0 NULL 0.000 2058 s55331 172.16.0.193:39495 NULL Sleep 1 NULL 0.000 2059 s55331 172.16.0.193:53645 s55331__mediawiki Sleep 9 NULL 0.000 2207 s55086 172.16.1.116:26913 NULL Sleep 15 NULL 0.000 2208 s55086 172.16.1.116:8762 s55086__mediawiki Sleep 1 NULL 0.000 2547 s54918 172.16.1.132:34560 s54918__mismatch_finder_staging Sleep 1 NULL 0.000 66469 s53220 172.16.1.137:21920 s53220__quickstatements_p Sleep 17 NULL 0.000 113027 s51080 172.16.1.132:33706 s51080__checkwiki_p Sleep 5 NULL 0.000 113520 s54874 172.16.6.147:42498 s54874__editgroups_commons Sleep 152 NULL 0.000 120159 s51055 172.16.2.185:16320 s51055__anomiebot Sleep 393 NULL 0.000 146291 s51512 172.16.4.165:37322 s51512__data Sleep 1 NULL 0.000 149547 s54857 172.16.0.98:51730 s54857__fixsuggesterbot Sleep 112 NULL 0.000 153174 s53220 172.16.1.137:50079 s53220__quickstatements_p Sleep 1 NULL 0.000 153201 s53220 172.16.1.137:17427 s53220__quickstatements_p Sleep 17 NULL 0.000 187000 s51412 172.16.6.70:34942 s51412__data Query 7345 Sending data SELECT SQL_CALC_FOUND_ROWS DISTINCT page_title, param_name, val_data FROM de_td_pages, de_td_templat 0.000 187122 s51412 172.16.6.70:52750 s51412__data Query 7330 Sending data SELECT SQL_CALC_FOUND_ROWS DISTINCT page_title, param_name, val_data FROM de_td_pages, de_td_templat 0.000 205529 s53220 172.16.1.137:52234 s53220__quickstatements_p Sleep 302 NULL 0.000 209617 s55568 172.16.2.210:20609 s55568__wdg2023 Sleep 121 NULL 0.000 246404 s54857 172.16.1.130:64099 s54857__fixsuggesterbot Sleep 0 NULL 0.000 248720 s51055 172.16.1.58:33552 s51055__anomiebot Sleep 475 NULL 0.000 249181 s54821 172.16.6.161:37370 s54821__cersei_p Sleep 6 NULL 0.000 249957 s53220 172.16.1.137:54542 s53220__quickstatements_p Sleep 302 NULL 0.000 250055 s51330 172.16.6.147:64210 s51330__copyvios_p Sleep 78 NULL 0.000 250939 s53098 172.16.1.137:28168 s53098__fountain Sleep 25 NULL 0.000 253754 s51434 172.16.7.12:13051 s51434__mixnmatch_p Query 1360 Sending data SELECT /* MixNMatch\\API::query_get_entries_by_q_or_value 1 */ * FROM entry WHERE ((q=355251) OR (ca 0.000 257183 s52532 172.16.3.214:50540 s52532__listeria_bot Sleep 216 NULL 0.000 257190 s52532 172.16.3.214:36790 s52532__listeria_bot Sleep 0 NULL 0.000 257220 s51083 172.16.1.37:48309 s51083__ukbot Sleep 17 NULL 0.000 257258 s52532 172.16.3.214:36794 s52532__listeria_bot Execute 0 Sending data SELECT * FROM (\n SELECT pagestatus.id,pagestatus.page,pagestatus.status,wikis.name AS wik 0.000 257358 s54725 172.16.2.172:35715 s54725__BotDB2 Sleep 6 NULL 0.000 257362 s54725 172.16.2.172:9294 s54725__BotDB2 Sleep 2 NULL 0.000 257363 s54725 172.16.2.172:4756 s54725__BotDB2 Sleep 2 NULL 0.000 257698 s53220 172.16.1.137:15427 s53220__quickstatements_p Sleep 0 NULL 0.000 258218 s51537 172.16.6.246:25879 s51537__checkpersondata Sleep 0 NULL 0.000 259113 s53098 172.16.1.137:51452 s53098__fountain Sleep 29 NULL 0.000 259118 s51330 172.16.6.147:6809 s51330__copyvios_p Sleep 180 NULL 0.000 259387 s51330 172.16.6.147:18584 s51330__copyvios_p Sleep 582 NULL 0.000 259430 s54725 172.16.7.51:59661 s54725__BotDB2 Sleep 528 NULL 0.000 259439 s54725 172.16.7.51:22242 s54725__BotDB2 Sleep 528 NULL 0.000 260276 s51412 172.16.6.161:57496 s51412__data Query 11 Update INSERT INTO de_td_data (data_use, data_param, data_value, data_cvalue, data_unnamed) VALUES (4113738 0.000 260387 s51412 172.16.6.70:44856 s51412__data Query 562 Sending data INSERT INTO nd_temp_table SELECT page_id, use_occ, (SELECT val_data FROM de_td_params, de_td_data, d 0.000 260470 s51330 172.16.6.147:15081 s51330__copyvios_p Sleep 132 NULL 0.000 260499 s51330 172.16.6.147:60649 s51330__copyvios_p Sleep 119 NULL 0.000 260658 s52481 172.16.1.185:45556 s52481__stats_global Sleep 524 NULL 0.000 261038 s52481 172.16.1.185:3967 s52481__stats_global Sleep 471 NULL 0.000 261197 s53220 172.16.1.137:63239 s53220__quickstatements_p Sleep 20 NULL 0.000 261260 s55613 172.16.2.210:15356 s55613__wdg2023institutions Sleep 453 NULL 0.000 261479 s52978 172.16.1.189:22916 s52978__replacer Sleep 7 NULL 0.000 261586 s55475 172.16.1.130:57131 s55475__annotool_p Sleep 413 NULL 0.000 261620 s52978 172.16.1.189:2880 s52978__replacer Sleep 104 NULL 0.000 262226 s51055 172.16.1.173:50949 s51055__anomiebot Sleep 313 NULL 0.000 262596 s55543 172.16.6.246:33824 s55543__xlinks_p Sleep 1 NULL 0.000 262631 s51541 172.16.1.37:52651 s51541__sulwatcher Sleep 317 NULL 0.000 262656 s52978 172.16.1.189:40454 s52978__replacer Sleep 314 NULL 0.000 262767 s55543 172.16.6.246:51800 s55543__xlinks_p Sleep 1 NULL 0.000 263022 s54569 172.16.2.185:8768 s54569__realtime_watchlist Sleep 264 NULL 0.000 263352 s54044 172.16.6.134:34116 s54044__wdumper Sleep 239 NULL 0.000 263387 s54044 172.16.6.134:25205 s54044__wdumper Sleep 237 NULL 0.000 263448 s54044 172.16.6.134:40335 s54044__wdumper Sleep 235 NULL 0.000 263577 s54044 172.16.6.134:50866 s54044__wdumper Sleep 228 NULL 0.000 263594 s54044 172.16.6.134:59176 s54044__wdumper Sleep 228 NULL 0.000 263626 s54044 172.16.1.137:11424 s54044__wdumper Sleep 227 NULL 0.000 263681 s54044 172.16.6.134:18428 s54044__wdumper Sleep 226 NULL 0.000 264077 s54044 172.16.6.134:31871 s54044__wdumper Sleep 217 NULL 0.000 264093 s54044 172.16.6.134:30129 s54044__wdumper Sleep 215 NULL 0.000 264116 s54044 172.16.1.137:25367 s54044__wdumper Sleep 212 NULL 0.000 264192 s54044 172.16.6.134:61343 s54044__wdumper Sleep 206 NULL 0.000 264255 s54044 172.16.6.134:20852 s54044__wdumper Sleep 201 NULL 0.000 264359 s55543 172.16.6.246:56177 s55543__xlinks_p Sleep 0 NULL 0.000 264389 s54113 172.16.0.193:48313 s54113__spacemedia Sleep 2 NULL 0.000 264803 s55543 172.16.6.246:9047 s55543__xlinks_p Sleep 1 NULL 0.000 264935 s55175 172.16.0.70:34698 s55175__ganfilter Sleep 0 NULL 0.000 264946 s53758 172.16.0.151:57982 s53758__ccistats Sleep 0 NULL 0.000 265570 s51434 172.16.5.199:37990 s51434__mixnmatch_p Sleep 0 NULL 0.000 265571 s51434 172.16.5.199:48980 s51434__mixnmatch_p Sleep 0 NULL 0.000 265573 s51434 172.16.5.199:5898 s51434__mixnmatch_p Sleep 0 NULL 0.000 265574 s51434 172.16.5.199:20329 s51434__mixnmatch_p Sleep 0 NULL 0.000 265584 s55084 172.16.3.77:36105 s51306__copyright_p Sleep 76 NULL 0.000 265784 s53952 172.16.0.222:7421 s53952__freebase_p Query 60 Sending data SELECT `keys`.topic_id AS keys_topic_id, `keys`.`key` AS keys_key \nFROM `keys` \nWHERE `keys`.`key` = 0.000 265800 s53685 172.16.7.51:16794 s53685__editgroups Sleep 0 NULL 0.000 266015 s55543 172.16.6.246:5899 s55543__xlinks_p Sleep 0 NULL 0.000 266176 s54725 172.16.0.241:2413 s54725__BotDB2 Sleep 35 NULL 0.000 266336 s54113 172.16.1.38:40318 s54113__spacemedia Sleep 0 NULL 0.000 266367 s51306 172.16.4.165:52906 s51306__copyright_p Sleep 13 NULL 0.000 266424 s54113 172.16.0.193:30734 s54113__spacemedia Sleep 6 NULL 0.000 266428 s51211 172.16.1.137:13028 s51211__duplicity_p Query 6 Creating sort index SELECT * FROM no_wd WHERE random>0.14923930501064 order by random limit 500 0.000 266438 s54113 172.16.1.38:58972 s54113__spacemedia Sleep 5 NULL 0.000 266439 s53794 172.16.0.35:53496 s53794__leaderboard Sleep 4 NULL 0.000 266452 s52421 172.16.1.189:8429 s52421__commonsdelinquent_p Query 2 Sending data SELECT max(log_timestamp) AS max_ts FROM event WHERE done=1 0.000 266473 root localhost NULL Query 0 Init show processlist 0.000