Percona Server with XtraDB

Remove trx_list scan from read_view_open_now()

Reported by Alexey Kopytov on 2013-02-21
14
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_open_now() and read_cursor_view_create_for_mysql() do a scan
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.

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.

Added PXC here to track for lp:1180802

no longer affects: percona-xtradb-cluster
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.