Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

[Shawn Green]

On 10/15/2012 7:15 PM, spameden wrote:
> Thanks a lot for all your comments!
>
> I did disable Query cache before testing with
>
> set query_cache_type=OFF
>
> for the current session.
>
> I will report this to the MySQL bugs site later.
>
>

First. What are all of your logging settings?

     SHOW GLOBAL VARIABLES LIKE '%log%';

Next. When you physically look in the slow query log, how long does it 
say that it took this command to execute?

And last, before you can ask MySQL to fix a bug, you must first ensure 
it's a MySQL bug. Please try to reproduce your results using official 
binaries, not those constructed by a third party.  If the problem exists 
in our packages, do tell us about it. If the problem is not reproducible 
using official MySQL products, then please report it to the appropriate 
channel for the product you are using.

MySQL Bugs -
http://bugs.mysql.com/

Thanks!
-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN