Page MenuHomePhabricator
Paste P54447

toolsdb_processlist
ActivePublic
Actions

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
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits