checkmk icon indicating copy to clipboard operation
checkmk copied to clipboard

make mysql capacity check optional (high load caused oom error)

Open ITJamie opened this issue 1 year ago • 0 comments

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.

ITJamie avatar Feb 13 '24 12:02 ITJamie