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