enwiki alone has a bunch of spurious keys set collectively over 10m times – not just the infamous searchNs-1, but also searchNs4294967295, searchNsNS_LQT_SUMMARY and more:
| 1 | mysql:research@analytics-store.eqiad.wmnet [enwiki]> select up_property, up_value, count(*) from user_properties where up_property like 'searchNs%' group by up_property, up_value; |
|---|---|
| 2 | +-----------------------------+----------+----------+ |
| 3 | | up_property | up_value | count(*) | |
| 4 | +-----------------------------+----------+----------+ |
| 5 | | searchNs-0 | 1 | 432 | |
| 6 | | searchNs-1 | 0 | 9632094 | |
| 7 | | searchNs-1 | 1 | 4 | |
| 8 | | searchNs-10 | 1 | 4 | |
| 9 | | searchNs-100 | 1 | 3 | |
| 10 | | searchNs-101 | 1 | 2 | |
| 11 | | searchNs-108 | 1 | 3 | |
| 12 | | searchNs-109 | 1 | 3 | |
| 13 | | searchNs-11 | 1 | 5 | |
| 14 | | searchNs-12 | 1 | 5 | |
| 15 | | searchNs-13 | 1 | 4 | |
| 16 | | searchNs-14 | 1 | 5 | |
| 17 | | searchNs-15 | 1 | 4 | |
| 18 | | searchNs-2 | 1 | 4 | |
| 19 | | searchNs-3 | 1 | 3 | |
| 20 | | searchNs-4 | 1 | 4 | |
| 21 | | searchNs-446 | 1 | 3 | |
| 22 | | searchNs-447 | 1 | 3 | |
| 23 | | searchNs-5 | 1 | 4 | |
| 24 | | searchNs-6 | 1 | 3 | |
| 25 | | searchNs-7 | 1 | 3 | |
| 26 | | searchNs-710 | 1 | 3 | |
| 27 | | searchNs-711 | 1 | 3 | |
| 28 | | searchNs-8 | 1 | 4 | |
| 29 | | searchNs-828 | 1 | 3 | |
| 30 | | searchNs-829 | 1 | 3 | |
| 31 | | searchNs-9 | 1 | 5 | |
| 32 | | searchNs0 | | 12886 | |
| 33 | | searchNs0 | 0 | 4575 | |
| 34 | | searchNs1 | 1 | 40393 | |
| 35 | | searchNs10 | 1 | 33830 | |
| 36 | | searchNs100 | 1 | 35731 | |
| 37 | | searchNs101 | 1 | 26020 | |
| 38 | | searchNs106 | 0 | 1755 | |
| 39 | | searchNs106 | 1 | 25 | |
| 40 | | searchNs107 | 0 | 1767 | |
| 41 | | searchNs107 | 1 | 13 | |
| 42 | | searchNs108 | 1 | 13372 | |
| 43 | | searchNs109 | 1 | 9459 | |
| 44 | | searchNs11 | 1 | 237016 | |
| 45 | | searchNs118 | 1 | 1254 | |
| 46 | | searchNs119 | 1 | 1141 | |
| 47 | | searchNs12 | 1 | 108382 | |
| 48 | | searchNs13 | 1 | 26880 | |
| 49 | | searchNs14 | 1 | 42326 | |
| 50 | | searchNs15 | 1 | 28511 | |
| 51 | | searchNs2 | 1 | 43034 | |
| 52 | | searchNs2300 | 1 | 77 | |
| 53 | | searchNs2301 | 1 | 75 | |
| 54 | | searchNs2302 | 1 | 78 | |
| 55 | | searchNs2303 | 1 | 76 | |
| 56 | | searchNs2600 | 1 | 597 | |
| 57 | | searchNs3 | 1 | 35595 | |
| 58 | | searchNs4 | 1 | 70200 | |
| 59 | | searchNs4294967295 | 0 | 247058 | |
| 60 | | searchNs442 | 1 | 21 | |
| 61 | | searchNs443 | 1 | 17 | |
| 62 | | searchNs444 | 1 | 20 | |
| 63 | | searchNs445 | 1 | 16 | |
| 64 | | searchNs446 | 1 | 3668 | |
| 65 | | searchNs447 | 1 | 3012 | |
| 66 | | searchNs5 | 1 | 37722 | |
| 67 | | searchNs6 | 1 | 49632 | |
| 68 | | searchNs7 | 1 | 30864 | |
| 69 | | searchNs710 | 1 | 2518 | |
| 70 | | searchNs711 | 1 | 2354 | |
| 71 | | searchNs8 | 1 | 40388 | |
| 72 | | searchNs828 | 1 | 2278 | |
| 73 | | searchNs829 | 1 | 2055 | |
| 74 | | searchNs866 | 1 | 8 | |
| 75 | | searchNs867 | 1 | 5 | |
| 76 | | searchNs9 | 1 | 299449 | |
| 77 | | searchNs90 | 1 | 12 | |
| 78 | | searchNs91 | 1 | 11 | |
| 79 | | searchNs92 | 1 | 13 | |
| 80 | | searchNs93 | 1 | 10 | |
| 81 | | searchNsNS_LQT_SUMMARY | 1 | 21 | |
| 82 | | searchNsNS_LQT_SUMMARY_TALK | 1 | 21 | |
| 83 | | searchNsNS_LQT_THREAD | 1 | 21 | |
| 84 | | searchNsNS_LQT_THREAD_TALK | 1 | 21 | |
| 85 | +-----------------------------+----------+----------+ |
| 86 | 80 rows in set (5 min 25.06 sec) |