Randall,
I setup Sequoia 2.10 with MySQL 4.1 and have found that if I try
to do 1k inserts that it takes approx 130 seconds with Sequoia and
less than 1 second going directly to the DB with native MySQL driver.
I'm using the same driver for the direct test as I've provided to
Sequoia so there's no difference there and also, Sequoia is setup in a
mirror configuration.
How many controllers and databases do you have ?
As your queries have submillisecond execution time on MySQL, assuming
the worst case, that is a single threaded client inserting in the same
table, you will have to pay the full price of the controller overhead on
each query. The average observed overhead is in the 4-6ms range, so the
overall exec time of your test should not exceed 6 seconds.
It is hard to tell why you observe so slow performance. It is certainly
a network or group communication setup problem.
Which group communication are you using?
Does the controller give any warning when the query execute?
Thanks for your interest in Sequoia,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
