internal temporary tables are contended on THR_LOCK_myisam
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Unassigned | ||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.6 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
This is to track backporting of the http://
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
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.
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 188 lines (+45/-16)5 files modifiedPercona-Server/include/my_base.h (+1/-0)
Percona-Server/sql/sql_select.cc (+1/-1)
Percona-Server/storage/myisam/mi_close.c (+6/-3)
Percona-Server/storage/myisam/mi_create.c (+8/-4)
Percona-Server/storage/myisam/mi_open.c (+29/-8)
tags: | added: upstream |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1362