Your my.cnf file contains these settings:
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?
The required changes to the configuration must involve settings relating to query execution time, the number of records examined, and the use of indexes. You need to set the 'long_query_time' to 5 to ensure queries longer than 5 seconds are logged, 'min_examined_row_limit' to 5000 to log queries examining at least 5000 rows and 'log_throttle_queries_not_using_indexes' to manage the rate of logging for queries not using indexes. The option containing all these settings is correct.
G is it
E sorry. log_queries_not_using_indexes only limits the number of queries that don't ue indexes to the log, to it has nothing to do with what we want.