table_open_cache increasing leads to performance regression
Bug #1038940 reported by
Vlad Lesin
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 | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Medium
|
Vlad Lesin | |||
5.5 |
Triaged
|
Medium
|
Vlad Lesin | |||
5.6 |
Triaged
|
Medium
|
Vlad Lesin | |||
5.7 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
This is a duplicate of the following upstream bug: http://
Related branches
lp://staging/~vlad-lesin/percona-server/5.1-table_cache_speed_up
On hold
for merging
into
lp://staging/percona-server/5.1
- Stewart Smith (community): Needs Fixing
- Alexey Kopytov (community): Approve
-
Diff: 318 lines (+118/-33)10 files modifiedPercona-Server/storage/myisam/ha_myisam.cc (+4/-0)
Percona-Server/storage/myisam/mi_close.c (+1/-1)
Percona-Server/storage/myisam/mi_dbug.c (+3/-3)
Percona-Server/storage/myisam/mi_keycache.c (+3/-3)
Percona-Server/storage/myisam/mi_open.c (+67/-13)
Percona-Server/storage/myisam/mi_panic.c (+25/-9)
Percona-Server/storage/myisam/mi_static.c (+1/-1)
Percona-Server/storage/myisam/myisamchk.c (+6/-0)
Percona-Server/storage/myisam/myisamdef.h (+3/-3)
Percona-Server/storage/myisam/myisampack.c (+5/-0)
lp://staging/~vlad-lesin/percona-server/5.1-gca-bug-1038940-table_cache_speed_up
On hold
for merging
into
lp://staging/percona-server/5.1
- Laurynas Biveinis (community): Needs Fixing
- Stewart Smith: Pending requested
-
Diff: 441 lines (+185/-99)10 files modifiedPercona-Server/storage/myisam/ha_myisam.cc (+4/-0)
Percona-Server/storage/myisam/mi_close.c (+1/-1)
Percona-Server/storage/myisam/mi_dbug.c (+3/-3)
Percona-Server/storage/myisam/mi_keycache.c (+3/-3)
Percona-Server/storage/myisam/mi_open.c (+67/-13)
Percona-Server/storage/myisam/mi_panic.c (+92/-75)
Percona-Server/storage/myisam/mi_static.c (+1/-1)
Percona-Server/storage/myisam/myisamchk.c (+6/-0)
Percona-Server/storage/myisam/myisamdef.h (+3/-3)
Percona-Server/storage/myisam/myisampack.c (+5/-0)
lp://staging/~vlad-lesin/percona-server/5.5-bug-1038940-table_cache_speed_up
On hold
for merging
into
lp://staging/percona-server/5.5
- Laurynas Biveinis (community): Needs Fixing
- Stewart Smith: Pending requested
-
Diff: 320 lines (+116/-34)10 files modifiedPercona-Server/storage/myisam/ha_myisam.cc (+3/-0)
Percona-Server/storage/myisam/mi_close.c (+1/-1)
Percona-Server/storage/myisam/mi_dbug.c (+3/-3)
Percona-Server/storage/myisam/mi_keycache.c (+3/-3)
Percona-Server/storage/myisam/mi_open.c (+67/-13)
Percona-Server/storage/myisam/mi_panic.c (+24/-8)
Percona-Server/storage/myisam/mi_static.c (+1/-1)
Percona-Server/storage/myisam/myisamchk.c (+6/-0)
Percona-Server/storage/myisam/myisamdef.h (+3/-3)
Percona-Server/storage/myisam/myisampack.c (+5/-2)
lp://staging/~vlad-lesin/percona-server/5.6-bug-1038940-table_cache_speed_up
On hold
for merging
into
lp://staging/percona-server/5.6
- Laurynas Biveinis (community): Needs Fixing
-
Diff: 346 lines (+118/-40)10 files modifiedPercona-Server/storage/myisam/ha_myisam.cc (+3/-0)
Percona-Server/storage/myisam/mi_close.c (+4/-7)
Percona-Server/storage/myisam/mi_dbug.c (+3/-3)
Percona-Server/storage/myisam/mi_keycache.c (+3/-3)
Percona-Server/storage/myisam/mi_open.c (+66/-13)
Percona-Server/storage/myisam/mi_panic.c (+24/-8)
Percona-Server/storage/myisam/mi_static.c (+1/-1)
Percona-Server/storage/myisam/myisamchk.c (+6/-0)
Percona-Server/storage/myisam/myisamdef.h (+3/-3)
Percona-Server/storage/myisam/myisampack.c (+5/-2)
Changed in percona-server: | |
assignee: | nobody → Vladislav Lesin (vlad-lesin) |
description: | updated |
Changed in percona-server: | |
status: | New → In Progress |
description: | updated |
tags: | added: performance upstream |
To post a comment you must log in.
the attached patch of upstream bug#33948 (http:// bugs.mysql. com/bug. php?id= 33948) may also help improve performance of table cache.