Re: MySQL in multi-threaded environment

[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 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
    >