I have enabled slow query log on Amazon RDS with following configuration.

long_query_time = 0.5
general_log     = 0
log_output      = TABLE
min_examined_row_limit = 1000
slow_query_log = 1
log_queries_not_using_indexes = 1

to read slow query log , I am using following command from mysql workbench.

select * from mysql.slow_log where db = 'my_database' order by start_time desc;

but when I have seen log table, it shows me lots of queries used by mysql itself. like it shows me "performance_schema" related queries too. I want to filter it with my query only. does It has any option for this?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.