MySQL Forums
Forum List  »  NDB clusters

Bad performance?
Posted by: Jacob Christensen
Date: December 06, 2004 06:33PM

Hi all,

I just put up a small test setup, but the performance is really slow!

Only one DB node and 2 API's. On 2 x dual xeon 2,8 with 2 Gb RAM and 1 Gbit eth. (4.1.7 binery linux) The DB node is on COM1 and API's on COM2.

With only 5-6 q/s - 95% select to a simple table. Select time is 0,3-0,8 sec. Load is also very high on DB node considering so few q/s. The trafic between DB and API is 5-8 Mb per sec. Almost all the trafic is comming from the API to the DB nodes. This is very simple selects and updates, so sounds really wird to me???

Table looks like this with 400000 rows:
CREATE TABLE `cologin` (
`id` int(10) unsigned NOT NULL auto_increment,
`k_id` int(4) unsigned NOT NULL default '0',
`user` varchar(32) NOT NULL default '',
`sig` enum('y','n') NOT NULL default 'n',
`unixtimestamp` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `kampagne_id` (`kampagne_id`),
KEY `brugernavn` (`brugernavn`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 AUTO_INCREMENT=392152 ;

With MyISAM is is super fast on the same machines.

Typical select:

SELECT * FROM cologin WHERE user='XXXX' and sig='XXXX'; Very Simpel :-)

Any Ideas???

Best Regards,
Jacob

Options: ReplyQuote


Subject
Views
Written By
Posted
Bad performance?
4065
December 06, 2004 06:33PM
2799
December 06, 2004 09:13PM
2752
December 07, 2004 07:18AM
2569
December 07, 2004 11:58AM
2775
December 07, 2004 01:19PM
3632
December 07, 2004 06:22PM
2665
December 08, 2004 01:33PM
3545
December 08, 2004 02:44PM
2752
December 09, 2004 10:05AM


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.