1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How can i optimize mysql ?

Discussion in 'Troubleshooting and Problems' started by tafreehm, May 26, 2012.

  1. tafreehm

    tafreehm Well-Known Member

    Today, one of my user reported this error. I am only using few plugins.
    TMS
    Sitemap
    Tag system
    vb4 importer
    redirect url
    rotating ad (disabled)

    Here is the screenshot provided by user:
    Untitled.png


    What can I do to prevent this error to occur in future, and optimize forum speed. Few user complain forum running a lil slower.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That error is caused by one of these MySQL settings being exceeded:

    wait_timeout
    max_allowed_packet

    Your host or server person needs to increase these settings in MySQL. There is more info here:

    http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
     
  3. tafreehm

    tafreehm Well-Known Member

    I was running Forum Rebuild Cache.. Do you think that process could have caused this problem ? Because I also, notice while running rebuild cache process each page was loading after 4 to 10 seconds.
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Nope. It's caused by one of those settings being exceeded.
     

Share This Page