MySQL problem

Discussion in 'MySQL' started by siraxi, Apr 10, 2006.

  1. #1
    Hello

    I have a phpbb forum on my website, quite active: about 90 posts/day and >10000 total posts. I was just welcomed by the following message on the blank screen:

    Could anyone please shed some light on why it happened? Too many users online? Is this a reason for crashing? Is it a server-side problem? Should I change hosts? (my webhost is Site5)

    Another question: how often should I backup the forum MySQL database if I am to be a good webmaster?

    Please advise. Thank you!!!
     
    siraxi, Apr 10, 2006 IP
  2. iowadawg

    iowadawg Prominent Member

    Messages:
    10,918
    Likes Received:
    811
    Best Answers:
    0
    Trophy Points:
    380
    #2
    Like too many users according to first line.
    I have a site that once in a while, just too many people connected at one time.
    Go to cpanel, mysql and click repair.
    Usually that resets everything and all is okay until again, too many users.
     
    iowadawg, Apr 10, 2006 IP
  3. mad4

    mad4 Peon

    Messages:
    6,986
    Likes Received:
    493
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Ask your webhost what the maximum number of connections is and ask them to increase it if possible.

    Also make sure your scripts are managing the connections correctly and closing them using mysql_close when they are no longer needed.
     
    mad4, Apr 10, 2006 IP