Yes, I am using InnoDB. On 5/30/07, sangprabv <[EMAIL PROTECTED]> wrote:
Hi, What is your table engine? AFAIK it is recommended to use InnoDB than MyISAM. Regards Willy ----- Original Message ----- *From:* Ace <[EMAIL PROTECTED]> *To:* sangprabv <[EMAIL PROTECTED]> *Cc:* mysql@lists.mysql.com *Sent:* Thursday, May 31, 2007 11:48 AM *Subject:* Re: MySQL in multi-threaded environment Thanks! but I am already using table locks...any other thoughts? Cheers, Rajan On 5/29/07, sangprabv <[EMAIL PROTECTED]> wrote: > > Maybe need to lock the table > > Regards > > > Willy > ----- Original Message ----- > From: "Ace" < [EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Wednesday, May 30, 2007 12:22 PM > Subject: MySQL in multi-threaded environment > > > > Hi Friends, > > > > I am facing problem while using MySQL in multi-threaded environment. I > am > > using C lang for developement. > > > > I maintain MySQL connection pool between threads but with increase in > > number > > of requests, it started reporting > > following errors - > > > > ================================== > > Server Errors: > > Error: 1064 :Parse error > > Error: 1062 :Duplicate entry > > ================================== > > > > Then I used mutexes around MySQL API calls and it worked. But seems > use of > > mutex impacts the performance, is this true? > > > > Any other solution to this than mutex or any out-of-box solution that > > might > > have worked? > > > > Thanks for your help!!! > > > > > > -- > > > > Cheers, > > Rajan > > >
-- I may be miles away... but I am just a mail away.... so keep mailing...!!! Cheers, Rajan
