Hello,
Believe we finally found the problem with the slow MySQL connections
- NetBIOS. When discovered that the one fast DB node had netBios disabled
and when we disabled it on all the other test nodes, performance went from
25 seconds for 1k inserts to 1 second, same as the 'fast' node.Now, the interesting part is that when we re-enabled NetBios, to ensure that was indeed the problem, the inserts were still fast. The only conclusion that I can come up with is that there was some kind of NetBIOS caching problem with the network that disabling it for the nodes in question seems to have cleared out. So, if you use Server 2003 and your DB runs slow, try disabling NetBIOS. Thanks, Randall P.s. With MySQL v4.1 and later, you have to explicitly enable named pipe usage. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leif Bergman Sent: Thursday, May 03, 2007 9:32 AM To: Sequoia general mailing list Subject: Re: [Sequoia] Performance Randall, Try changing the xml/sequoia.dtd file line: hederaPropertiesFile CDATA "/hedera_jgroups.properties" to look like: hederaPropertiesFile CDATA "/hedera_appia.properties" also, if your server cannot get to the internet, config/appia.xml will need to be changed as it grabs a dtd file from the internet. Hope that helps, Leif On Thu, May 03, 2007 at 09:24:45AM -0700, Randall Fidler wrote: > Nuno, > > How do you change it over? In the install guide it states " > > the hedera_jgroups.properties file points by default to the JGroups > configuration file config/total-token.xml." > > I would guess to point that file to the Appia group comm. properties > file but with the 2.10 installation package, there is not > total-token.xml file in the config directory. > > Thanks, > > Randall > > > > _____ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nuno > Carvalho > Sent: Thursday, May 03, 2007 8:02 AM > To: Sequoia general mailing list > Subject: Re: [Sequoia] Performance > > > Hi Randall, > > you could also try Appia and see how it behaves. > > Cheers, > nuno > > On May 3, 2007, at 3:52 , Emmanuel Cecchet wrote: > > Yes, that confirms what I thought. There is an issue in your Windows > config for local communications. Even though you improved > controller->MySQL configuration with this cross-over, the group > communication still has to go through the local communication channel > for local delivery (this is how JGroups implements it). > I am not a specialist of the Windows networking stack, so I guess now > you'll have to Google for similar network performance issues. You > could also try to post on the JGroups mailing list to see if someone already hit that problem. > > Keep us posted with your progress, > 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 > > > > -- > Nuno Carvalho > University of Lisbon, Portugal > http://dialnp.di.fc.ul.pt > > > > _______________________________________________ > 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
