Ad Widget

Collapse

Zabbix set the time on MySQL every 1 second.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ysmolyaninov
    Junior Member
    • Nov 2013
    • 2

    #1

    Zabbix set the time on MySQL every 1 second.

    Hi
    I see the following queries in zabbix database

    # User@Host: zabbix[zabbix] @ localhost []
    # Thread_id: 121239577 Schema: Last_errno: 0 Killed: 0
    # Query_time: 0.000002 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0
    # Bytes_sent: 0 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
    SET timestamp=1381234717;
    # administrator command: Quit;
    # Time: 131008 14:18:38
    # User@Host: zabbix[zabbix] @ localhost []
    # Thread_id: 121239578 Schema: Last_errno: 0 Killed: 0
    # Query_time: 0.000003 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0
    # Bytes_sent: 0 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
    SET timestamp=1381234718;
    # administrator command: Quit;
    # Time: 131008 14:18:39
    # User@Host: zabbix[zabbix] @ localhost []
    # Thread_id: 121239579 Schema: Last_errno: 0 Killed: 0
    # Query_time: 0.000003 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0
    # Bytes_sent: 0 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
    SET timestamp=1381234719;
    # administrator command: Quit;
    # Time: 131008 14:18:40

    Every second zabbix sets time. It looks unnecessary and increases database load. Could you advise how to reduce the number of these queries, because reading documentation/googling gave no result.

    Thank you.
Working...