Hi there!
I'm using Zabbix 2.0.8 together with MySQL 5.5.38-0+wheezy1 (on a separate DB server). I've setup a partitioning scheme by following (and slightly modifiying - but the essence stayed the same) the perl script on http://zabbix.org/wiki/Docs/howto/mysql_partitioning . This script is run once every night.
Now I got two questions:
1. I am supposed to shut down the zabbix server while running this script, right? Keeping it running would be bad?
2. It turns out (by logging) that sometimes the first query to add a partition to zabbix.history takes more than twenty minutes to execute. Sometimes it takes less than a second. I've only introduced timestamps to my log files on friday, so I can only judge three occurences - but of these, I've seen the long delay in two cases.
I'm not an expert in data base setup - so if anyone could give me any clue as to what's going on, I'd greatly appreciate it.
Regards,
Semue
I'm using Zabbix 2.0.8 together with MySQL 5.5.38-0+wheezy1 (on a separate DB server). I've setup a partitioning scheme by following (and slightly modifiying - but the essence stayed the same) the perl script on http://zabbix.org/wiki/Docs/howto/mysql_partitioning . This script is run once every night.
Now I got two questions:
1. I am supposed to shut down the zabbix server while running this script, right? Keeping it running would be bad?
2. It turns out (by logging) that sometimes the first query to add a partition to zabbix.history takes more than twenty minutes to execute. Sometimes it takes less than a second. I've only introduced timestamps to my log files on friday, so I can only judge three occurences - but of these, I've seen the long delay in two cases.
I'm not an expert in data base setup - so if anyone could give me any clue as to what's going on, I'd greatly appreciate it.
Regards,
Semue