excluding some mysql queries from the slow query log

i keep close eye on the mysql-slow.log log of queries that take more than 1s to execute. but at the same time i know about few house-keeping queries that are executed few times per day that by design take longer to execute [eg table checksums]. i don’t want those queries to ‘pollute’ the slow query …

Continue reading ‘excluding some mysql queries from the slow query log’ »

ossec-syscheckd(1702): INFO: No directory provided for syscheck to monitor; Segmentation fault

i’m playing around with ossec 2.6. i’m trying to set up server for agentless monitoring of multiple linux boxes. after installation [where i answered no for most of the question] i’ve run into the following problem: to make things work and not segfault on config generated by the installer i had to modify /opt/ossec/etc/ossec.conf and …

Continue reading ‘ossec-syscheckd(1702): INFO: No directory provided for syscheck to monitor; Segmentation fault’ »