Ad Widget

Collapse

Alert Zabbix database is down every 15 minutes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gumis_148
    Member
    • Jan 2019
    • 52

    #1

    Alert Zabbix database is down every 15 minutes


    I got alert "Alert Zabbix database is down" every 15 minutes. What could be the reason?

    /var/log/zabbix/zabbix_server.log:

    Click image for larger version  Name:	zabbix1.JPG Views:	0 Size:	261.5 KB ID:	397619

    And I get often logs from InnoDB (every 1 minute) /var/log/mysql/error.log:

    Click image for larger version  Name:	zabbix2.JPG Views:	0 Size:	271.1 KB ID:	397620

    /etc/mysql/my.cfg
    Code:
    root@zabbix:/home/appliance# cat /etc/mysql/my.cnf
    
    [client]
    port            = 3306
    socket          = /var/run/mysqld/mysqld.sock
    
    [mysqld_safe]
    socket          = /var/run/mysqld/mysqld.sock
    nice            = 0
    
    [mysqld]
    user            = mysql
    pid-file        = /var/run/mysqld/mysqld.pid
    socket          = /var/run/mysqld/mysqld.sock
    port            = 3306
    basedir         = /usr
    datadir         = /var/lib/mysql
    tmpdir          = /tmp
    lc-messages-dir = /usr/share/mysql
    skip-external-locking
    
    bind-address            = 0.0.0.0
    
    max_allowed_packet      =1G
    key_buffer              = 16M
    thread_stack            = 192K
    thread_cache_size       = 8
    myisam-recover         = BACKUP
    max_connections        = 500
    
    query_cache_limit       = 100M
    query_cache_size        = 100M
    
    log_error = /var/log/mysql/error.log
                           = /var/log/mysql/mysql-bin.log
    expire_logs_days        = 10
    max_binlog_size         = 100M
    
    [mysqldump]
    quick
    quote-names
    max_allowed_packet      = 16M
    
    [isamchk]
    key_buffer              = 16M
    Last edited by gumis_148; 15-03-2020, 11:14.
Working...