#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    58
    Rep Power
    15
    I had the "Too many MySQL connections" error on a page that is password protected to 150 users, and it uses one simple table and a simple SELECT * FROM table.
    The site wasn't launched or noticed, so all 150 users can't hit it at the same time.

    What can cause this upsetting error?

    ------------------

    peterbe.com
  2. #2
  3. No Profile Picture
    ledjon
    Guest
    Devshed Newbie (0 - 499 posts)
    If your on a virual host it may have been being accessed by other people on other sites (just a guess).
  4. #3
  5. No Profile Picture
    Dave Bryant
    Guest
    Devshed Newbie (0 - 499 posts)
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by ledjon:
    If your on a virual host it may have been being accessed by other people on other sites (just a guess).[/quote]

    Are you using persistent connections? ie. pconnect

    Or perhaps you're not closing your tables when the script finishes. Do an explicit close on all variable and tables and flush the db every so often.

    ------------------
    --Dave Bryant
    dbryant@jump.net
    dbryant@waterloobay.com
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    45
    Rep Power
    15
    Ok, weirdest thing happened to me too, right after reading this topic - I got the same error (too many connections). I never used pconnect, so I know that's not the problem. When anyone care to explain what a) flush does and b) how mySQL counts the number of connections (are they considered opened if you never called mysql_close) ? I actually never did use mysql_close because I never thought that it had a use (coming back to haunt me apparently). Anyway, anyone know how to combat this problem without flushing since I can't even access MySQL from command line. Thank in advance.

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. Starting MySQL
    By bwreath in forum MySQL Help
    Replies: 1
    Last Post: January 21st, 2004, 12:17 AM
  3. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 01:35 PM
  4. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 01:27 AM

IMN logo majestic logo threadwatch logo seochat tools logo