Announcement

Collapse
No announcement yet.

MySQL Crashing Frequently

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Crashing Frequently

    For about the past 3 weeks, my server has been plagued with MySQL errors. The server seemingly crashes more than twice a day and it down for about 8 hours / day average. The technical support team at my webhost (forsite.com) has told me that my website is causing the errors.

    Tom, of Forsite.com told me "your site IS the reason that mysql keep crashing on your server -your scripts open a session but do not close themselves causing the server to have troubles - we are asking you to move your site to another host so you can verify this as well with them"

    Server Info:
    PHP Version 4.0.6
    URL: http://www.paintball-forum.com/forum/

    Here is the most frequent error message:

    Database error in vBulletin :Link-ID == false, connect failedmysql error: Too many connectionsmysql error number: 1040

    I have also noted a couple other errors...

    Database error in vBulletin 2.2.6:Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=5208 ORDER BY dateline DESC LIMIT 1mysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/search.phpReferer: http://www.paintball-forum.com/forum/search.php?s=

    and

    Database error in vBulletin Control Panel 2.2.6:Invalid SQL: SELECT * FROM searchmysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/admin/backup.phpReferer: <A href="http://www.paintball-forum.com/forum/admin/backup.php">http://www.paintball-forum.com/forum/admin/backup.php

    How can I fix these errors? I have just now diabled the search function, thinking it may be a part of it. Why would the forum connect but not disconnect from the mysql server as forsite.com suggests? I have persistent connections set to 1, but also got the same errors when I tried setting persistent connections to 0.

  • #2
    First of all, your host really should upgrade PHP. They are runnng a badly outdated and buggy version.

    Second, the server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off in your config.php:

    PHP Code:
    // use persistant connections to the database
    // 0 = don't use
    // 1 = use
    $usepconnect 0
    But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow. It's also possible that your site is just too busy for a shared server.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thanks Steve.

      Okay... I have another question.

      I have bought a new account at VenturesONline.com V500 (500 mb space). I know a lot of guys recommend them so I need to move my info to their server. Do you guys (vbulletin) offer server transfer services? I am assuming the standard $150 would be the charge. Please let me know.

      Thanks

      Mark

      Comment


      • #4
        Actually we do not have an official transfer server. However moving servers is easy to do if you have shell access (telnet or ssh) at both server. The instructions are here:

        http://www.vbulletin.com/manual/movingservers.html
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Originally posted by Steve Machol
          Actually we do not have an official transfer server. However moving servers is easy to do if you have shell access (telnet or ssh) at both server. The instructions are here:

          http://www.vbulletin.com/manual/movingservers.html
          Unfortunately I don't know anything about telnet or SSH. I am really more of a buisness operator than a webmaster. Do you know of anyone who would be able to offer this service?

          Comment


          • #6
            Originally posted by LCD_Angel
            Unfortunately I don't know anything about telnet or SSH. I am really more of a buisness operator than a webmaster. Do you know of anyone who would be able to offer this service?

            LCD, I just sent you an email through the board, I can help you. Let me know.

            Jason.

            Comment

            Loading...
            Working...
            X