When you log slow queries or queries without indexes in MySQL, you should regularly rotate the file to save disk space. Quite some suggestions on the internet involve complex scripts which do this, other suggestions discuss FreeBSD's log rotator newsyslog. However, most of the descriptions about newsyslog appeared wrong to me, because no PID file was specified for the rule. This means that a SIGHUP is sent to the syslog daemon instead of the mysqld process, which is undesired.