慢查询日志
1、设置慢查询配置
redis>config set slowlog-log-slower-than 0（单位微妙，默认为10000，10ms）
redis>config set slowlog-max-len 5
2、获取慢查询日志
redis>slowlog get
实例：
127.0.0.1:7001> config get slowlog-log-slower-than
1) "slowlog-log-slower-than"
2) "10000"
127.0.0.1:7001> CONFIG get slowlog-max-len
1) "slowlog-max-len"
2) "128"
127.0.0.1:7001> slowlog get
1) 1) (integer) 64
2) (integer) 1571645922
3) (integer) 735617
4) 1) "info"
2) 1) (integer) 63
2) (integer) 1571328003
3) (integer) 12295
4) 1) "CLUSTER"
2) "SLOTS"
监视器
1、127.0.0.1:7001> monitor
OK
1571645940.484132 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645943.485235 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645946.485290 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645949.486071 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645952.486815 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645955.487559 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645956.224340 [0 127.0.0.1:47386] "PING"
1571645958.488116 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645961.489261 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645964.489657 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645967.490261 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645970.490993 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
1571645973.491732 [0 127.0.0.1:47386] "SMEMBERS" "30_MSG_GRP_All"
查看性能
1、 /usr/local/bin/redis-cli -p 6380 info commandstats
# Commandstats
cmdstat_set:calls=4350591,usec=29221503,usec_per_call=6.72
cmdstat_strlen:calls=2,usec=13,usec_per_call=6.50
cmdstat_lpush:calls=1131624,usec=15818423,usec_per_call=13.98
cmdstat_rpop:calls=566119935,usec=4582656127,usec_per_call=8.09
cmdstat_llen:calls=16,usec=149,usec_per_call=9.31
cmdstat_mset:calls=2549897,usec=417068867,usec_per_call=163.56
cmdstat_randomkey:calls=3,usec=12542,usec_per_call=4180.67
cmdstat_select:calls=268,usec=3141,usec_per_call=11.72
cmdstat_keys:calls=4,usec=3328004,usec_per_call=832001.00
cmdstat_scan:calls=4,usec=1163,usec_per_call=290.75
cmdstat_dbsize:calls=1,usec=10,usec_per_call=10.00
cmdstat_auth:calls=11,usec=131,usec_per_call=11.91
cmdstat_ping:calls=1171948,usec=9749676,usec_per_call=8.32
cmdstat_type:calls=5,usec=40,usec_per_call=8.00
cmdstat_flushdb:calls=20,usec=3971069,usec_per_call=198553.45
cmdstat_flushall:calls=1,usec=3862302,usec_per_call=3862302.00
cmdstat_info:calls=22,usec=466266,usec_per_call=21193.91
cmdstat_monitor:calls=11,usec=118,usec_per_call=10.73
cmdstat_subscribe:calls=1,usec=36,usec_per_call=36.00
cmdstat_publish:calls=2550509,usec=11056275,usec_per_call=4.33
cmdstat_client:calls=1,usec=147895,usec_per_call=147895.00
cmdstat_slowlog:calls=1,usec=10178,usec_per_call=10178.00
cmdstat_command:calls=1,usec=1795,usec_per_call=1795.00
2、/usr/local/bin/redis-cli -p 6380 -a 密码 --stat
------- data ------ --------------------- load -------------------- - child -
keys mem clients blocked requests connections
1558655 255.93M 31 0 577880181 (+0) 408019
1558655 256.03M 31 0 577880317 (+136) 408027
1558655 256.17M 31 0 577880448 (+131) 408034
1558655 256.05M 31 0 577880576 (+128) 408039
1558655 256.07M 31 0 577880705 (+129) 408045
1558655 256.12M 31 0 577880831 (+126) 408048
3、/usr/local/bin/redis-cli -p 6380 -a 密码 --bigkeys
# Scanning the entire keyspace to find biggest keys as well as
# average sizes per key type. You can use -i 0.1 to sleep 0.1 sec
# per 100 SCAN commands (not usually needed).
[00.00%] Biggest string found so far 'Market_16' with 51881 bytes
[00.00%] Biggest list found so far 'EXPIRED_MESSAGE_TOTALCLEAN' with 923 items
[00.00%] Biggest list found so far 'PUSH_RAW_MSG_BUFFER_10' with 38833 items
-------- summary -------
Sampled 5 keys in the keyspace!
Total key length in bytes is 90 (avg len 18.00)
Biggest string found 'Market_16' has 51881 bytes
Biggest list found 'PUSH_RAW_MSG_BUFFER_10' has 38833 items
2 strings with 73009 bytes (40.00% of keys, avg size 36504.50)
3 lists with 39758 items (60.00% of keys, avg size 13252.67)
0 sets with 0 members (00.00% of keys, avg size 0.00)
0 hashs with 0 fields (00.00% of keys, avg size 0.00)
0 zsets with 0 members (00.00% of keys, avg size 0.00)
参考资料
https://www.cnblogs.com/BigJunOba/p/9136099.html 一篇排查redis阻塞问题的思路
网友评论