Recently I received several questions about rotating log files
for ProxySQL, so I decided to draft it up as a blog post. Let me
go by this using an example.
In my testing lab, I have set up a fairly default ProxySQL
(version 1.4.13) service. The default location for the
proxysql.log is in /var/lib/proxysql.
[root@proxysql ~]# ls -hal /var/lib/proxysql/proxysql.log*
-rw-------. 1 root root 4.9K Jan 30 18:47 /var/lib/proxysql/proxysql.log
I created a pretty basic default logrotate configuration to
ensure my logfile rotates on a daily basis and five rotations are
kept before expiring.
[root@proxysql ~]# cat /etc/logrotate.d/proxysql
create 0600 root root
Let’s check whether this is actually the correct file that is
used that we will be rotating. As it turned out it is!
[root@proxysql ~]# lsof | …[Read more]