Slow Queries / Configuration Help
-
Hi, this this sort of slow “time” graph normal?
I have spent the last few hours looking through these forums to help and possible configurations, but not really finding answers.
My server does not seem to run out of memory or have high CPU usage. I just want to make sure that Redis is working optimally.
Total server memory: 32GB
Redis maxmemory 6GB
maxmemory-policy allkeys-lru-
This topic was modified 4 years, 11 months ago by
mdotk.
-
This topic was modified 4 years, 11 months ago by
-
That’s unusual. It seems that Redis Server is responding rather slowly at times.
Can you post your
Redis-cli INFOoutput?Hey you go @tillkruess. Thanks!
# Server redis_version:6.0.6 redis_git_sha1:00000000 redis_git_dirty:0 redis_build_id:d463d609620685c0 redis_mode:standalone os:Linux 5.8.0-1035-aws x86_64 arch_bits:64 multiplexing_api:epoll atomicvar_api:atomic-builtin gcc_version:9.3.0 process_id:52420 run_id:4e69c8990ded3179aacb826e5e757aaf8b9163f7 tcp_port:6379 uptime_in_seconds:267820 uptime_in_days:3 hz:10 configured_hz:10 lru_clock:13698668 executable:/usr/bin/redis-server config_file:/etc/redis/redis.conf # Clients connected_clients:2 client_recent_max_input_buffer:17100343 client_recent_max_output_buffer:0 blocked_clients:0 tracking_clients:0 clients_in_timeout_table:0 # Memory used_memory:243629152 used_memory_human:232.34M used_memory_rss:340533248 used_memory_rss_human:324.76M used_memory_peak:1771312216 used_memory_peak_human:1.65G used_memory_peak_perc:13.75% used_memory_overhead:22786247 used_memory_startup:803064 used_memory_dataset:220842905 used_memory_dataset_perc:90.95% allocator_allocated:243891504 allocator_active:247783424 allocator_resident:358703104 total_system_memory:33674870784 total_system_memory_human:31.36G used_memory_lua:37888 used_memory_lua_human:37.00K used_memory_scripts:0 used_memory_scripts_human:0B number_of_cached_scripts:0 maxmemory:6734974156 maxmemory_human:6.27G maxmemory_policy:allkeys-lru allocator_frag_ratio:1.02 allocator_frag_bytes:3891920 allocator_rss_ratio:1.45 allocator_rss_bytes:110919680 rss_overhead_ratio:0.95 rss_overhead_bytes:-18169856 mem_fragmentation_ratio:1.40 mem_fragmentation_bytes:96967576 mem_not_counted_for_evict:0 mem_replication_backlog:0 mem_clients_slaves:0 mem_clients_normal:16052431 mem_aof_buffer:0 mem_allocator:jemalloc-5.1.0 active_defrag_running:0 lazyfree_pending_objects:0 # Persistence loading:0 rdb_changes_since_last_save:3232 rdb_bgsave_in_progress:0 rdb_last_save_time:1624311155 rdb_last_bgsave_status:ok rdb_last_bgsave_time_sec:2 rdb_current_bgsave_time_sec:-1 rdb_last_cow_size:15937536 aof_enabled:0 aof_rewrite_in_progress:0 aof_rewrite_scheduled:0 aof_last_rewrite_time_sec:-1 aof_current_rewrite_time_sec:-1 aof_last_bgrewrite_status:ok aof_last_write_status:ok aof_last_cow_size:0 module_fork_in_progress:0 module_fork_last_cow_size:0 # Stats total_connections_received:445077 total_commands_processed:64134667 instantaneous_ops_per_sec:238 total_net_input_bytes:18422233558204 total_net_output_bytes:1680794182227 instantaneous_input_kbps:251735.66 instantaneous_output_kbps:11464.45 rejected_connections:0 sync_full:0 sync_partial_ok:0 sync_partial_err:0 expired_keys:131888 expired_stale_perc:0.00 expired_time_cap_reached_count:0 expire_cycle_cpu_milliseconds:18671 evicted_keys:0 keyspace_hits:66071603 keyspace_misses:1554940 pubsub_channels:0 pubsub_patterns:0 latest_fork_usec:24468 migrate_cached_sockets:0 slave_expires_tracked_keys:0 active_defrag_hits:0 active_defrag_misses:0 active_defrag_key_hits:0 active_defrag_key_misses:0 tracking_total_keys:0 tracking_total_items:0 tracking_total_prefixes:0 unexpected_error_replies:0 # Replication role:master connected_slaves:0 master_replid:4496483e3217514050fb1bfcfe3218449d676cdb master_replid2:0000000000000000000000000000000000000000 master_repl_offset:0 second_repl_offset:-1 repl_backlog_active:0 repl_backlog_size:1048576 repl_backlog_first_byte_offset:0 repl_backlog_histlen:0 # CPU used_cpu_sys:15618.405272 used_cpu_user:5261.280755 used_cpu_sys_children:237.986438 used_cpu_user_children:1742.059629 # Modules # Cluster cluster_enabled:0 # Keyspace db0:keys=101705,expires=22993,avg_ttl=1462360563Mhh, that all looks good. I’d ask your hosting provider for assistance with the slow response times and maybe install a Redis monitor to see what’s going on there.
# Server redis_version:6.0.6 redis_git_sha1:00000000 redis_git_dirty:0 redis_build_id:d463d609620685c0 redis_mode:standalone os:Linux 5.8.0-1035-aws x86_64 arch_bits:64 multiplexing_api:epoll atomicvar_api:atomic-builtin gcc_version:9.3.0 process_id:52420 run_id:4e69c8990ded3179aacb826e5e757aaf8b9163f7 tcp_port:6379 uptime_in_seconds:282872 uptime_in_days:3 hz:10 configured_hz:10 lru_clock:13713719 executable:/usr/bin/redis-server config_file:/etc/redis/redis.conf # Clients connected_clients:4 client_recent_max_input_buffer:17423190 client_recent_max_output_buffer:0 blocked_clients:0 tracking_clients:0 clients_in_timeout_table:0 # Memory used_memory:279634064 used_memory_human:266.68M used_memory_rss:362926080 used_memory_rss_human:346.11M used_memory_peak:1771312216 used_memory_peak_human:1.65G used_memory_peak_perc:15.79% used_memory_overhead:26539426 used_memory_startup:803064 used_memory_dataset:253094638 used_memory_dataset_perc:90.77% allocator_allocated:279768416 allocator_active:285224960 allocator_resident:375988224 total_system_memory:33674870784 total_system_memory_human:31.36G used_memory_lua:37888 used_memory_lua_human:37.00K used_memory_scripts:0 used_memory_scripts_human:0B number_of_cached_scripts:0 maxmemory:6734974156 maxmemory_human:6.27G maxmemory_policy:allkeys-lru allocator_frag_ratio:1.02 allocator_frag_bytes:5456544 allocator_rss_ratio:1.32 allocator_rss_bytes:90763264 rss_overhead_ratio:0.97 rss_overhead_bytes:-13062144 mem_fragmentation_ratio:1.30 mem_fragmentation_bytes:83293856 mem_not_counted_for_evict:0 mem_replication_backlog:0 mem_clients_slaves:0 mem_clients_normal:16409250 mem_aof_buffer:0 mem_allocator:jemalloc-5.1.0 active_defrag_running:0 lazyfree_pending_objects:0 # Persistence loading:0 rdb_changes_since_last_save:2273 rdb_bgsave_in_progress:0 rdb_last_save_time:1624326364 rdb_last_bgsave_status:ok rdb_last_bgsave_time_sec:1 rdb_current_bgsave_time_sec:-1 rdb_last_cow_size:35676160 aof_enabled:0 aof_rewrite_in_progress:0 aof_rewrite_scheduled:0 aof_last_rewrite_time_sec:-1 aof_current_rewrite_time_sec:-1 aof_last_bgrewrite_status:ok aof_last_write_status:ok aof_last_cow_size:0 module_fork_in_progress:0 module_fork_last_cow_size:0 # Stats total_connections_received:463304 total_commands_processed:67876284 instantaneous_ops_per_sec:496 total_net_input_bytes:19742767440192 total_net_output_bytes:1785681852425 instantaneous_input_kbps:206733.25 instantaneous_output_kbps:20530.55 rejected_connections:0 sync_full:0 sync_partial_ok:0 sync_partial_err:0 expired_keys:133259 expired_stale_perc:0.00 expired_time_cap_reached_count:0 expire_cycle_cpu_milliseconds:19688 evicted_keys:0 keyspace_hits:70171957 keyspace_misses:1642387 pubsub_channels:0 pubsub_patterns:0 latest_fork_usec:25346 migrate_cached_sockets:0 slave_expires_tracked_keys:0 active_defrag_hits:0 active_defrag_misses:0 active_defrag_key_hits:0 active_defrag_key_misses:0 tracking_total_keys:0 tracking_total_items:0 tracking_total_prefixes:0 unexpected_error_replies:0 # Replication role:master connected_slaves:0 master_replid:4496483e3217514050fb1bfcfe3218449d676cdb master_replid2:0000000000000000000000000000000000000000 master_repl_offset:0 second_repl_offset:-1 repl_backlog_active:0 repl_backlog_size:1048576 repl_backlog_first_byte_offset:0 repl_backlog_histlen:0 # CPU used_cpu_sys:16666.525120 used_cpu_user:5690.363775 used_cpu_sys_children:248.257346 used_cpu_user_children:1812.128877 # Modules # Cluster cluster_enabled:0 # Keyspace db0:keys=142104,expires=42563,avg_ttl=414481993
The topic ‘Slow Queries / Configuration Help’ is closed to new replies.