On Tue, 2008-07-08 at 13:01 +0200, Donovan Francesco wrote:
I have now tried using Tablespace's and created the tables with STORAGE DISK
, which works fine but its awfully slow , compared to 2 mins per operation
in ram , it goes as bad as 20mins per operation!
This is unacceptable , what am I doing wrong , my DATAFILE for my TABLESPACE
is 60GB , is this to big ? What can i do to get more preformance ?
As well as what Jeb has said, I'll add that you also probably want to
increase DiskBufferSize, which is the amount of memory used for caching
pages from data files (i.e. disk data). If this is small, you'll be
doing a lot of IO for each query. Think of it as the NDB version of
innodb_buffer_pool.
3 messages in com.mysql.lists.clusterRe: Cluster preformance
