MySQL Forums
Forum List  »  NDB clusters

MySQL cluster speed
Posted by: Rytis Sileika
Date: October 12, 2004 06:51AM

Finally got MySQL cluster running. Here's my configuration:

Host1:
MGM+DB

Host2:
DB+API

(I need only one access point, hence 1 API instance)

Here are some ./test-insert (from sql-bench/) results:

Both DB nodes are active:
---
Inserting 100000 rows in order
Inserting 100000 rows in reverse order
Inserting 100000 rows in random order
Time for insert (300000): 413 wallclock secs (12.49 usr 5.54 sys + 0.00 cusr 0.00 csys = 18.03 CPU)
---
One DB node is active:
---
Inserting 100000 rows in order
Inserting 100000 rows in reverse order
Inserting 100000 rows in random order
Time for insert (300000): 188 wallclock secs (12.42 usr 5.61 sys + 0.00 cusr 0.00 csys = 18.03 CPU)
---
MySQL is writing to a local disk:
---
Inserting 100000 rows in order
Inserting 100000 rows in reverse order
Inserting 100000 rows in random order
Time for insert (300000): 53 wallclock secs ( 8.86 usr 4.61 sys + 0.00 cusr 0.00 csys = 13.47 CPU)
---

Any ideas why it is so slow???
(both hosts have 2GB memory, so shouldn't be a problem, NDB is told to use 512MB for a DB and 64MB for indexes)

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL cluster speed
4794
October 12, 2004 06:51AM


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.