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.
    Tag system
    vb4 importer
    redirect url
    rotating ad (disabled)

    Here is the screenshot provided by user:

    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:


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

  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