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.

What is wrong with my server? Please help!

Discussion in 'MySQL' started by TheSyndicate, Nov 22, 2005.

  1. #1
    Warning: mysql_connect(): Lost connection to MySQL server during query in /home/sendsmsh/public_html/conn.php on line 53
    Lost connection to MySQL server during query

    I got this every sunday and before and my server went down. When i gave a TT to the customer support (in india when the support is down in us) they say that the server is up?

    I understand that they mean YES the server is up but Msql does not work since 99 % of my websites is based on php its down.

    The problem is i had Adword and i loose money when the servers are down.

    What is this problem above and why is it comming back? I asked one guy he said i had a leack in my databse or some tag not closed?
     
    TheSyndicate, Nov 22, 2005 IP
  2. ozegreatdeals

    ozegreatdeals Peon

    Messages:
    326
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Do your sites use alot of mysql resources, as it could simply be that the mysql server is overloaded with request so it had to drop some to prevent it from shutting down completly.

    I host a couple of php driven scripts and occasionaly if the table in the database is not editted correctly it will excessively use mysql resource and cause mysql driven sites not to load or errors similar to this.

    I know a little about php and mysql myself but it looks like what he said is correct:
    Drew.
     
    ozegreatdeals, Nov 23, 2005 IP
  3. TheSyndicate

    TheSyndicate Prominent Member

    Messages:
    5,410
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    365
    #3
    Does anybody know how to check this problem? A "leakometer?" or something? Is there a free website or software that check this?:eek:
     
    TheSyndicate, Nov 23, 2005 IP
  4. J.D.

    J.D. Peon

    Messages:
    1,198
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    0
    #4
    It sounds that something is being restarted/rebooted periodically. Is your MySQL server running on the same machine as Apache? If that's the case, then MySQL may be restarted (e.g. if it consumes the maximum allowed amount of memory, etc). If not, MySQL may be running, but not accessible to Apache/PHP.

    J.D.
     
    J.D., Nov 23, 2005 IP
  5. TheSyndicate

    TheSyndicate Prominent Member

    Messages:
    5,410
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    365
    #5
    3 sundays in a row but then it stopped and today the same problem came back. We have 10 databases on the same domain name but i can not belive that is the problem. Is there anyway to check if the msql is wrong with some script or something?:confused:

    And it does not restart it just shut down the msql but all html pages are up the few i have.
     
    TheSyndicate, Nov 23, 2005 IP
  6. J.D.

    J.D. Peon

    Messages:
    1,198
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Is MySQL running on the same machine as your web server?
     
    J.D., Nov 23, 2005 IP
  7. TheSyndicate

    TheSyndicate Prominent Member

    Messages:
    5,410
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    365
    #7
    Everything is hosted in US i have Cpanel.
     
    TheSyndicate, Nov 23, 2005 IP
  8. J.D.

    J.D. Peon

    Messages:
    1,198
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    0
    #8
    That's not what I'm asking. Is your MySQL server (the program) running physically on the same machine as your web server (the program)?
     
    J.D., Nov 23, 2005 IP
  9. TheSyndicate

    TheSyndicate Prominent Member

    Messages:
    5,410
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    365
    #9
    yes they do
     
    TheSyndicate, Nov 23, 2005 IP
  10. J.D.

    J.D. Peon

    Messages:
    1,198
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    0
    #10
    J.D., Nov 23, 2005 IP
  11. TheSyndicate

    TheSyndicate Prominent Member

    Messages:
    5,410
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    365
    #11
    I will check it outif anyone have anymore bright ideas please tell me :)
     
    TheSyndicate, Nov 24, 2005 IP