Re: MySQL in multi-threaded environment

2007-05-31 Thread Ace
n one time the same query ( perhaps, the mutex on pool->query is enough ) Try to limit mutexes only where it's necessary and be aware where you're locking and unlocking them. Regards, Geoffroy. 2007/5/30, Ace < [EMAIL PROTECTED]>: > > Hi Friends, > > I am

Re: MySQL in multi-threaded environment

2007-05-31 Thread Geoffroy Cogniaux
7;re locking and unlocking them. Regards, Geoffroy. 2007/5/30, Ace <[EMAIL PROTECTED]>: 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 o

Re: MySQL in multi-threaded environment

2007-05-30 Thread Ace
D]> *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

Re: MySQL in multi-threaded environment

2007-05-30 Thread sangprabv
Hi, What is your table engine? AFAIK it is recommended to use InnoDB than MyISAM. Regards Willy - Original Message - From: Ace To: sangprabv Cc: mysql@lists.mysql.com Sent: Thursday, May 31, 2007 11:48 AM Subject: Re: MySQL in multi-threaded environment Thanks! but I

Re: MySQL in multi-threaded environment

2007-05-30 Thread Ace
2: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 req

MySQL in multi-threaded environment

2007-05-29 Thread Ace
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