Bug #33350 log-queries-not-using-indexes & long_query_time works incorrect
Submitted: 19 Dec 2007 1:35 Modified: 19 Dec 2007 10:59
Reporter: long ahlong Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.22 OS:Linux (rh as 4.5)
Assigned to: CPU Architecture:Any
Tags: log-queries-not-using-indexes long_query_time

[19 Dec 2007 1:35] long ahlong 
Description:
+---------------------+------------------------------------+
| Variable_name       | Value                              |
+---------------------+------------------------------------+
| log_slow_queries    | ON                                 | 
| slow_launch_time    | 2                                  | 
| slow_query_log      | ON                                 | 
| slow_query_log_file | /usr/mysql/data/mainmysql-slow.log | 
+---------------------+------------------------------------+

where is the log of log-queries-not-using-indexes?
And the mainmysql-slow.log is not log message

How to repeat:
longlwh_dgb@21cn.net
[19 Dec 2007 10:59] Valeriy Kravchuk 
Sorry, but this is not a bug. All the values you need are included in

show variables;

results. You may use proper LIKE clause to get only the values you need:

show variables like '%quer%';