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.
[...]