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