Not the answer you need?
Register and ask your own question!

pt-agent not rotate mysql-slow-log

szenobioszenobio EntrantCurrent User Role Beginner
Hi, I'm installed percona-agent-1.0.6-x86_64.tar.gz. The tool work fine, but not rotate mysql-slow-log. In gui I configure Max slow query log size on 1GB but the file on disk is 5GB.

I have this error on log from gui interface:

Warning 2014-08-26 18:51:00qan-intervalstat mysql-slow-log: no such file or directory

Comments

  • paul.namuagpaul.namuag Entrant Current User Role Beginner
    Hi szenobio,

    Did you specify the path of your slow query log in your configuration file (i.e. /etc/my.cnf, /etc/mysql/my.cnf)?
  • szenobioszenobio Entrant Current User Role Beginner
    Hi Paul, this is my config on my.cnf

    datadir = /opt/app-db2-data/mysql/
    slow-query-log-file = mysql-slow-log

    Need I put the full path on slow-query-log-file ?
  • szenobioszenobio Entrant Current User Role Beginner
    Hi again, I modify slow-query-log-file = mysql-slow-log to slow-query-log-file = path/mysql-slow-log, and work. Thanks for all
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.