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 >