3

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?

0

Your Answer

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