pt-index-usage eternal loop when slow log grows faster than it can process

Description

When I have a situation where my slow log is growing faster than pt-index-usage can process, the process never finishes.

 

It is relatively easy to reproduce using long_query_time=0 and sysbench.

Adding a timeout parameter might be a good idea.

 

Also, with SYS schema available, it might be more interesting to extract these statistics Possibly a bigger upgrade but it is an interesting idea.

Environment

None

AFFECTED CS IDs

CS0016564

Smart Checklist

Activity

Details

Assignee

Reporter

Priority

Smart Checklist

Created March 12, 2021 at 9:09 PM
Updated February 29, 2024 at 8:54 PM