Interesting... Are you using Sequoia to scale your DB reads? Is that how you're getting the improvement of 170 vs 130?
As I said, it's VERY slow when I try to do 1000 inserts, taking over 2 minutes but going directly to the DB takes less than a second. Just for giggles, here's the hardware: Controller and DB running on: Dual Xeon 2GB RAM 833Mhz FSB (might only be 800, who knows!?) Windows 2003 Server I'm hoping it's something stupid I did with the config file but thus far I don't see it. I used the examples that were provided for raidb1 configuration. Thanks, Randall -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Hartung Sent: Wednesday, May 02, 2007 6:51 AM To: [email protected] Subject: Re: [Sequoia] Performance We used to test our environment with JDBCBench. Directly to our DB-Node we get results like ~130 tps. With sequoia we get more than ~170 tps. our environment: Controller: 2x IBM x346 | 64 Bit Java Sun-JDK | 4 GB Ram DB-Node: 2x IBM x445 | 32 - Bit Postgres | 32 GB Ram (don't ask why ;) ) BS: CentOS 4 / 5 special jvm options: -server -d64 -Xms3G -Xmx3G -Xincgc -XX:+UseLargePages And other special Kernel parameter (for example shmmax etc.) This environment isn't productive yet, but it's still fast ;) Randall Fidler schrieb: > Hello, > > 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. > > Any suggestions? I really would like to utilize Sequoia but at the > speeds I'm seeing it's not practical. > > Best regards, > > Randall > > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia _______________________________________________ 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
