Choose the best answer.Your my.cnf file contains these settings: [mysqld]log_output=FILE
Slow_query_log long_query_time=2.01 log_queries_not_using_indexes
You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?
Slow_query_log long_query_time=2.01 log_queries_not_using_indexes
You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?
Alog_throttle_queries_not_using_indexes=5
Blong_query_time=5 log_throttle_queries_not_using_indexes=5
Clong_query_time=5 min_examined_row_limit=5000
Dlong_query_time=5 log_throttle_queries_not_using_indexes=5 min_examined_row_limit=5000
Elog_throttle_queries_not_using_indexes=5 min_examined_row_limit=5000
Flong_query_time=5
Gmin_examined_row_limit=5000