Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009

    Unanswered: error 2003 cant connect to mysql server

    I'm getting this error sometime after a couple of transactions have been executed. I have a loop and inside that loop I have a select statement and an insert statement that will run based on the result of the select. Problem is I get the error sometime after a couple of transactions have been executed so I know Im getting connected to the database. It's like the server grew tired and decided to not accept my connection.

    After I get the error I stop for about a minute and try to run the thing again and it'll run just fine until mysql decides it wouldnt accept my connection.

    any ideas guys?? thanks

    Mike from Manila

  2. #2
    Join Date
    Jan 2009
    Are you properly setting transactions?
    uncomment #log_warnings in your my.cnf for further investigation and check max_connections

    better yet can you post your code here?

  3. #3
    Join Date
    Feb 2009
    hi alex

    max connections is currently set to 1000

    its a simple loop really that is now pure
    "insert ignore ...." of about <500k records.

    cant really post the exact code coz its a rather company sensitive data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts