Rows_read and Rows_sent don't seem right

[Baron Schwartz]

I think this is related to #312598 but not the same thing. Here's a sample:

# User@Host: ui[ui] @ localhost []
# Query_time: 0.000039 Lock_time: 0.000000 Rows_sent: 3 Rows_examined: 3
use ui_production;
# administrator command: Statistics;
# User@Host: ui[ui] @ localhost []
# Query_time: 0.000040 Lock_time: 0.000000 Rows_sent: 3 Rows_examined: 3
# administrator command: Statistics;

Can that possibly be correct? I don't think it can, but I could be wrong.

[Yasufumi Kinoshita (yasufumi-kinoshita)]

about Rows_read may be the duplicate of bug 312598 .
about Rows_sent couldn't be reproduced at my environment.

[Yasufumi Kinoshita (yasufumi-kinoshita)]

By the way, this log seems to be similar to by "normal MySQL" rather than newer percona-patches version.
I think the percona patches already have fixed the output of "Rows_sent:" and "Rows_examined:".

[Vadim Tkachenko (vadim-tk)]

Yasufumi,

Query_time: 0.000039 - it's available only in Percona builds.

Yasufumi Kinoshita wrote:
> By the way, this log seems to be similar to by "normal MySQL" rather than newer percona-patches version.
> I think the percona patches already have fixed the output of "Rows_sent:" and "Rows_examined:".
>

--
Vadim Tkachenko, CTO
Percona Inc.
ICQ: 369-510-335, Skype: vadimtk153, Phone [phone]
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.percona.com/