Percona Server with XtraDB

internal temporary tables are contended on THR_LOCK_myisam

Reported by Laurynas Biveinis on 2013-05-14
6
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
Medium
Laurynas Biveinis
5.6
Medium
Unassigned

Bug Description

This is to track backporting of the http://bugs.mysql.com/bug.php?id=65077 "internal temporary tables are contended on THR_LOCK_myisam" fix to Percona Server 5.5.

5.6$ bzr log -r 4195.3.1

------------------------------------------------------------
revno: 4195.3.1
committer: Sergey Vojtovich <email address hidden>
branch nick: mysql-5.6-bug14000697
timestamp: Wed 2012-08-29 16:49:37 +0400
message:
  BUG#14000697 - 65077: INTERNAL TEMPORARY TABLES ARE CONTENDED ON
                 THR_LOCK_MYISAM

  MyISAM registers all open tables on myisam_open_list. This list is
  protected by global mutex (THR_LOCK_myisam). Under concurrent
  load it causes excessive THR_LOCK_myisam mutex contention.

  Fixed by not registering internal temporary tables on
  myisam_open_list, similarly to MEMORY engine.

3902.56.1 in 5.7.

tags: added: upstream
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

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