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) |