Remove trx_list scan from read_view_open_now()

Bug #1131189 reported by Alexey Kopytov
14
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Alexey Kopytov
5.1
Won't Fix
Undecided
Unassigned
5.5
Fix Released
High
Alexey Kopytov
5.6
Fix Released
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.

Related branches

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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.

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Added PXC here to track for lp:1180802

no longer affects: percona-xtradb-cluster
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-637

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.