监控redis报错,lepus_redis_mon.log日志中提示
Error 1265: Data truncated for column 'used_cpu_user' at row 1
通过MySQL的general_log获取到插入语句,used_cpu_user列为double(10,2),但插入值是"0.75M"
insert into dashboard_redis(ip,port,tag,connect,role,redis_version,redis_mode,os,arch_bits, gcc_version, process_id, run_id, tcp_port, uptime_in_seconds, uptime_in_days, connected_clients, blocked_clients, used_memory, used_memory_human, used_memory_rss, used_memory_rss_human, used_memory_peak, used_memory_peak_human,used_memory_lua, used_memory_lua_human, mem_fragmentation_ratio, mem_allocator, rdb_bgsave_in_progress, rdb_last_save_time, rdb_last_bgsave_status, rdb_last_bgsave_time_sec, aof_enabled, aof_rewrite_in_progress,aof_rewrite_scheduled, aof_last_rewrite_time_sec, aof_last_bgrewrite_status, total_connections_received, total_commands_processed, instantaneous_ops_per_sec, rejected_connections, expired_keys, evicted_keys,keyspace_hits, keyspace_misses, used_cpu_sys, used_cpu_user, used_cpu_sys_children, used_cpu_user_children) values('192.168.1.236','5001','监控服务Redis','1','master^M','3.2.12^M','standalone^M','Linux 3.10.0-1062.el7.x86_64 x86_64^M','64^M','4.8.5^M','21676^M^M','4a6bd093987e2612d2a52f712d3a575aec229418^M','5001^M','2743^M','0^M','3^M','0^M','854288^M','834.27K^M','2678784^M','2.55M^M','854288^M','834.27K^M','37888^M','37.00K^M','3.14^M','jemalloc-3.6.0^M','0^M','1642574364^M','ok^M','0^M','1^M','0^M','0^M','-1^M','ok^M','142^M','154^M','0^M','0^M','0^M','0^M','0^M','0^M','1.62^M','0.75^M','0.00^M','0.00^M')