Does not rotate logs?

[sv3t0sl4v]

Using logrotate on Ubuntu this could be achieved. I noticed clickhouse-mysql does not do it by itself.

Create file /etc/logrotate.d/clickhouse-mysql and add

/path/to//your/log/from/config { 
    daily
    create 0644 root root
    rotate 7
    compress
    postrotate
        service clickhouse-mysql restart
    endscript
}

Make sure to record MySQL binlog position in a file on disk, so it can resume from where it was.
By default Ubuntu runs logrotate every day at 6:25 AM.
Cheers!