• 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 ?

tafreehm

Well-known member
#1
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.
 

tafreehm

Well-known member
#3
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
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.
 

Jake Bunce

XenForo moderator
Staff member
#4
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.
Nope. It's caused by one of those settings being exceeded.