[Labs-l] Tool labs replicas are missing the indexes?

Tue Nov 11 06:02:58 UTC 2014

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
✉ gciampag at indiana.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20141111/e375648f/attachment.html>