Created
May 7, 2015 21:23
-
-
Save jsam/4ae378163d08a2c9a8b0 to your computer and use it in GitHub Desktop.
redis query queue get's filled up cause of georadius
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
127.0.0.1:6379> slowlog get 50 | |
1) 1) (integer) 817005 | |
2) (integer) 1431033515 | |
3) (integer) 15635 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3345467" | |
4) "-7.8616236" | |
5) "10" | |
6) "km" | |
7) "asc" | |
2) 1) (integer) 817004 | |
2) (integer) 1431033515 | |
3) (integer) 18208 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.34142837797943" | |
4) "-7.860862587620576" | |
5) "10" | |
6) "km" | |
7) "asc" | |
3) 1) (integer) 817003 | |
2) (integer) 1431033515 | |
3) (integer) 16905 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.55170165473559" | |
4) "-5.916372471109447" | |
5) "10" | |
6) "km" | |
7) "asc" | |
4) 1) (integer) 817002 | |
2) (integer) 1431033515 | |
3) (integer) 16530 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.56127471756314" | |
4) "-5.938027457045056" | |
5) "10" | |
6) "km" | |
7) "asc" | |
5) 1) (integer) 817001 | |
2) (integer) 1431033515 | |
3) (integer) 16446 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3400561" | |
4) "-7.8136284" | |
5) "10" | |
6) "km" | |
7) "asc" | |
6) 1) (integer) 817000 | |
2) (integer) 1431033515 | |
3) (integer) 17865 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3368619" | |
4) "-7.8573009" | |
5) "10" | |
6) "km" | |
7) "asc" | |
7) 1) (integer) 816999 | |
2) (integer) 1431033515 | |
3) (integer) 27135 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.37334230535684" | |
4) "-8.335065239744889" | |
5) "10" | |
6) "km" | |
7) "asc" | |
8) 1) (integer) 816998 | |
2) (integer) 1431033515 | |
3) (integer) 16706 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3195987" | |
4) "-7.8812037" | |
5) "10" | |
6) "km" | |
7) "asc" | |
9) 1) (integer) 816997 | |
2) (integer) 1431033515 | |
3) (integer) 15742 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.356412" | |
4) "-7.8727028" | |
5) "10" | |
6) "km" | |
7) "asc" | |
10) 1) (integer) 816996 | |
2) (integer) 1431033515 | |
3) (integer) 16207 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.2923992" | |
4) "-7.9005719" | |
5) "10" | |
6) "km" | |
7) "asc" | |
11) 1) (integer) 816995 | |
2) (integer) 1431033515 | |
3) (integer) 10327 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.6129227" | |
4) "-5.7967232" | |
5) "10" | |
6) "km" | |
7) "asc" | |
12) 1) (integer) 816994 | |
2) (integer) 1431033515 | |
3) (integer) 10132 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.6129227" | |
4) "-5.7967232" | |
5) "10" | |
6) "km" | |
7) "asc" | |
13) 1) (integer) 816993 | |
2) (integer) 1431033515 | |
3) (integer) 12122 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.6129227" | |
4) "-5.7967232" | |
5) "10" | |
6) "km" | |
7) "asc" | |
14) 1) (integer) 816992 | |
2) (integer) 1431033515 | |
3) (integer) 16233 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3574439" | |
4) "-7.8645839" | |
5) "10" | |
6) "km" | |
7) "asc" | |
15) 1) (integer) 816991 | |
2) (integer) 1431033515 | |
3) (integer) 18338 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.31950253899912" | |
4) "-7.878900296197942" | |
5) "10" | |
6) "km" | |
7) "asc" | |
16) 1) (integer) 816990 | |
2) (integer) 1431033515 | |
3) (integer) 11568 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.6129227" | |
4) "-5.7967232" | |
5) "10" | |
6) "km" | |
7) "asc" | |
17) 1) (integer) 816989 | |
2) (integer) 1431033515 | |
3) (integer) 15298 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5364548" | |
4) "-5.9021096" | |
5) "10" | |
6) "km" | |
7) "asc" | |
18) 1) (integer) 816988 | |
2) (integer) 1431033515 | |
3) (integer) 18490 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.53557782126098" | |
4) "-5.903701527523507" | |
5) "10" | |
6) "km" | |
7) "asc" | |
19) 1) (integer) 816987 | |
2) (integer) 1431033515 | |
3) (integer) 25233 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5021311" | |
4) "-8.2005696" | |
5) "10" | |
6) "km" | |
7) "asc" | |
20) 1) (integer) 816986 | |
2) (integer) 1431033515 | |
3) (integer) 18201 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3559948" | |
4) "-7.9044236" | |
5) "10" | |
6) "km" | |
7) "asc" | |
21) 1) (integer) 816985 | |
2) (integer) 1431033515 | |
3) (integer) 14414 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5747492" | |
4) "-5.9638828" | |
5) "10" | |
6) "km" | |
7) "asc" | |
22) 1) (integer) 816984 | |
2) (integer) 1431033515 | |
3) (integer) 15668 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5833194" | |
4) "-5.9447538" | |
5) "10" | |
6) "km" | |
7) "asc" | |
23) 1) (integer) 816983 | |
2) (integer) 1431033515 | |
3) (integer) 12689 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.3688932" | |
4) "-5.844011" | |
5) "10" | |
6) "km" | |
7) "asc" | |
24) 1) (integer) 816982 | |
2) (integer) 1431033515 | |
3) (integer) 14221 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.54721939120216" | |
4) "-5.926428687063144" | |
5) "10" | |
6) "km" | |
7) "asc" | |
25) 1) (integer) 816981 | |
2) (integer) 1431033514 | |
3) (integer) 16116 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5738617" | |
4) "-5.9334442" | |
5) "10" | |
6) "km" | |
7) "asc" | |
26) 1) (integer) 816980 | |
2) (integer) 1431033514 | |
3) (integer) 18072 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.34030415174981" | |
4) "-7.862813578850735" | |
5) "10" | |
6) "km" | |
7) "asc" | |
27) 1) (integer) 816979 | |
2) (integer) 1431033514 | |
3) (integer) 24948 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.51322847715095" | |
4) "-8.15348103920891" | |
5) "10" | |
6) "km" | |
7) "asc" | |
28) 1) (integer) 816978 | |
2) (integer) 1431033514 | |
3) (integer) 15079 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5560234" | |
4) "-5.9308754" | |
5) "10" | |
6) "km" | |
7) "asc" | |
29) 1) (integer) 816977 | |
2) (integer) 1431033514 | |
3) (integer) 18119 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3468734" | |
4) "-7.8049023" | |
5) "10" | |
6) "km" | |
7) "asc" | |
30) 1) (integer) 816976 | |
2) (integer) 1431033514 | |
3) (integer) 15582 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5398015" | |
4) "-5.9058599" | |
5) "10" | |
6) "km" | |
7) "asc" | |
31) 1) (integer) 816975 | |
2) (integer) 1431033514 | |
3) (integer) 17206 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.53422895051169" | |
4) "-5.911222615234115" | |
5) "10" | |
6) "km" | |
7) "asc" | |
32) 1) (integer) 816974 | |
2) (integer) 1431033514 | |
3) (integer) 17864 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5491095" | |
4) "-5.9161115" | |
5) "10" | |
6) "km" | |
7) "asc" | |
33) 1) (integer) 816973 | |
2) (integer) 1431033514 | |
3) (integer) 16642 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3152914" | |
4) "-7.8827439" | |
5) "10" | |
6) "km" | |
7) "asc" | |
34) 1) (integer) 816972 | |
2) (integer) 1431033514 | |
3) (integer) 16475 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5536647" | |
4) "-5.9283346" | |
5) "10" | |
6) "km" | |
7) "asc" | |
35) 1) (integer) 816971 | |
2) (integer) 1431033514 | |
3) (integer) 15682 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3195987" | |
4) "-7.8812037" | |
5) "10" | |
6) "km" | |
7) "asc" | |
36) 1) (integer) 816970 | |
2) (integer) 1431033514 | |
3) (integer) 18250 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3444016" | |
4) "-7.872503" | |
5) "10" | |
6) "km" | |
7) "asc" | |
37) 1) (integer) 816969 | |
2) (integer) 1431033514 | |
3) (integer) 25091 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.4820613" | |
4) "-8.2266316" | |
5) "10" | |
6) "km" | |
7) "asc" | |
38) 1) (integer) 816968 | |
2) (integer) 1431033514 | |
3) (integer) 17843 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.53299150208812" | |
4) "-5.915343838550856" | |
5) "10" | |
6) "km" | |
7) "asc" | |
39) 1) (integer) 816967 | |
2) (integer) 1431033514 | |
3) (integer) 18024 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3546278" | |
4) "-7.8638541" | |
5) "10" | |
6) "km" | |
7) "asc" | |
40) 1) (integer) 816966 | |
2) (integer) 1431033514 | |
3) (integer) 17918 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3536907" | |
4) "-7.8640588" | |
5) "10" | |
6) "km" | |
7) "asc" | |
41) 1) (integer) 816965 | |
2) (integer) 1431033514 | |
3) (integer) 17554 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5398184" | |
4) "-5.9049194" | |
5) "10" | |
6) "km" | |
7) "asc" | |
42) 1) (integer) 816964 | |
2) (integer) 1431033514 | |
3) (integer) 16331 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5384675" | |
4) "-5.9031298" | |
5) "10" | |
6) "km" | |
7) "asc" | |
43) 1) (integer) 816963 | |
2) (integer) 1431033514 | |
3) (integer) 17798 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3398974" | |
4) "-7.862322" | |
5) "10" | |
6) "km" | |
7) "asc" | |
44) 1) (integer) 816962 | |
2) (integer) 1431033514 | |
3) (integer) 12999 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.6162881" | |
4) "-5.7904195" | |
5) "10" | |
6) "km" | |
7) "asc" | |
45) 1) (integer) 816961 | |
2) (integer) 1431033513 | |
3) (integer) 23097 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5081957" | |
4) "-8.1913837" | |
5) "10" | |
6) "km" | |
7) "asc" | |
46) 1) (integer) 816960 | |
2) (integer) 1431033513 | |
3) (integer) 18179 | |
4) 1) "georadius" | |
2) "posts" | |
3) "42.3428812" | |
4) "-7.8674119" | |
5) "10" | |
6) "km" | |
7) "asc" | |
47) 1) (integer) 816959 | |
2) (integer) 1431033513 | |
3) (integer) 23278 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.4947391410663" | |
4) "-8.207825090916996" | |
5) "10" | |
6) "km" | |
7) "asc" | |
48) 1) (integer) 816958 | |
2) (integer) 1431033513 | |
3) (integer) 25109 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.49509904460493" | |
4) "-8.215605610916848" | |
5) "10" | |
6) "km" | |
7) "asc" | |
49) 1) (integer) 816957 | |
2) (integer) 1431033513 | |
3) (integer) 15741 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.5533388" | |
4) "-5.9175999" | |
5) "10" | |
6) "km" | |
7) "asc" | |
50) 1) (integer) 816956 | |
2) (integer) 1431033513 | |
3) (integer) 15937 | |
4) 1) "georadius" | |
2) "posts" | |
3) "43.55924315444241" | |
4) "-5.919950748042137" | |
5) "10" | |
6) "km" | |
7) "asc" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment