Is it possible to include the user and host details of killed queries in the pt-kill log file? Currently, I can see the following details:
- Timestamp
- Thread ID
- Query Time
- Query
Are there any options to log the user and hostname as well?
Is it possible to include the user and host details of killed queries in the pt-kill log file? Currently, I can see the following details:
Are there any options to log the user and hostname as well?
Hi @Asuwini_P
Can you try using --print --json
?
Ref: pt-kill — Percona Toolkit Documentation
Thanks,
K
Thank you @kedarpercona, got the required details in the log file
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.