Re: MySQL in multi-threaded environment

2007-05-31 Thread Ace
Thanks Geoffroy! I will check this and let you know if problem persists. -- Cheers, Rajan On 5/31/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote: Hi, Assuming that you are using a multithread safe libmysql, I suggest you to have a look at your error code first: Error code 1064 suggests that yo

Re: MySQL in multi-threaded environment

2007-05-31 Thread Geoffroy Cogniaux
Hi, Assuming that you are using a multithread safe libmysql, I suggest you to have a look at your error code first: Error code 1064 suggests that you send a bad query to mysql, maybe your pool->query isn't indeed MT safe, so manipulating this variable requires a mutex. Error code 1062 suggests tha

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
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: Sent: Wednesday, May 30, 2007 12:22 PM Subject: MySQL