+ Reply to Thread
Results 1 to 4 of 4

Thread: mySQL error: Too many Connection

  1. #1
    mumbhaki is offline x10Hosting Member mumbhaki is an unknown quantity at this point
    Join Date
    Sep 2007
    Posts
    24

    mySQL error: Too many Connection

    it seems that more and more people are using my tracker for friendster...

    and also comes this new scalability issue
    mySQL error: Too many Connection

    im just new to php and mysql, can somebody suggest some do's and dont's so that this problem be avoided

    currently the tracker uses atleast 3 sql queries per hit, and will make ajax request(another 3 sql queries) per minute until the visitor leaves the profile...

  2. #2
    Flashgear's Avatar
    Flashgear is offline x10 Lieutenant Flashgear is an unknown quantity at this point
    Join Date
    Jan 2006
    Location
    London, United Kingdom
    Posts
    473

    Re: mySQL error: Too many Connection

    You haven't done anything, its x10 servers, my forum is also displaying the same error message.

  3. #3
    mumbhaki is offline x10Hosting Member mumbhaki is an unknown quantity at this point
    Join Date
    Sep 2007
    Posts
    24

    Re: mySQL error: Too many Connection

    oh, i thought it has something to do with my coding

  4. #4
    rickle42 is offline x10Hosting Member rickle42 is an unknown quantity at this point
    Join Date
    Sep 2007
    Posts
    59

    Re: mySQL error: Too many Connection

    I was wondering about this myself. If you never create a single user on the database (other than admin) how does mysql react if 20 users are making queries? Seems like you would have to create some accounts and assign them to the users. You are saying this is not the case and that it is done for you?
    Edit:
    in addition, maybe youre code could check if connect went through and if not try again in 2 seconds and repeat...I have never dealt with massive trafffic either so i am just guessing
    Last edited by rickle42; 11-22-2007 at 02:13 AM. Reason: Automerged Doublepost

+ Reply to Thread

Similar Threads

  1. [PHP] MySQL and PHP
    By Bryon in forum Tutorials
    Replies: 43
    Last Post: 03-24-2011, 07:27 AM
  2. Allow external connection to MySQL database
    By pedubreuil in forum Free Hosting
    Replies: 3
    Last Post: 10-04-2007, 11:17 AM
  3. mySQL connection problem ! need help please !
    By ked in forum Free Hosting
    Replies: 8
    Last Post: 08-22-2006, 03:43 PM
  4. Replies: 3
    Last Post: 01-26-2006, 05:01 PM
  5. Have a problem with my forum
    By tikloos in forum Scripts & 3rd Party Apps
    Replies: 43
    Last Post: 01-19-2006, 01:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers