Remove trx_list scan from read_view_open_now()
Bug #1131189 reported by
Alexey Kopytov
on 2013-02-21
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| | MySQL Server |
Unknown
|
Unknown
|
|||
| Percona Server | Status tracked in 5.6 | |||||
| | 5.1 |
Undecided
|
Unassigned | |||
| | 5.5 |
High
|
Alexey Kopytov | |||
| | 5.6 |
High
|
Alexey Kopytov | |||
Bug Description
read_view_
of the list of all open transactions (trx_sys->trx_list) with the
kernel_mutex locked. On high-concurrency workloads (i.e. sysbench
read-only with number of threads >= 512) the cost of this scan is
huge.
Related branches
lp:~akopytov/percona-server/bug1131189
- Laurynas Biveinis: Approve on 2013-03-25
- Alexey Kopytov: Resubmit on 2013-03-25
- Diff: 1371 lines (+446/-230) 16 files modified
lp:~akopytov/percona-server/bug1131189-5.6
- Laurynas Biveinis: Approve on 2013-05-26
- Diff: 1545 lines (+617/-233) 21 files modified
Added PXC here to track for lp:1180802
Raghavendra D Prabhu (raghavendra-prabhu)
on 2013-06-14
| no longer affects: | percona-xtradb-cluster |
To post a comment you must log in.
Upstream bug has been closed as fixed in 5.6, presumably in 5.6.11. It makes sense to postpone any 5.6 work on this bug until then.