Help tracing slow Redis queries
-
I am seeing 300+ms response times from Redis in my WordPress dashboard. After confirming I have ~1ms latency from the client server to the Redis server, I checked the SLOWLOG and found a query for nearly every published post on my instance (it’s about 30-40 posts short of the total list). This is in the SLOWLOG multiple times and takes nearly 30s to run each time.
How can I trace this Redis query to PHP code?
6) 1) (integer) 3972
2) (integer) 1744644610
3) (integer) 27654
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:60328"
6) ""
Viewing 14 replies - 1 through 14 (of 14 total)
-
Can you post the full slowlog output?
Sure, here it is.
127.0.0.1:6379> slowlog get 200
1) 1) (integer) 3992
2) (integer) 1744653865
3) (integer) 14029
4) 1) "MGET"
2) "wp:posts:176953"
3) "wp:posts:176884"
4) "wp:posts:176861"
5) "wp:posts:176894"
6) "wp:posts:176860"
7) "wp:posts:176853"
8) "wp:posts:176826"
9) "wp:posts:176862"
10) "wp:posts:176880"
11) "wp:posts:176845"
12) "wp:posts:176840"
13) "wp:posts:176820"
14) "wp:posts:176813"
15) "wp:posts:176809"
16) "wp:posts:176775"
17) "wp:posts:176783"
18) "wp:posts:176759"
19) "wp:posts:176756"
20) "wp:posts:176771"
21) "wp:posts:176751"
22) "wp:posts:176619"
23) "wp:posts:176716"
24) "wp:posts:176697"
25) "wp:posts:176730"
26) "wp:posts:176704"
27) "wp:posts:176628"
28) "wp:posts:176689"
29) "wp:posts:176670"
30) "wp:posts:176651"
31) "wp:posts:176281"
32) "… (16208 more arguments)"
5) "10.105.131.45:54284"
6) ""
2) 1) (integer) 3991
2) (integer) 1744653682
3) (integer) 97334
4) 1) "FLUSHDB"
5) "10.105.129.186:59438"
6) ""
3) 1) (integer) 3990
2) (integer) 1744653454
3) (integer) 24672
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:53740"
6) ""
4) 1) (integer) 3989
2) (integer) 1744652769
3) (integer) 68895
4) 1) "FLUSHDB"
5) "10.105.129.239:59758"
6) ""
5) 1) (integer) 3988
2) (integer) 1744652206
3) (integer) 19261
4) 1) "SET"
2) "wp:stateless_post_meta:144427"
3) ""
5) "10.105.131.21:55848"
6) ""
6) 1) (integer) 3987
2) (integer) 1744651871
3) (integer) 61840
4) 1) "FLUSHDB"
5) "10.105.129.238:35502"
6) ""
7) 1) (integer) 3986
2) (integer) 1744650968
3) (integer) 116179
4) 1) "FLUSHDB"
5) "10.105.129.236:48810"
6) ""
8) 1) (integer) 3985
2) (integer) 1744650615
3) (integer) 719717
4) 1) "MGET"
2) "wp:posts:176884"
3) "wp:posts:176861"
4) "wp:posts:176894"
5) "wp:posts:176860"
6) "wp:posts:176853"
7) "wp:posts:176826"
8) "wp:posts:176862"
9) "wp:posts:176880"
10) "wp:posts:176845"
11) "wp:posts:176840"
12) "wp:posts:176820"
13) "wp:posts:176813"
14) "wp:posts:176809"
15) "wp:posts:176775"
16) "wp:posts:176783"
17) "wp:posts:176759"
18) "wp:posts:176756"
19) "wp:posts:176771"
20) "wp:posts:176751"
21) "wp:posts:176619"
22) "wp:posts:176716"
23) "wp:posts:176697"
24) "wp:posts:176730"
25) "wp:posts:176704"
26) "wp:posts:176628"
27) "wp:posts:176689"
28) "wp:posts:176670"
29) "wp:posts:176651"
30) "wp:posts:176281"
31) "wp:posts:176624"
32) "… (16207 more arguments)"
5) "10.105.128.143:54718"
6) ""
9) 1) (integer) 3984
2) (integer) 1744650354
3) (integer) 151348
4) 1) "MGET"
2) "wp:posts:176884"
3) "wp:posts:176861"
4) "wp:posts:176894"
5) "wp:posts:176860"
6) "wp:posts:176853"
7) "wp:posts:176826"
8) "wp:posts:176862"
9) "wp:posts:176880"
10) "wp:posts:176845"
11) "wp:posts:176840"
12) "wp:posts:176820"
13) "wp:posts:176813"
14) "wp:posts:176809"
15) "wp:posts:176775"
16) "wp:posts:176783"
17) "wp:posts:176759"
18) "wp:posts:176756"
19) "wp:posts:176771"
20) "wp:posts:176751"
21) "wp:posts:176619"
22) "wp:posts:176716"
23) "wp:posts:176697"
24) "wp:posts:176730"
25) "wp:posts:176704"
26) "wp:posts:176628"
27) "wp:posts:176689"
28) "wp:posts:176670"
29) "wp:posts:176651"
30) "wp:posts:176281"
31) "wp:posts:176624"
32) "… (16207 more arguments)"
5) "10.105.128.143:50014"
6) ""
10) 1) (integer) 3983
2) (integer) 1744650333
3) (integer) 156693
4) 1) "MGET"
2) "wp:posts:176884"
3) "wp:posts:176861"
4) "wp:posts:176894"
5) "wp:posts:176860"
6) "wp:posts:176853"
7) "wp:posts:176826"
8) "wp:posts:176862"
9) "wp:posts:176880"
10) "wp:posts:176845"
11) "wp:posts:176840"
12) "wp:posts:176820"
13) "wp:posts:176813"
14) "wp:posts:176809"
15) "wp:posts:176775"
16) "wp:posts:176783"
17) "wp:posts:176759"
18) "wp:posts:176756"
19) "wp:posts:176771"
20) "wp:posts:176751"
21) "wp:posts:176619"
22) "wp:posts:176716"
23) "wp:posts:176697"
24) "wp:posts:176730"
25) "wp:posts:176704"
26) "wp:posts:176628"
27) "wp:posts:176689"
28) "wp:posts:176670"
29) "wp:posts:176651"
30) "wp:posts:176281"
31) "wp:posts:176624"
32) "… (16207 more arguments)"
5) "10.105.128.143:54486"
6) ""
11) 1) (integer) 3982
2) (integer) 1744650271
3) (integer) 11933
4) 1) "MGET"
2) "wp:posts:176884"
3) "wp:posts:176861"
4) "wp:posts:176894"
5) "wp:posts:176860"
6) "wp:posts:176853"
7) "wp:posts:176826"
8) "wp:posts:176862"
9) "wp:posts:176880"
10) "wp:posts:176845"
11) "wp:posts:176840"
12) "wp:posts:176820"
13) "wp:posts:176813"
14) "wp:posts:176809"
15) "wp:posts:176775"
16) "wp:posts:176783"
17) "wp:posts:176759"
18) "wp:posts:176756"
19) "wp:posts:176771"
20) "wp:posts:176751"
21) "wp:posts:176619"
22) "wp:posts:176716"
23) "wp:posts:176697"
24) "wp:posts:176730"
25) "wp:posts:176704"
26) "wp:posts:176628"
27) "wp:posts:176689"
28) "wp:posts:176670"
29) "wp:posts:176651"
30) "wp:posts:176281"
31) "wp:posts:176624"
32) "… (16207 more arguments)"
5) "10.105.128.143:38642"
6) ""
12) 1) (integer) 3981
2) (integer) 1744650068
3) (integer) 43876
4) 1) "FLUSHDB"
5) "10.105.129.235:59058"
6) ""
13) 1) (integer) 3980
2) (integer) 1744649795
3) (integer) 15124
4) 1) "GET"
2) "wp:options:alloptions"
5) "10.105.131.21:36548"
6) ""
14) 1) (integer) 3979
2) (integer) 1744649167
3) (integer) 98492
4) 1) "FLUSHDB"
5) "10.105.129.232:45918"
6) ""
15) 1) (integer) 3978
2) (integer) 1744648268
3) (integer) 84994
4) 1) "FLUSHDB"
5) "10.105.129.226:36226"
6) ""
16) 1) (integer) 3977
2) (integer) 1744647402
3) (integer) 11822
4) 1) "flushdb"
5) "127.0.0.1:40672"
6) ""
17) 1) (integer) 3976
2) (integer) 1744647366
3) (integer) 36640
4) 1) "FLUSHDB"
5) "10.105.129.221:35596"
6) ""
18) 1) (integer) 3975
2) (integer) 1744646467
3) (integer) 39695
4) 1) "FLUSHDB"
5) "10.105.129.220:56916"
6) ""
19) 1) (integer) 3974
2) (integer) 1744645565
3) (integer) 43217
4) 1) "FLUSHDB"
5) "10.105.129.218:37470"
6) ""
20) 1) (integer) 3973
2) (integer) 1744644665
3) (integer) 93999
4) 1) "FLUSHDB"
5) "10.105.129.217:50726"
6) ""
21) 1) (integer) 3972
2) (integer) 1744644610
3) (integer) 27654
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:60328"
6) ""
22) 1) (integer) 3971
2) (integer) 1744644370
3) (integer) 11280
4) 1) "SET"
2) "wp:stateless_post_meta:149147"
3) ""
5) "10.105.128.74:41352"
6) ""
23) 1) (integer) 3970
2) (integer) 1744643764
3) (integer) 82616
4) 1) "FLUSHDB"
5) "10.105.129.215:57042"
6) ""
24) 1) (integer) 3969
2) (integer) 1744643598
3) (integer) 28171
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:60206"
6) ""
25) 1) (integer) 3968
2) (integer) 1744642864
3) (integer) 39748
4) 1) "FLUSHDB"
5) "10.105.129.214:38250"
6) ""
26) 1) (integer) 3967
2) (integer) 1744641964
3) (integer) 54049
4) 1) "FLUSHDB"
5) "10.105.129.211:34054"
6) ""
27) 1) (integer) 3966
2) (integer) 1744641065
3) (integer) 102452
4) 1) "FLUSHDB"
5) "10.105.129.210:54208"
6) ""
28) 1) (integer) 3965
2) (integer) 1744640164
3) (integer) 45634
4) 1) "FLUSHDB"
5) "10.105.129.208:42586"
6) ""
29) 1) (integer) 3964
2) (integer) 1744639263
3) (integer) 47981
4) 1) "FLUSHDB"
5) "10.105.129.207:39686"
6) ""
30) 1) (integer) 3963
2) (integer) 1744638363
3) (integer) 38300
4) 1) "FLUSHDB"
5) "10.105.129.205:38872"
6) ""
31) 1) (integer) 3962
2) (integer) 1744637464
3) (integer) 39887
4) 1) "FLUSHDB"
5) "10.105.129.204:47760"
6) ""
32) 1) (integer) 3961
2) (integer) 1744636566
3) (integer) 46707
4) 1) "FLUSHDB"
5) "10.105.129.202:50952"
6) ""
33) 1) (integer) 3960
2) (integer) 1744635665
3) (integer) 34133
4) 1) "FLUSHDB"
5) "10.105.129.200:44838"
6) ""
34) 1) (integer) 3959
2) (integer) 1744634764
3) (integer) 68868
4) 1) "FLUSHDB"
5) "10.105.129.254:52696"
6) ""
35) 1) (integer) 3958
2) (integer) 1744634625
3) (integer) 726266
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:33258"
6) ""
36) 1) (integer) 3957
2) (integer) 1744634349
3) (integer) 14937
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:38694"
6) ""
37) 1) (integer) 3956
2) (integer) 1744633865
3) (integer) 27615
4) 1) "FLUSHDB"
5) "10.105.129.253:44100"
6) ""
38) 1) (integer) 3955
2) (integer) 1744632962
3) (integer) 28867
4) 1) "FLUSHDB"
5) "10.105.129.251:51194"
6) ""
39) 1) (integer) 3954
2) (integer) 1744632065
3) (integer) 29257
4) 1) "FLUSHDB"
5) "10.105.129.250:34642"
6) ""
40) 1) (integer) 3953
2) (integer) 1744631165
3) (integer) 36750
4) 1) "FLUSHDB"
5) "10.105.129.248:52358"
6) ""
41) 1) (integer) 3952
2) (integer) 1744630265
3) (integer) 40366
4) 1) "FLUSHDB"
5) "10.105.129.247:53520"
6) ""
42) 1) (integer) 3951
2) (integer) 1744629362
3) (integer) 30521
4) 1) "FLUSHDB"
5) "10.105.129.245:53412"
6) ""
43) 1) (integer) 3950
2) (integer) 1744628467
3) (integer) 26027
4) 1) "FLUSHDB"
5) "10.105.129.244:50626"
6) ""
44) 1) (integer) 3949
2) (integer) 1744627566
3) (integer) 43927
4) 1) "FLUSHDB"
5) "10.105.129.242:40132"
6) ""
45) 1) (integer) 3948
2) (integer) 1744626662
3) (integer) 31719
4) 1) "FLUSHDB"
5) "10.105.129.241:49820"
6) ""
46) 1) (integer) 3947
2) (integer) 1744625764
3) (integer) 26838
4) 1) "FLUSHDB"
5) "10.105.129.239:46990"
6) ""
47) 1) (integer) 3946
2) (integer) 1744624866
3) (integer) 26863
4) 1) "FLUSHDB"
5) "10.105.129.238:55290"
6) ""
48) 1) (integer) 3945
2) (integer) 1744623964
3) (integer) 34597
4) 1) "FLUSHDB"
5) "10.105.129.236:41244"
6) ""
49) 1) (integer) 3944
2) (integer) 1744623063
3) (integer) 34826
4) 1) "FLUSHDB"
5) "10.105.129.235:60400"
6) ""
50) 1) (integer) 3943
2) (integer) 1744622163
3) (integer) 36833
4) 1) "FLUSHDB"
5) "10.105.129.233:44300"
6) ""
51) 1) (integer) 3942
2) (integer) 1744621264
3) (integer) 38492
4) 1) "FLUSHDB"
5) "10.105.129.215:35420"
6) ""
52) 1) (integer) 3941
2) (integer) 1744620362
3) (integer) 32829
4) 1) "FLUSHDB"
5) "10.105.129.253:54618"
6) ""
53) 1) (integer) 3940
2) (integer) 1744619461
3) (integer) 38019
4) 1) "FLUSHDB"
5) "10.105.129.237:35560"
6) ""
54) 1) (integer) 3939
2) (integer) 1744618562
3) (integer) 54254
4) 1) "FLUSHDB"
5) "10.105.129.220:44972"
6) ""
55) 1) (integer) 3938
2) (integer) 1744617662
3) (integer) 40823
4) 1) "FLUSHDB"
5) "10.105.129.204:60768"
6) ""
56) 1) (integer) 3937
2) (integer) 1744616759
3) (integer) 33024
4) 1) "FLUSHDB"
5) "10.105.129.243:50266"
6) ""
57) 1) (integer) 3936
2) (integer) 1744615862
3) (integer) 35502
4) 1) "FLUSHDB"
5) "10.105.129.226:36758"
6) ""
58) 1) (integer) 3935
2) (integer) 1744614961
3) (integer) 40227
4) 1) "FLUSHDB"
5) "10.105.129.210:38222"
6) ""
59) 1) (integer) 3934
2) (integer) 1744614061
3) (integer) 43223
4) 1) "FLUSHDB"
5) "10.105.129.249:39470"
6) ""
60) 1) (integer) 3933
2) (integer) 1744613162
3) (integer) 45274
4) 1) "FLUSHDB"
5) "10.105.129.233:51186"
6) ""
61) 1) (integer) 3932
2) (integer) 1744612261
3) (integer) 49908
4) 1) "FLUSHDB"
5) "10.105.129.216:52314"
6) ""
62) 1) (integer) 3931
2) (integer) 1744611361
3) (integer) 52990
4) 1) "FLUSHDB"
5) "10.105.129.196:33422"
6) ""
63) 1) (integer) 3930
2) (integer) 1744610462
3) (integer) 41304
4) 1) "FLUSHDB"
5) "10.105.129.239:45588"
6) ""
64) 1) (integer) 3929
2) (integer) 1744609562
3) (integer) 46722
4) 1) "FLUSHDB"
5) "10.105.129.222:42452"
6) ""
65) 1) (integer) 3928
2) (integer) 1744608662
3) (integer) 43464
4) 1) "FLUSHDB"
5) "10.105.129.206:45184"
6) ""
66) 1) (integer) 3927
2) (integer) 1744607761
3) (integer) 49242
4) 1) "FLUSHDB"
5) "10.105.129.245:44348"
6) ""
67) 1) (integer) 3926
2) (integer) 1744606861
3) (integer) 51670
4) 1) "FLUSHDB"
5) "10.105.129.228:45800"
6) ""
68) 1) (integer) 3925
2) (integer) 1744606135
3) (integer) 16305
4) 1) "GET"
2) "wp:stateless_post_meta:176653"
5) "10.105.130.22:41904"
6) ""
69) 1) (integer) 3924
2) (integer) 1744605962
3) (integer) 46173
4) 1) "FLUSHDB"
5) "10.105.129.212:48166"
6) ""
70) 1) (integer) 3923
2) (integer) 1744605063
3) (integer) 44452
4) 1) "FLUSHDB"
5) "10.105.129.251:52620"
6) ""
71) 1) (integer) 3922
2) (integer) 1744604163
3) (integer) 44886
4) 1) "FLUSHDB"
5) "10.105.129.235:53206"
6) ""
72) 1) (integer) 3921
2) (integer) 1744603263
3) (integer) 40007
4) 1) "FLUSHDB"
5) "10.105.129.218:50572"
6) ""
73) 1) (integer) 3920
2) (integer) 1744602363
3) (integer) 42903
4) 1) "FLUSHDB"
5) "10.105.129.202:44224"
6) ""
74) 1) (integer) 3919
2) (integer) 1744601460
3) (integer) 42771
4) 1) "FLUSHDB"
5) "10.105.129.241:53844"
6) ""
75) 1) (integer) 3918
2) (integer) 1744600561
3) (integer) 49663
4) 1) "FLUSHDB"
5) "10.105.129.224:35360"
6) ""
76) 1) (integer) 3917
2) (integer) 1744600416
3) (integer) 23096
4) 1) "GET"
2) "wp:options:alloptions"
5) "10.105.130.22:58270"
6) ""
77) 1) (integer) 3916
2) (integer) 1744599664
3) (integer) 47736
4) 1) "FLUSHDB"
5) "10.105.129.208:56022"
6) ""
78) 1) (integer) 3915
2) (integer) 1744598762
3) (integer) 50101
4) 1) "FLUSHDB"
5) "10.105.129.247:54532"
6) ""
79) 1) (integer) 3914
2) (integer) 1744597861
3) (integer) 50854
4) 1) "FLUSHDB"
5) "10.105.129.230:53148"
6) ""
80) 1) (integer) 3913
2) (integer) 1744596961
3) (integer) 69479
4) 1) "FLUSHDB"
5) "10.105.129.214:54682"
6) ""
81) 1) (integer) 3912
2) (integer) 1744596062
3) (integer) 33675
4) 1) "FLUSHDB"
5) "10.105.129.253:57100"
6) ""
82) 1) (integer) 3911
2) (integer) 1744595163
3) (integer) 36664
4) 1) "FLUSHDB"
5) "10.105.129.237:41496"
6) ""
83) 1) (integer) 3910
2) (integer) 1744594263
3) (integer) 40507
4) 1) "FLUSHDB"
5) "10.105.129.220:36796"
6) ""
84) 1) (integer) 3909
2) (integer) 1744593361
3) (integer) 40154
4) 1) "FLUSHDB"
5) "10.105.129.204:56044"
6) ""
85) 1) (integer) 3908
2) (integer) 1744592474
3) (integer) 38777
4) 1) "FLUSHDB"
5) "10.105.129.243:39988"
6) ""
86) 1) (integer) 3907
2) (integer) 1744591561
3) (integer) 36263
4) 1) "FLUSHDB"
5) "10.105.129.226:50706"
6) ""
87) 1) (integer) 3906
2) (integer) 1744590662
3) (integer) 41221
4) 1) "FLUSHDB"
5) "10.105.129.210:51198"
6) ""
88) 1) (integer) 3905
2) (integer) 1744589763
3) (integer) 36010
4) 1) "FLUSHDB"
5) "10.105.129.249:38776"
6) ""
89) 1) (integer) 3904
2) (integer) 1744588862
3) (integer) 47846
4) 1) "FLUSHDB"
5) "10.105.129.233:39430"
6) ""
90) 1) (integer) 3903
2) (integer) 1744587975
3) (integer) 40108
4) 1) "FLUSHDB"
5) "10.105.129.216:59106"
6) ""
91) 1) (integer) 3902
2) (integer) 1744587062
3) (integer) 45950
4) 1) "FLUSHDB"
5) "10.105.129.196:32994"
6) ""
92) 1) (integer) 3901
2) (integer) 1744586158
3) (integer) 38316
4) 1) "FLUSHDB"
5) "10.105.129.239:39064"
6) ""
93) 1) (integer) 3900
2) (integer) 1744585262
3) (integer) 45558
4) 1) "FLUSHDB"
5) "10.105.129.222:53616"
6) ""
94) 1) (integer) 3899
2) (integer) 1744584363
3) (integer) 47312
4) 1) "FLUSHDB"
5) "10.105.129.206:55766"
6) ""
95) 1) (integer) 3898
2) (integer) 1744583465
3) (integer) 47379
4) 1) "FLUSHDB"
5) "10.105.129.245:40796"
6) ""
96) 1) (integer) 3897
2) (integer) 1744582565
3) (integer) 42458
4) 1) "FLUSHDB"
5) "10.105.129.228:43014"
6) ""
97) 1) (integer) 3896
2) (integer) 1744581674
3) (integer) 33014
4) 1) "FLUSHDB"
5) "10.105.129.212:39002"
6) ""
98) 1) (integer) 3895
2) (integer) 1744580763
3) (integer) 38837
4) 1) "FLUSHDB"
5) "10.105.129.251:45292"
6) ""
99) 1) (integer) 3894
2) (integer) 1744579864
3) (integer) 34765
4) 1) "FLUSHDB"
5) "10.105.129.235:33966"
6) ""
100) 1) (integer) 3893
2) (integer) 1744578962
3) (integer) 39862
4) 1) "FLUSHDB"
5) "10.105.129.218:55512"
6) ""
101) 1) (integer) 3892
2) (integer) 1744578061
3) (integer) 34589
4) 1) "FLUSHDB"
5) "10.105.129.202:43320"
6) ""
102) 1) (integer) 3891
2) (integer) 1744577163
3) (integer) 33384
4) 1) "FLUSHDB"
5) "10.105.129.241:60840"
6) ""
103) 1) (integer) 3890
2) (integer) 1744576264
3) (integer) 37271
4) 1) "FLUSHDB"
5) "10.105.129.224:48150"
6) ""
104) 1) (integer) 3889
2) (integer) 1744575362
3) (integer) 41052
4) 1) "FLUSHDB"
5) "10.105.129.208:41262"
6) ""
105) 1) (integer) 3888
2) (integer) 1744574830
3) (integer) 16690
4) 1) "MGET"
2) "wp:posts:176660"
3) "wp:posts:177312"
4) "wp:posts:177464"
5) "wp:posts:177289"
6) "wp:posts:177298"
7) "wp:posts:177282"
8) "wp:posts:177247"
9) "wp:posts:177236"
10) "wp:posts:177222"
11) "wp:posts:177244"
12) "wp:posts:177208"
13) "wp:posts:177173"
14) "wp:posts:177044"
15) "wp:posts:177147"
16) "wp:posts:176967"
17) "wp:posts:177051"
18) "wp:posts:177008"
19) "wp:posts:176974"
20) "wp:posts:176957"
21) "wp:posts:176978"
5) "10.105.131.21:38644"
6) ""
106) 1) (integer) 3887
2) (integer) 1744574459
3) (integer) 33481
4) 1) "FLUSHDB"
5) "10.105.129.247:42424"
6) ""
107) 1) (integer) 3886
2) (integer) 1744573563
3) (integer) 37466
4) 1) "FLUSHDB"
5) "10.105.129.230:42352"
6) ""
108) 1) (integer) 3885
2) (integer) 1744572663
3) (integer) 34561
4) 1) "FLUSHDB"
5) "10.105.129.214:41680"
6) ""
109) 1) (integer) 3884
2) (integer) 1744571764
3) (integer) 46443
4) 1) "FLUSHDB"
5) "10.105.129.253:36134"
6) ""
110) 1) (integer) 3883
2) (integer) 1744570861
3) (integer) 43446
4) 1) "FLUSHDB"
5) "10.105.129.237:53602"
6) ""
111) 1) (integer) 3882
2) (integer) 1744569962
3) (integer) 87876
4) 1) "FLUSHDB"
5) "10.105.129.220:55220"
6) ""
112) 1) (integer) 3881
2) (integer) 1744569206
3) (integer) 158598
4) 1) "MGET"
2) "wp:posts:176884"
3) "wp:posts:176861"
4) "wp:posts:176894"
5) "wp:posts:176860"
6) "wp:posts:176853"
7) "wp:posts:176826"
8) "wp:posts:176862"
9) "wp:posts:176880"
10) "wp:posts:176845"
11) "wp:posts:176840"
12) "wp:posts:176820"
13) "wp:posts:176813"
14) "wp:posts:176809"
15) "wp:posts:176775"
16) "wp:posts:176783"
17) "wp:posts:176759"
18) "wp:posts:176756"
19) "wp:posts:176771"
20) "wp:posts:176751"
21) "wp:posts:176619"
22) "wp:posts:176716"
23) "wp:posts:176697"
24) "wp:posts:176730"
25) "wp:posts:176704"
26) "wp:posts:176628"
27) "wp:posts:176689"
28) "wp:posts:176670"
29) "wp:posts:176651"
30) "wp:posts:176281"
31) "wp:posts:176624"
32) "… (16207 more arguments)"
5) "10.105.128.143:36972"
6) ""
113) 1) (integer) 3880
2) (integer) 1744569062
3) (integer) 48332
4) 1) "FLUSHDB"
5) "10.105.129.204:38352"
6) ""
114) 1) (integer) 3879
2) (integer) 1744568163
3) (integer) 38855
4) 1) "FLUSHDB"
5) "10.105.129.243:47252"
6) ""
115) 1) (integer) 3878
2) (integer) 1744567262
3) (integer) 45580
4) 1) "FLUSHDB"
5) "10.105.129.226:54364"
6) ""
116) 1) (integer) 3877
2) (integer) 1744566362
3) (integer) 43801
4) 1) "FLUSHDB"
5) "10.105.129.210:34542"
6) ""
117) 1) (integer) 3876
2) (integer) 1744565462
3) (integer) 46693
4) 1) "FLUSHDB"
5) "10.105.129.249:55928"
6) ""
118) 1) (integer) 3875
2) (integer) 1744564564
3) (integer) 38423
4) 1) "FLUSHDB"
5) "10.105.129.233:50038"
6) ""
119) 1) (integer) 3874
2) (integer) 1744563662
3) (integer) 50911
4) 1) "FLUSHDB"
5) "10.105.129.216:45410"
6) ""
120) 1) (integer) 3873
2) (integer) 1744562762
3) (integer) 53921
4) 1) "FLUSHDB"
5) "10.105.129.196:51602"
6) ""
121) 1) (integer) 3872
2) (integer) 1744561863
3) (integer) 127023
4) 1) "FLUSHDB"
5) "10.105.129.239:57994"
6) ""
122) 1) (integer) 3871
2) (integer) 1744561616
3) (integer) 551676
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:49702"
6) ""
123) 1) (integer) 3870
2) (integer) 1744561487
3) (integer) 29200
4) 1) "MGET"
2) "wp:posts:177208"
3) "wp:posts:177173"
4) "wp:posts:177203"
5) "wp:posts:177153"
6) "wp:posts:177147"
7) "wp:posts:177044"
8) "wp:posts:177094"
9) "wp:posts:176967"
10) "wp:posts:177077"
11) "wp:posts:177059"
12) "wp:posts:177051"
13) "wp:posts:177008"
14) "wp:posts:176974"
15) "wp:posts:177004"
16) "wp:posts:176978"
17) "wp:posts:176966"
18) "wp:posts:176957"
19) "wp:posts:176961"
20) "wp:posts:176953"
21) "wp:posts:176884"
22) "wp:posts:176861"
23) "wp:posts:176894"
24) "wp:posts:176860"
25) "wp:posts:176853"
26) "wp:posts:176826"
27) "wp:posts:176862"
28) "wp:posts:176880"
29) "wp:posts:176845"
30) "wp:posts:176840"
31) "wp:posts:176820"
32) "… (16226 more arguments)"
5) "10.105.128.143:38898"
6) ""
124) 1) (integer) 3869
2) (integer) 1744560961
3) (integer) 54411
4) 1) "FLUSHDB"
5) "10.105.129.222:33570"
6) ""
125) 1) (integer) 3868
2) (integer) 1744560062
3) (integer) 51135
4) 1) "FLUSHDB"
5) "10.105.129.206:40314"
6) ""
126) 1) (integer) 3867
2) (integer) 1744559163
3) (integer) 66683
4) 1) "FLUSHDB"
5) "10.105.129.245:37164"
6) ""
127) 1) (integer) 3866
2) (integer) 1744558264
3) (integer) 58520
4) 1) "FLUSHDB"
5) "10.105.129.228:37788"
6) ""
128) 1) (integer) 3865
2) (integer) 1744557362
3) (integer) 123092
4) 1) "FLUSHDB"
5) "10.105.129.212:33586"
6) ""
127.0.0.1:6379>I found this possible culprit in the Query Monitor while browsing WP Admin panel. According to Query Monitor this is not coming from a plugin. I have my screen set to show just 40 articles so I don’t understand why it is fetching 14,000 articles.
Edit: the first image broke, so here is an imgur hosted image.
-
This reply was modified 3 weeks, 6 days ago by
ckeeney.
Mhhh, MGET shoudn’t be this slow. Are you using a standalone Redis instance, or a cluster/sentinel/replication?
I am running the Redis Operator on GKE Autopilot to create a sentinel setup. Here is that manifest.
apiVersion: databases.spotahome.com/v1
kind: RedisFailover
metadata:
name: redisfailover
namespace: production
spec:
redis:
customConfig:
- maxmemory 2gb
- maxmemory-policy allkeys-lru
replicas: 0
resources:
limits:
cpu: 1000m
memory: 2.5Gi
requests:
cpu: 1000m
memory: 2.5Gi
sentinel:
replicas: 0
resources:
limits:
cpu: 500m
memory: 250Mi
requests:
cpu: 500m
memory: 250MiHere are screenshots from GKE showing minimal resource usage on both the sentinel and the stateful set pods.
Edit: I just noticed the 0 replicas in the manifest. I will fix this, but I definitely have pods running because I am connecting to them just fine.
-
This reply was modified 3 weeks, 6 days ago by
I guess that’s something to do with your Redis configuration then. MGET is typically a very fast command and even returning 100 entries should be fast.
I haven’t customized any Redis configuration. I shared my Kubernetes manifest above that adds two command line args to set the max memory and specify an eviction policy. Other than that I am just setting resource requests for the Kubernetes scheduler.
MGET is returning 16000+ posts which is an order of magnitude more than 100. Is it normal to have a query for this many posts?
I was under the impression that my Redis configuration may be fine but that the issue is that something is querying 16000 posts at once and Redis just won’t handle that. You believe the 16000 post query is normal and I should instead be looking into a Redis configuration issue?
It’s not, no plugin (or core) should request 16,000 cache keys. This must be chunked.
Is the “prime post cache” the only caller that does it?
WP_query->get_posts()also does, and both of these callers haveWP_Posts_List_Tablein their stack trace.There are probably other callers as well. I just stumbled across these while browsing the admin panel with the query monitor open.
This would be something to report to wp core and open a trac ticket. I’ve not seen this before.
If you open it and link it, I’ll push it for a quick resolution.
Thanks, I will do so and link it here, but first I want to investigate this locally to see if I can see if the issue goes away with some plugins gone.
My latest tests show this same bug is reproducible using the SQLite Object Cache plugin, so this issue needs to be fixed in core.
Feel free to close this issue at your discretion, future updates to this issue will likely be tracked on the related WordPress trac ticket.
Great work. Peter and Joe are gonna get this merged fast.
-
This reply was modified 3 weeks, 6 days ago by
Viewing 14 replies - 1 through 14 (of 14 total)
- You must be logged in to reply to this topic.
