Results 1 to 4 of 4

Thread: raising max_user_connections?

  1. #1
    Join Date
    Feb 2007
    Location
    Earth
    Posts
    133
    Thanks
    6
    Thanked 1 Time in 1 Post

    Default raising max_user_connections?

    Ok so I am constantly having people tell me they are getting an error saying something about exceeding the max user connections. This is because when I first made my website I did not know about closing connections properly, so there are just wayyy too many connections I would have to close in coding for it to be worth my time. Right now, using Byethost, their MySQL server allows up to 10 max_user_connections. I want to get a new server so I can start having many people online at once, at least 50, but there is no way for me to raise the max connections since the MySQL server belongs to Byethost. Is there a website where I can buy into a MySQL server allowing more max_user_connections, or do I have to own my own MySQL server (gosh that would be costly). I am pretty sure I read something about using a VPS for MySQL but I am not quite sure about how all of this goes together. I wish I could just buy more max_user_connections to make it easy for me... All I want to do is raise my max_user_connections, however it can be done. Anyone have any info on that for me?
    http://www.insanecombat.com << bored? check out ma game

  2. #2
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,643
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

    you might be able to do so using a php.ini file, though your host can still override this (and most do). It would be much better to clean out your code, especially if you're moving to a new server anyway - having too many open connections can seriously affect performance.

  3. #3
    Join Date
    Feb 2007
    Location
    Earth
    Posts
    133
    Thanks
    6
    Thanked 1 Time in 1 Post

    Default

    no go on the php.ini... its nowhere to be found so i cant edit it

    editing this code would take way too much time... i doubt i could even find all of the spots where i would have to close the connections
    http://www.insanecombat.com << bored? check out ma game

  4. #4
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,643
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

    if you can't find php.ini:

    a) you don't have one yet; create one. there are plenty of tutorials out there.
    b) your host doesn't allow you to use it (quite possible).

    Most text editors have a "search" function that would help you find every instance where you open a DB connection.

Bookmarks

Posting Permissions

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