MySQL cluster speed
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)
Subject
Views
Written By
Posted
MySQL cluster speed
4793
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.