GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Rotation of query log

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Rotation of query log

    Hi!

    After enabling pt-agent daemon our server is producing large amount of slow query logs. Unfortunately after sending data to Percona Cloud servers, logs are rotated with current timestamp and not deleted. This is quite big problem as logs are stored on SSD drive. I wonder why there's no option in pt-agent to delete unneeded logs?

    I could write cron script to delete old logs, but there's another question if it's safe to delete all rotated logs or maybe the latest file may be still processed by some tool.

    Thanks,
    Piotr

  • #2
    Hi,

    There is an option for auto-removal the slow logs, but you set it on the PCT web UI - Agents -> expand the details by the agent name -> Services -> "Remove old slow logs" checkbox.
    You can also rate limit the amount of log entries get logged to limit the size of logs on disk - the "Log slow rate limit"
    More details: http://www.percona.com/doc/percona-s...low_rate_limit

    Comment


    • #3
      Thanks, I've missed that one, now it works.

      Dzięki za pomoc!

      Piotr

      Comment

      Working...
      X