1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Site goes offline frequently

Discussion in 'MySQL' started by phd, Sep 3, 2009.

0
  1. #1
    Hi,

    My web server uses apache. Site goes offline frequently, due to Mysql gives error of "Too many connections". I'm able to restart the mysql manually but everytime it is not possible to login to mysql...

    Is there any other solution?
     
    phd, Sep 3, 2009 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Have you checked your logs or process list to see exactly what SQL queries are running that are running so slowly? That's going to be your first step in fixing it.
     
    digitalpoint, Sep 3, 2009 IP
  3. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Check your my.cnf (mysql configuration) via SSH and change max_connections if so required. Alternatively, use caching to stop numerous requests from reaching your database.
     
    premiumscripts, Sep 3, 2009 IP