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.
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.