Re: Disk-based table performance - Kenji HIROHAMA - com.mysql.lists.cluster

9 messages in com.mysql.lists.clusterRe: Disk-based table performance

From	Sent On	Attachments
Kenji HIROHAMA	13 May 2008 22:31
Mikael Ronström	13 May 2008 23:40
Kenji HIROHAMA	14 May 2008 18:34
Mikael Ronström	15 May 2008 00:30
Kenji HIROHAMA	15 May 2008 01:57
Moon's Father	19 May 2008 23:56
Ivan	20 May 2008 01:27
Kenji HIROHAMA	20 May 2008 05:14
Stewart Smith	24 May 2008 04:39

Subject:	Re: Disk-based table performance
From:	Kenji HIROHAMA (kenj...@gmail.com)
Date:	05/14/2008 06:34:34 PM
List:	com.mysql.lists.cluster

Hello Mikael,

Thanks for your information, and would you please tell me that parameter name?

Thanks, Kenji

On Wed, May 14, 2008 at 3:41 PM, Mikael Ronström <mik...@mysql.com> wrote:

Hi Kenji, There is already a cache for the disk-based tables. It's only a matter of setting it big enough. It's a normal config parameter and I think it is something like 64 MByte by default so you need to increase it always in much the same way as you always need to set DataMemory.

Rgrds Mikael

14 maj 2008 kl. 07.31 skrev Kenji HIROHAMA:

Hello,

With MySQL Cluster 5.1.23, disk-based table is much slower than memory-based table.

http://hirohama.wordpress.com/2008/05/14/mysql-cluster-5123-disk-based-vs-memory-based-table/

Of course, accesing the pysical disk cause the bad performance, but is there any plan to have "buffer" or "cache" mechanism in the future CGE or MySQL Cluster release to increase throughput with disk-based table access?

Thanks,