Marostegui added a comment. |
eqiad db API hosts return the query in less than a second as they have the correct schema:
root@db1104.eqiad.wmnet[wikidatawiki]> select @@hostname; +------------+ | @@hostname | +------------+ | db1104 | +------------+ 1 row in set (0.00 sec)
root@db1104.eqiad.wmnet[wikidatawiki]> SELECT rc_id,rc_timestamp,rc_namespace,rc_title,rc_cur_id,rc_type,rc_deleted,rc_this_oldid,rc_last_oldid FROM `recentchanges` WHERE (rc_timestamp>='20180914110000') AND rc_namespace IN ('0','120') AND rc_type IN ('0','1','3','6') ORDER BY rc_timestamp ASC,rc_id ASC LIMIT 101 ; +-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+ | rc_id | rc_timestamp | rc_namespace | rc_title | rc_cur_id | rc_type | rc_deleted | rc_this_oldid | rc_last_oldid | +-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+ | 781488474 | 20180914110000 | 0 | Q11614745 | 12755105 | 0 | 0 | 745861888 | 745695128 | | 781488475 | 20180914110000 | 0 | Q49559730 | 50562117 | 0 | 0 | 745861890 | 708599303 | | 781488476 | 20180914110000 | 0 | Q49909619 | 50909548 | 0 | 0 | 745861889 | 745861887 | | 781488477 | 20180914110000 | 0 | Q34205543 | 35645575 | 0 | 0 | 745861891 | 743199425 | <snip> 101 rows in set (0.00 sec) root@db1092.eqiad.wmnet[wikidatawiki]> select @@hostname; +------------+ | @@hostname | +------------+ | db1092 | +------------+ 1 row in set (0.00 sec) root@db1092.eqiad.wmnet[wikidatawiki]> SELECT rc_id,rc_timestamp,rc_namespace,rc_title,rc_cur_id,rc_type,rc_deleted,rc_this_oldid,rc_last_oldid FROM `recentchanges` WHERE (rc_timestamp>='20180914110000') AND rc_namespace IN ('0','120') AND rc_type IN ('0','1','3','6') ORDER BY rc_timestamp ASC,rc_id ASC LIMIT 101 ; +-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+ | rc_id | rc_timestamp | rc_namespace | rc_title | rc_cur_id | rc_type | rc_deleted | rc_this_oldid | rc_last_oldid | +-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+ | 781488474 | 20180914110000 | 0 | Q11614745 | 12755105 | 0 | 0 | 745861888 | 745695128 | | 781488475 | 20180914110000 | 0 | Q49559730 | 50562117 | 0 | 0 | 745861890 | 708599303 | | 781488476 | 20180914110000 | 0 | Q49909619 | 50909548 | 0 | 0 | 745861889 | 745861887 | | 781488477 | 20180914110000 | 0 | Q34205543 | 35645575 | 0 | 0 | 745861891 | 743199425 | | 781488478 | 20180914110000 | 0 | Q49909619 | 50909548 | 0 | 0 | 745861892 | 745861889 | <snip> 101 rows in set (0.01 sec)
TASK DETAIL
EMAIL PREFERENCES
To: Smalyshev, Marostegui
Cc: Stashbot, Marostegui, Banyek, Reedy, gerritbot, Krinkle, Addshore, Yurik, jcrespo, Imarlier, Ladsgroup, Lydia_Pintscher, WMDE-leszek, Aklapper, Gehel, Smalyshev, Nandana, thifranc, AndyTan, Davinaclare77, Qtn1293, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Th3d3v1ls, Hfbn0, QZanden, EBjune, merbst, LawExplorer, Zppix, Jonas, Xmlizer, Wong128hk, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, faidon, Mbch331, Jay8g, fgiunchedi
Cc: Stashbot, Marostegui, Banyek, Reedy, gerritbot, Krinkle, Addshore, Yurik, jcrespo, Imarlier, Ladsgroup, Lydia_Pintscher, WMDE-leszek, Aklapper, Gehel, Smalyshev, Nandana, thifranc, AndyTan, Davinaclare77, Qtn1293, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Th3d3v1ls, Hfbn0, QZanden, EBjune, merbst, LawExplorer, Zppix, Jonas, Xmlizer, Wong128hk, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, faidon, Mbch331, Jay8g, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs