enterprise-support team mailing list archive

[Alexey Kopytov <alexey.kopytov@xxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: High
         Status: Triaged

** Affects: percona-server/5.1
     Importance: Undecided
         Status: Won't Fix

** Affects: percona-server/5.5
     Importance: High
         Status: Triaged

** Affects: percona-server/5.6
     Importance: High
         Status: Triaged

** Bug watch added: MySQL Bug System #49169
   http://bugs.mysql.com/bug.php?id=49169

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=49169
   Importance: Unknown
       Status: Unknown

** Also affects: percona-server/5.1
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Changed in: percona-server/5.1
       Status: New => Won't Fix

** Changed in: percona-server/5.5
       Status: New => Triaged

** Changed in: percona-server/5.5
   Importance: Undecided => High

** Changed in: percona-server/5.6
       Status: New => Triaged

** Changed in: percona-server/5.6
   Importance: Undecided => High

** Changed in: percona-server/5.5
    Milestone: None => 5.5.29-30.0

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1131189

Title:
  Remove trx_list scan from read_view_open_now()

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1131189/+subscriptions