Announcement

Collapse
No announcement yet.

Mysql Error

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

  • Mysql Error

    MySQL Error : MySQL server has gone awayI keep getting that error every so often via email from VB. I have persistant connections turned off. Thread_cache set at 50 and the wait_timeout set to 15.

    Any feedback would be greatly appreciated.
    Exotic Cars

  • #2
    That wait_timeout is way too low when you consider the default is 28800. The will definitely need to be raised.

    Here are the reasons for the MySQL server going away:

    http://www.vbulletin.com/forum/showt...265#post310265

    Also from the MySQL site:

    http://dev.mysql.com/doc/refman/5.0/en/gone-away.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


    • #3
      The default is somewhat ridiculous, but 15 is too small. We use 300 without any problems.
      Baby, I was born this way

      Comment


      • #4
        I've raised it to 30. From what I read it's better to have it a bit lower when not using persistant connections because it helps the connection close out quicker and let other users join. Is this true?
        Exotic Cars

        Comment


        • #5
          I don't think MySQL needs a different connection for each query/task. But what do I know?

          Comment


          • #6
            We have wait_timeout set to 1800 here. I think 30 is still way too small.
            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


            • #7
              I changed it to 120 and the errors went away. 1800 is too much for my setup I think. The connection is held open for too long causing mysql to open more connections and fill up the thread cache. I don't use persistant, so the shorter timeout helps a lot. Espacially with thread cache!

              Anyway, thanks for the suggestions. 30 was way too low, so was 60, 120 seems to be optimal.
              Exotic Cars

              Comment


              • #8
                ...
                Last edited by CrazyChad; Sat 27 Jan '07, 1:10pm. Reason: aborted

                Comment

                Loading...
                Working...
                X