From: Mattias Jonsson
Date: November 19 2010 1:26pm
Subject: Re: bzr commit into mysql-next-mr-bugfixing branch (magne.mahre:3328)
 Bug#49177
List-Archive: http://lists.mysql.com/commits/124442
Message-Id: <4CE67AEC.70600@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Svoj,

On 2010-11-19 13.45, Sergey Vojtovich wrote:
> Hi Magne,
>
> taking into account "WL#4305 - storage-engine private data area
> per physical table", do you think we still should proceed with
> this fix?
>
> Mattias: is there any ETA for WL#4305?

FY11 at least. Will probably not be considered for 5.5, only 5.6+.

Regards Mattias

> Regards,
> Sergey
>
> On Thu, Oct 21, 2010 at 10:52:02AM +0000, Magne Mahre wrote:
>> #At file:///export/home/tmp/x/mysql-next-mr-bugfixing-49177/ based on revid:anitha.gopi@stripped
>>
>>   3328 Magne Mahre	2010-10-21
>>        Bug#49177 MyISAM share list scalability problems
>>
>>        (Note: MyISAM issue only)
>>
>>        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.

[...]