slow_extended in 5.5 always shows identical values for Rows_sent and Rows_read
Bug #721176 reported by
Alexey Kopytov
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Alexey Kopytov | ||
5.5 |
Fix Released
|
Medium
|
Alexey Kopytov |
Bug Description
slow_extended in 5.5 uses the same variable (thd->sent_
The bug was introduced when porting slow_extended.patch to 5.5.
On the other hand, I don't understand the meaning of Rows_read. What information is it supposed to reflect? Should we really have it in the slow log?
Related branches
lp:~tsarev/percona-server/bug721176
Rejected
for merging
into
lp:percona-server/5.5
- Vadim Tkachenko: Disapprove
-
Diff: 369 lines (+78/-68)5 files modifiedpatches/memory_dynamic_rows.patch (+20/-0)
patches/mysql-test.diff (+11/-11)
patches/processlist_row_stats.patch (+35/-44)
patches/slow_extended.patch (+4/-5)
patches/userstat.patch (+8/-8)
lp:~akopytov/percona-server/bug830286-5.5
- Laurynas Biveinis (community): Approve
- George Ormond Lorch III (community): Approve (g2)
- Vlad Lesin (community): Approve
-
Diff: 475 lines (+393/-11)8 files modifiedPercona-Server/mysql-test/include/percona_slow_extended_error_on_quit.inc (+50/-0)
Percona-Server/mysql-test/r/percona_bug830286.result (+15/-0)
Percona-Server/mysql-test/r/percona_processlist_row_stats.result (+9/-9)
Percona-Server/mysql-test/r/percona_slow_extended_error_on_quit.result (+172/-0)
Percona-Server/mysql-test/t/percona_bug830286.test (+58/-0)
Percona-Server/mysql-test/t/percona_slow_extended_error_on_quit.test (+87/-0)
Percona-Server/sql/log.cc (+1/-1)
Percona-Server/sql/sql_show.cc (+1/-1)
To post a comment you must log in.
Alexey,
Can we get the bug report which shows it ? I know there are cases then
these data are different.
I think the problem was for some update queries rows examined are not
showing up but rows read does.
On Fri, Feb 18, 2011 at 2:22 AM, Alexey Kopytov
<email address hidden>wrote:
> Public bug reported: row_count) to LOG::write( ) in log.cc. /bugs.launchpad .net/bugs/ 721176 row_count) to LOG::write( ) in
>
> slow_extended in 5.5 uses the same variable (thd->sent_
> print both Rows_sent and Rows_read in the extended slow query log stats.
> This can be verified by examining MYSQL_QUERY_
>
> The bug was introduced when porting slow_extended.patch to 5.5.
>
> On the other hand, I don't understand the meaning of Rows_read. What
> information is it supposed to reflect? Should we really have it in the
> slow log?
>
> ** Affects: percona-server
> Importance: Undecided
> Status: New
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https:/
>
> Title:
> slow_extended in 5.5 always shows identical values for Rows_sent and
> Rows_read
>
> Status in Percona Server with XtraDB:
> New
>
> Bug description:
> slow_extended in 5.5 uses the same variable (thd->sent_
> print both Rows_sent and Rows_read in the extended slow query log
> stats. This can be verified by examining MYSQL_QUERY_
> log.cc.
>
> The bug was introduced when porting slow_extended.patch to 5.5.
>
> On the other hand, I don't understand the meaning of Rows_read. What
> information is it supposed to reflect? Should we really have it in the
> slow log?
>
--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911
Join us for Percona Live Event, San Francisco, Feb 16 www.percona. com/events/ percona- live-san- francisco- 2011/
http://