checkmk
checkmk copied to clipboard
make mysql capacity check optional (high load caused oom error)
General information
on a shared hosting server we found the capacity check was adding extreme amounts of load to our MySQL server. it was also causing the checkmk agent to not respond in time (per https://forum.checkmk.com/t/cmk-agent-connection-ok-dump-has-no-output/38598)
timed dump command before disabling the mysql_capacity check
real 2m3.968s
user 0m0.002s
sys 0m0.006s
timed dump after disabling the mysql_capacity check
real 0m15.227s
user 0m0.002s
sys 0m0.013s
Proposed changes
This change makes it possible to easily disable the capacity checks by creating a local file at ${MK_CONFDIR}/mysql.local.disable_capacity_checks
The existing usecase will not change at all if the file does not exist.