Ad Widget

Collapse

Zabbix 4.0 slow queries

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • superset
    Junior Member
    • Jul 2019
    • 11

    #1

    Zabbix 4.0 slow queries

    Hi,

    I noticed we had quite a few slow queries in the zabbix server log so i decided to pull the log from the DB to see what was going on. I noticed this specific query showing up 324573 times in 1 day.

    # User@Host: xxx[xxx] @ [xxx.xxx.xxx.xxx]
    # Thread_id: 6091675 Schema: zabbix QC_hit: No
    # Query_time: 0.000103 Lock_time: 0.000031 Rows_sent: 1 Rows_examined: 1
    # Rows_affected: 0
    SET timestamp=1573478290;
    SELECT NULL FROM config c;


    Anybody who can tell me where this is coming from?
  • dimir
    Zabbix developer
    • Apr 2011
    • 1080

    #2
    It's coming from frontend. On every connection it's checking the integrity of config table this way.

    Comment

    Working...