Re: Very slow SELECT
I have found a problem. When i lanched the Cluster the first time, i forced the 100Mb on the switch. After, i put 'auto' and it was better. But not realy good.
When i lanch super-smack (250 clients, 50 query per client) benchmark with MyISAM, I have +/- 25K query/second (only select), with NDB i have 700 q/s.
I have "engine_condition_pushdown=1" on the my.cf.
I added 2 nodes, and it's the same with super-smack.
And, the Cluster use only 1Mb when i lanch super-smack.
I have "play" with ndb option, and nothing.
Any idea ?
Subject
Views
Written By
Posted
1549
May 25, 2006 01:34PM
1105
May 25, 2006 11:12PM
1077
May 26, 2006 06:43AM
1060
May 26, 2006 06:48AM
1058
May 29, 2006 08:47PM
Re: Very slow SELECT
1215
August 07, 2006 09:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.