mysql> show processlist; +-------+----------+-----------------------+----------+----------------+-------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+----------+-----------------------+----------+----------------+-------+----------------------+------------------------------------------------------------------------------------------------------+ | 70 | DELAYED | localhost | wikidb | Delayed_insert | 107 | Waiting on cond | searchindex | | 88 | DELAYED | localhost | plwiki | Delayed_insert | 9744 | Waiting on cond | searchindex | | 1319 | DELAYED | localhost | metawiki | Delayed_insert | 2518 | Waiting on cond | searchindex | | 1440 | DELAYED | localhost | eowiki | Delayed_insert | 18043 | Waiting on cond | searchindex | | 2341 | DELAYED | localhost | nlwiki | Delayed_insert | 6045 | Waiting on cond | searchindex | | 23897 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 23900 | wikiuser | localhost.localdomain | wikidb | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 23903 | wikiuser | localhost.localdomain | wikidb | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 23905 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 23906 | wikiuser | localhost.localdomain | wikidb | Sleep | 142 | | NULL | | 23909 | wikiuser | localhost.localdomain | wikidb | Sleep | 243 | | NULL | | 23912 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Opening tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=1 AND cur_title='Halting_problem' | | 23913 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Amazing_Stories' | | 23916 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 23917 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Ammonal' | | 23918 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_minor_edit FROM cur WHERE cur_id=0 | | 23919 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT cur_text,cur_timestamp,cur_user,cur_counter FROM cur WHERE cur_id=28823 | | 23920 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT cur_text,cur_timestamp,cur_user,cur_counter FROM cur WHERE cur_id=51672 | | 23922 | wikiuser | localhost.localdomain | wikidb | Sleep | 2 | | NULL | | 23923 | wikiuser | localhost.localdomain | wikidb | Query | 1 | Opening tables | SELECT 1 FROM user_newtalk WHERE user_ip='192.220.111.228' | | 23924 | wikiuser | localhost.localdomain | wikidb | Sleep | 207 | | NULL | | 23926 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Welfare' | | 23928 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Science_fiction' | | 23929 | wikiuser | localhost.localdomain | metawiki | Sleep | 0 | | NULL | | 23931 | wikiuser | localhost.localdomain | wikidb | Sleep | 183 | | NULL | | 23957 | wikiuser | localhost.localdomain | dewiki | Query | 79 | Copying to tmp table | SELECT DISTINCT cur_title, cur_counter FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 ORDER BY | | 23960 | wikiuser | localhost.localdomain | wikidb | Sleep | 192 | | NULL | | 23968 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 23975 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=4 AND cur_title='Neutral_point_of_view' | | 23981 | wikiuser | localhost.localdomain | dawiki | Query | 2 | Opening tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Gr?sk' | | 24014 | wikiuser | localhost.localdomain | eswiki | Query | 1 | NULL | ROLLBACK | | 24039 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 24043 | wikiuser | localhost.localdomain | wikidb | Query | 1 | Opening tables | SELECT 1 FROM user_newtalk WHERE user_ip='199.183.72.214' | | 24245 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Amplitude_modulation' | | 24649 | DELAYED | localhost | testwiki | Delayed_insert | 427 | Waiting on cond | searchindex | | 24965 | wikiuser | localhost.localdomain | wikidb | Query | 1 | Opening tables | SELECT 1 FROM user_newtalk WHERE user_ip='203.15.249.18' | | 25041 | wikiuser | localhost.localdomain | wikidb | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25044 | wikiuser | localhost.localdomain | frwiki | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Jeu_d\'?checs' | | 25075 | wikiuser | localhost.localdomain | wikidb | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25076 | wikiuser | localhost.localdomain | frwiki | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='?tats-Unis' | | 25174 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page AND (MATCH | | 25196 | wikiuser | localhost.localdomain | wikidb | Sleep | 3 | | NULL | | 25256 | wikiuser | localhost.localdomain | metawiki | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25273 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT cur_text,cur_timestamp,cur_user,cur_counter FROM cur WHERE cur_id=60431 | | 25276 | wikiuser | localhost.localdomain | wikidb | Sleep | 172 | | NULL | | 25308 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Poetical_Sketches' | | 25330 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25336 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=1 AND cur_title='Amazon_Standard_Identifica | | 25338 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=1 AND cur_title='Banach_algebra' | | 25340 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Science_fiction' | | 25342 | wikiuser | localhost.localdomain | dewiki | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='30._November' | | 25343 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25345 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=1 AND cur_title='Nika_revolt' | | 25347 | wikiuser | localhost.localdomain | wikidb | Sleep | 161 | | NULL | | 25360 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Main_Page' | | 25367 | wikiuser | localhost.localdomain | wikidb | Sleep | 128 | | NULL | | 25368 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT cur_text,cur_timestamp,cur_user,cur_counter FROM cur WHERE cur_id=21170 | | 25369 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Upper_German' | | 25370 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Star_Trek:_Deep_Space_Nine | | 25371 | wikiuser | localhost.localdomain | dewiki | Sleep | 0 | | NULL | | 25372 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25373 | wikiuser | localhost.localdomain | wikidb | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25374 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25375 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Bertrand_Rusell' | | 25377 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Cheops' | | 25378 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Antagonist' | | 25379 | wikiuser | localhost.localdomain | plwiki | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25384 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25386 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=4 AND cur_title='FAQ' | | 25391 | wikiuser | localhost.localdomain | metawiki | Sleep | 1 | | NULL | | 25393 | wikiuser | localhost.localdomain | wikidb | Sleep | 164 | | NULL | | 25406 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Michelangelo' | | 25407 | wikiuser | localhost.localdomain | eowiki | Sleep | 0 | | NULL | | 25410 | wikiuser | localhost.localdomain | wikidb | Sleep | 187 | | NULL | | 25413 | wikiuser | localhost.localdomain | wikidb | Sleep | 207 | | NULL | | 25415 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25416 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 25417 | wikiuser | localhost.localdomain | wikidb | Sleep | 1 | | NULL | | 25418 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25420 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25421 | wikiuser | localhost.localdomain | wikidb | Query | 2 | preparing | SELECT math_outputhash,math_html_conservativeness,math_html FROM math WHERE math_inputhash = 'x? 8-\ | | 25422 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25423 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Opening tables | SELECT 1 FROM user_newtalk WHERE user_ip='12.65.12.230' | | 25424 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=1 AND cur_title='Ankylosauria' | | 25425 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=1 AND cur_title='Bruce_Sinofsky' | | 25426 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Nudism' | | 25427 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=4 AND cur_title='FAQ' | | 25428 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT old_timestamp,old_text FROM old WHERE old_id=656727 | | 25429 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT old_timestamp,old_text FROM old,recentchanges WHERE old_id=rc_last_oldid AND rc_this_oldid | | 25430 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25431 | wikiuser | localhost.localdomain | wikidb | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25432 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25433 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25434 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25435 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25436 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25437 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25438 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Sending data | SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page AND (MATCH | | 25439 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=4 AND cur_title='FAQ' | | 25440 | wikiuser | localhost.localdomain | wikidb | Query | 3 | Copying to tmp table | SELECT cur_id,cur_namespace,cur_title,cur_comment, cur_user,cur_user_text,cur_timestamp,cur_mino | | 25441 | wikiuser | localhost.localdomain | wikidb | Query | 3 | closing tables | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25442 | wikiuser | localhost.localdomain | wikidb | Query | 2 | Sending data | SELECT HIGH_PRIORITY cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AND l_fro | | 25443 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT cur_text,cur_timestamp,cur_user,cur_counter FROM cur WHERE cur_id=46641 | | 25444 | wikiuser | localhost.localdomain | wikidb | Query | 2 | closing tables | SELECT HIGH_PRIORITY cur_id FROM cur WHERE cur_namespace=0 AND cur_title='Etymology' | +-------+----------+-----------------------+----------+----------------+-------+----------------------+------------------------------------------------------------------------------------------------------+ 104 rows in set (0.00 sec)