Let me amend that, MySQL is setup out of the box with the exception of using InnoDB engine.
Thanks, Randall -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Hartung Sent: Wednesday, May 02, 2007 8:03 AM To: [email protected] Subject: Re: [Sequoia] Performance Yes, we use Sequoia to scale our reads and to create an active-active cluster environment. I think that the balancing is the point of this fast results. Some questions: - Which jdk do u use? - 32 Bit or 64 Bit 2003 Server? - Did you configure your mysql correctly? Maybe you can tune the backends (we tuned postgres a lot) - Are u using special options for the jvm? ... sounded very very slow :( so far, chris Randall Fidler schrieb: > 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 > > _______________________________________________ > 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
