Is there a reason why the tables on the Labs replica are not indexed? Drawing a list of random titles with page_random takes more than a minute!
MariaDB [enwiki_p]> select page_id, page_title, page_random from page where page_random > rand() and page_namespace = 0 order by page_random limit 10; +----------+---------------------------------------+----------------+ | page_id | page_title | page_random | +----------+---------------------------------------+----------------+ | 18247710 | Jack_frost_comic | 0.000597330654 | | 2102857 | Prince_Carl_Christian_of_Hohenzollern | 0.000885503126 | | 21550893 | Phoberocyon | 0.000927813129 | | 2836759 | Rinascimento | 0.000943768415 | | 20972414 | Gothic_black_metal | 0.000989090479 | | 1654899 | 1500v_DC | 0.001175443821 | | 43905082 | Juan_García_Costilla | 0.00153940668 | | 1316905 | T_subsurface_stock | 0.001564608112 | | 1447578 | RPGMaker_2000 | 0.00158874586 | | 2034084 | State_Bar_of_California | 0.001697520497 | +----------+---------------------------------------+----------------+ 10 rows in set (1 min 21.14 sec) MariaDB [enwiki_p]> show index from page; Empty set (0.00 sec) MariaDB [enwiki_p]> Giovanni Luca Ciampaglia ✎ 919 E 10th ∙ Bloomington 47408 IN ∙ USA ☞ http://www.glciampaglia.com/ ✆ +1 812 855-7261 ✉ [email protected]
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
