Hi,
I'm experiencing low Zabbix Server 1.8.2 performance, because items are not updating and I can see them in Zabbix queue. I've tunned mysql and apache already, but I think the problem is zabbix_server tunning. The io host is high, however top host is ok.
I need some help for zabbix_server tunning.
This is my Zabbix Status:
This is my zabbix_server.conf:
MySQL my.conf:
I'm experiencing low Zabbix Server 1.8.2 performance, because items are not updating and I can see them in Zabbix queue. I've tunned mysql and apache already, but I think the problem is zabbix_server tunning. The io host is high, however top host is ok.
I need some help for zabbix_server tunning.
This is my Zabbix Status:
Code:
Zabbix server is running Yes - Number of hosts (monitored/not monitored/templates) 546 401 / 20 / 125 Number of items (monitored/disabled/not supported) 8152 6507 / 1631 / 14 Number of triggers (enabled/disabled)[true/unknown/false] 4816 3940 / 876 [43 / 401 / 3496] Number of users (online) 26 6 Required server performance, new values per second 53.1465 -
Code:
############ ADVANCED PARAMETERS ################ ### Option: StartPollers # Number of pre-forked instances of pollers. # You shouldn't run more than 30 pollers normally. # # Mandatory: no # Range: 0-255 # Default: # StartPollers=5 StartPollers=125 ### Option: StartIPMIPollers # Number of pre-forked instances of IPMI pollers. # # Mandatory: no # Range: 0-255 # Default: # StartIPMIPollers=0 StartIPMIPollers=5 ### Option: StartPollersUnreachable # Number of pre-forked instances of pollers for unreachable hosts. # # Mandatory: no # Range: 0-255 # Default: # StartPollersUnreachable=1 StartPollersUnreachable=15 ### Option: StartTrappers # Number of pre-forked instances of trappers # # Mandatory: no # Range: 0-255 # Default: # StartTrappers=5 StartTrappers=125 ### Option: StartPingers # Number of pre-forked instances of ICMP pingers. # # Mandatory: no # Range: 0-255 # Default: # StartPingers=1 StartPingers=80 ### Option: StartDiscoverers # Number of pre-forked instances of discoverers. # # Mandatory: no # Range: 0-255 # Default: # StartDiscoverers=1 StartDiscoverers=0 ### Option: StartHTTPPollers # Number of pre-forked instances of HTTP pollers. # # Mandatory: no # Range: 0-255 # Default: # StartHTTPPollers=1 StartHTTPPollers=25 ### Option: CacheSize # Size of configuration cache, in bytes. # Shared memory size for storing hosts and items data. # # Mandatory: no # Range: 128K-1G # Default: # CacheSize=8M CacheSize=100M ### Option: CacheUpdateFrequency # How often Zabbix will perform update of configuration cache, in seconds. # # Mandatory: no # Range: 1-3600 # Default: # CacheUpdateFrequency=60 #CacheUpdateFrequency= ### Option: HistoryCacheSize # Size of history cache, in bytes. # Shared memory size for storing history data. # # Mandatory: no # Range: 128K-1G # Default: # HistoryCacheSize=8M HistoryCacheSize=30M ### Option: TrendCacheSize # Size of trend cache, in bytes. # Shared memory size for storing trends data. # # Mandatory: no # Range: 128K-1G # Default: # TrendCacheSize=4M TrendCacheSize=10M ### Option: HistoryTextCacheSize # Size of text history cache, in bytes. # Shared memory size for storing character, text or log history data. # # Mandatory: no # Range: 128K-1G # Default: # HistoryTextCacheSize=16M HistoryTextCacheSize=20M ### Option: Timeout # Specifies how long we wait for agent, SNMP device or external check (in seconds). # # Mandatory: no # Range: 1-30 # Default: # Timeout=3 Timeout=10 ### Option: TrapperTimeout # Specifies how many seconds trapper may spend processing new data. # # Mandatory: no # Range: 1-300 # Default: # TrapperTimeout=300 TrapperTimeout=300 ### Option: UnreachablePeriod # After how many seconds of unreachability treat a host as unavailable # # Mandatory: no # Range: 1-3600 # Default: # UnreachablePeriod=45 UnreachablePeriod=60 ### Option: UnavailableDelay # How often host is checked for availability during the unavailability period. # # Mandatory: no # Range: 1-3600 # Default: # UnavailableDelay=60 UnavailableDelay=120 ### Option: UnreachableDelay # How often host is checked for availability during the unreachability period # # Mandatory: no # Range: 1-3600 # Default: # UnreachableDelay=15 UnreachableDelay=60 ### Option: LogSlowQueries # If a query takes longer than this many milliseconds, the query is logged to the log file. # 0 - disable log slow queries # # Mandatory: no # Range: 0-3600000 # Default: # LogSlowQueries=0 LogSlowQueries=10000
Code:
query_cache_limit = 1M query_cache_size = 16M [isamchk] key_buffer = 16M [mysqld] lower_case_table_names = 1 bind-address = 0.0.0.0 #general_log = 1 #general_log_file = /var/log/mysql/mysql.log #log-bin = /var/log/mysql/mysql-bin.log expire_logs_days = 3 max_binlog_size = 100M log-short-format long_query_time = 30 log_slow_queries = /var/log/mysql/mysql-slow.log # * Fine Tuning key_buffer = 1024M thread_stack = 1024K thread_cache_size = 20 read_rnd_buffer_size = 524288 read_buffer_size = 256K sort_buffer_size = 3145720 max_allowed_packet = 1024M max_connections = 1000 join_buffer_size = 1M query_cache_size = 128M query_cache_limit = 2M tmp_table_size = 256M max_heap_table_size = 256M table_cache = 512 max_tmp_tables = 64 wait_timeout = 28800 interactive_timeout = 28800 # * InnoDB innodb_buffer_pool_size = 128M innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit = 2 [mysqldump] max_allowed_packet = 160M
Comment