Merge lp://qastaging/~vlad-lesin/percona-server/5.6-bug-1038940-table_cache_speed_up into lp://qastaging/percona-server/5.6
| Status: | Work in progress |
|---|---|
| Proposed branch: | lp://qastaging/~vlad-lesin/percona-server/5.6-bug-1038940-table_cache_speed_up |
| Merge into: | lp://qastaging/percona-server/5.6 |
| Diff against target: |
346 lines (+118/-40) 10 files modified
Percona-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) |
| To merge this branch: | bzr merge lp://qastaging/~vlad-lesin/percona-server/5.6-bug-1038940-table_cache_speed_up |
| Related bugs: |
| Reviewer | Review Type | Date Requested | Status |
|---|---|---|---|
| Laurynas Biveinis (community) | Needs Fixing | ||
|
Review via email:
|
|||
Description of the change
This MP is port of this http://
Jenkins tests:
http://
| Laurynas Biveinis (laurynas-biveinis) wrote | # |
Unmerged revisions
- 317. By Vlad Lesin
-
As the number of open tables is increased, table lookup
(testing if a table is already open) and (in particular)
the case when a table is not open, became increasingly more
expensive.The problem was caused by the open table lookup mechanism,
which was based on traversing a linked list comparing the
file names.As the list was replaced by a hash table, the lookup
time dropped significantly when used on systems with
a large number of open tables.The original patch can be found here:
http://lists.mysql. com/commits/ 121507
Spurious (C) change in diff lines 19-20.
The patch is OK, but I'll have to ask you to redo it as a GCA involving all three 5.1/5.5/5.6.