GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-archiver affecting online queries

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

  • pt-archiver affecting online queries

    Hi,

    When I execute pt-archiver it impacts my online queries. It causes them to go slow to a point where I have to stop pt-archiver process and restart mysql. Just stopping pt-archiver process doesnt stop my queries from returning to normal execution. They keep getting slower and slower even after I stop pt-archiver. This happens after some period of execution (of pt-archiver). It doesnt happen instantly after pt-archiver executes. It builds up over time and the queries tend to go slow after about 20 minutes of pt-archiver execution. I have noticed that the queries tend to get slow when pt-archiver is deleting the data not when it is selecting it. When I restart mysql the queries run normally in less than a second. Any thoughts on this will be very useful. Its a pain having to restart mysql every now and then.
Working...
X