Page MenuHomePhabricator
Paste P54447

toolsdb_processlist
ActivePublic

Authored by fnegri on Dec 14 2023, 4:53 PM.
Tags
None
Referenced Files
F41600672: toolsdb_processlist
Dec 14 2023, 4:53 PM
Subscribers
None
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