I've been having problems with the agents' data for awhile. After a few weeks, the data disappears. If I restart the server processes, everything reports in with no problems...and a few weeks later disappears again. I suspect my database just isn't setup properly, the server isn't anywhere near stressed and hasn't even ever touched swap. I'm using innodb with mysql, and pasted some of the innodb settings below. I'm using version 1.1.7 at the moment, but I don't want to move forward with the new version until I can find out what is causing the agent data to drop. I have 19 monitored servers setup, and the zabbix server is a dual processor HP bl20p with 2 gigs of ram.
my.cnf settings
Anything else I should check/paste that would be helpful in finding out what's up?
my.cnf settings
Code:
innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 16M innodb_data_file_path = ibdata1:128M;ibdata2:50M:autoextend:max:8G innodb_log_file_size = 128M innodb_log_buffer_size = 8M set-variable = innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50