ZFS MariaDB Log rotation

[fred974]

Hi,

I just had 2 hours downtime as a result of low disk space ..
I realised after a lot of digging that my /var/db/mysql/mysql-slow.log was over 24 GB in size..
As a result I am trying to use newsyslog()to rotate the files..
Could someone please tell me if the entry bellow look correct to log rotate mysql?

/var/db/mysql/mysql-slow.log   mysql:mysql  600  7  1000  *  J   /var/db/mysql/holy.mydomain.co.uk.pid
/var/db/mysql/mysql-error.log  mysql:mysql  600  7  1000  *  J   /var/db/mysql/holy.mydomain.co.uk.pid

What do you guys use?

 

[SirDice]

Just turn it off and only enable it when you actually do something with it, i.e. tuning your databases and queries. There's no point in logging slow queries if nobody looks at it.

 

[fred974]

There's no point in logging slow queries if nobody looks at it

Very good point but at the moment we do have a website that has huge performence issue for which we need the info.
I'll turn it off when its no longer required tough