'Too many connections', 'Database error'

Discussion in 'Site & Server Administration' started by xxMirceaxx, Jun 18, 2008.

0
  1. #1
    I have a vps from smokyhosts.com (I'm moving to wiredtree next month btw...) and I'm getting a daily downtime of about 1-5 hrs...Have any ideas what I can do to improve things, make some optimisations or shit like that? a link pointing to something with idiot proof instructions would be excellent.
     
    xxMirceaxx, Jun 18, 2008 IP
  2. Afazelpoor

    Afazelpoor Guest

    Messages:
    292
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Afazelpoor, Jun 18, 2008 IP
  3. argothiusz

    argothiusz Well-Known Member

    Messages:
    1,500
    Likes Received:
    79
    Best Answers:
    0
    Trophy Points:
    140
    #3
    set max_connection if my.cnf to higher number.
     
    argothiusz, Jun 18, 2008 IP
    xxMirceaxx likes this.
  4. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #4
    I think you have huge queries, maby optimising your database will help improving your server status!
     
    EricBruggema, Jun 18, 2008 IP
    xxMirceaxx likes this.
  5. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #5
    Optimize the settings in my.cnf. That will improve the performance of the server.

    Kailash
     
    kailash, Jun 18, 2008 IP
  6. xxMirceaxx

    xxMirceaxx Well-Known Member

    Messages:
    917
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    135
    #6
    kthxdie

    argothiusz, I tried that before, seemed like it didn't worked.

    EricBruggema, I think so too, however I don't know how to do that.
     
    xxMirceaxx, Jun 18, 2008 IP
  7. Afazelpoor

    Afazelpoor Guest

    Messages:
    292
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Hire a professional to optimize your server/forum, also suggest you get a dedicated server, how much are you paying for the vps?
     
    Afazelpoor, Jun 18, 2008 IP
  8. IwhiC

    IwhiC Peon

    Messages:
    2,594
    Likes Received:
    61
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Raise your max connections for you mysql that should help..optimize your data base, and maybe you will need to get a bigger vps or small dedicated server.. with out seeing any logs or details its hard to say.
     
    IwhiC, Jun 18, 2008 IP
  9. mellow-h

    mellow-h Peon

    Messages:
    750
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Just trying to give you a short tutorial on how to do this:

    Login to your SSH with root first. On the prompt type this:

    nano /etc/my.cnf
    Code (markup):
    Now, if it says nano command not found then only type this:
    yum install nano
    Code (markup):
    This will install nano editor for you and then you can run the first command again. On nano run, it will open a window with my.cnf content inside. Now find this value inside:

    max_connections =
    Code (markup):
    And change this value to a big number you want. After completing the editing, press "CTRL + X", Press y, Press Enter.

    Now simply run this command to affect the changes:

    service mysql restart
    Code (markup):
    If you find this hard to do, download WinSCP and login to your SFTP with root details and browse /etc, now edit my.cnf file and run the mysql restart command to affect the changes.

    Another way this can be done is using your VZ control panel depending on your provider. :) You should find a file manager in your VC control panel which can be used to browse /etc and edit your my.cnf file.

    Good Luck :cool:
     
    mellow-h, Jun 18, 2008 IP
    xxMirceaxx likes this.