lp://staging/~vlad-lesin/percona-server/5.6-bug-1038940-table_cache_speed_up

Branch merges

Propose for merging

No branches dependent on this one.

On hold for merging into lp://staging/percona-server/5.6

Laurynas Biveinis (community): Needs Fixing on 2013-03-25

Diff: 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)

api

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Bug #1038940: table_open_cache increasing leads to performance regression

Medium

Triaged

Link a bug report

Related blueprints

317. By Vlad Lesin on 2013-02-24

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

316. By <email address hidden> on 2013-02-20

Merge lp:~hrvojem/percona-server/ps-24

315. By <email address hidden> on 2013-02-19

Merge lp:~stewart/percona-server/5.6.10

314. By Stewart Smith on 2013-02-19

re-commit BAlexey's fix for:

fixed bug 1103328, added --valgrind option for build and cmake error if valgrind required, but devel files not installed. changed tarball name appropriately

(i had to recommit due to inadvertant 5.1 and 5.5 merge to 5.6)

313. By <email address hidden> on 2013-02-07

Merge lp:~laurynas-biveinis/percona-server/bug1100178-5.6

312. By <email address hidden> on 2013-02-05

Merge lp:~sergei.glushchenko/percona-server/56-tp

311. By <email address hidden> on 2013-02-05

Merge lp:~sergei.glushchenko/percona-server/56-expand_fast_index_creation

310. By <email address hidden> on 2012-12-17

Merge lp:~stewart/percona-server/5.6.8

309. By <email address hidden> on 2012-12-07

Merge lp:~stewart/percona-server/5.6-null-merge-doublewrite

308. By Stewart Smith on 2012-10-29

merge MySQL 5.6.7