Hello,
Controllers: 2 (v2.10)
Database: MySQL 4.1 X 2 Note: One DB and one controller on each
machine, total two machines, same subnet.
Group Communication: Hedera (default that comes with Sequoia v2.10,
correct?)
Controller Warnings: I get one thing, but I think it's only because
of user error:2007-05-02 09:40:50,212 WARN controller.virtualdatabase.SWP_DB Distributed request delete from test did not remove itself from the total order queue That was only because I hadn't created test table yet. Thanks for the help! Randall -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet Sent: Wednesday, May 02, 2007 8:52 AM To: Sequoia general mailing list Subject: Re: [Sequoia] Performance 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
BEGIN:VCARD VERSION:2.1 N:Fidler;Randall FN:Randall Fidler EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20050926T075331Z END:VCARD
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
