Analyze MySQL load with Percona toolkit pt-query-digest

[kedarpercona]

Responded on Original question

Percona toolkit find where load is coming from

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