Bug #82002 Incorrect Rows_examined value
Submitted: 25 Jun 2016 7:53 Modified: 27 Jul 2016 8:18
Reporter: imane ziabat Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Logging Severity:S3 (Non-critical)
Version:5.6 OS:Ubuntu
Assigned to: CPU Architecture:Any

[25 Jun 2016 7:53] imane ziabat
Description:
Version: 5.6.30-76.3-log (Percona Server (GPL), Release 76.3, Revision 3850db5)

Entries in the slow query log could have an incorrect Rows_examined value

How to repeat:
In Log file I have for this query :

select count(*) as cnt from users;

# Query_time: 2.672217  Lock_time: 0.000062  Rows_sent: 0  
Rows_examined: 788210  Rows_affected: 0

But actually I have just 10 rows

mysql> SELECT COUNT(*) FROM users;
+----------+
| COUNT(*) |
+----------+
|      9   |
+----------+
[27 Jun 2016 8:18] MySQL Verification Team
Hello Imane Ziabat,

Thank you for the report.
I could not repeat this issue at my end with options --slow_query_log=1 --log-queries-not-using-indexes --long-query-time=0 on 5.6.31 and using dummy schema. Could you please share details from your environment such as show create table users\G and conf file used? You may want to mark as private note after posting here.

Thanks,
Umesh
[28 Jul 2016 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".