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
