# Analyze MySQL load with Percona toolkit pt-query-digest

**URL:** <https://forums.percona.com/t/analyze-mysql-load-with-percona-toolkit-pt-query-digest/32571>\
**Category:** Percona Toolkit\
**Tags:** mysql\
**Created:** [August 25, 2024, 1:18pm UTC](https://forums.percona.com/t/analyze-mysql-load-with-percona-toolkit-pt-query-digest/32571 "2024-08-25T13:18:49Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [August 25, 2024, 5:54pm UTC](https://forums.percona.com/t/analyze-mysql-load-with-percona-toolkit-pt-query-digest/32571/3 "2024-08-25T17:54:00Z")

</div>

Responded on Original question

> [@Percona toolkit find where load is coming from](https://forums.percona.com/t/percona-toolkit-find-where-load-is-coming-from/32468/4):
>
> Hi @Idan_Ahal, If you want to log all the queries consider adjusting the long query time. set global long\_query\_time=0 # or 0.1 Collect the log for the desired period, ensure performance / disk usage are acceptable. You can rotate your slow log to easily parse them directly with the digest OR you can use the --since and --until options to parse required information. The digest will not tell you what resource a query is using but you can get the stats for sure. Thanks, K

---

_[View the full topic](https://forums.percona.com/t/analyze-mysql-load-with-percona-toolkit-pt-query-digest/32571)._