Register    Login    Forum    Search    FAQ

Board index » Site info » Site Info




 Page 1 of 1 [ 3 posts ] 



Author Message
 Post subject: MySQL errors
 Post Posted: Mon May 22, 2017 1:13 pm 
Offline
Site Admin
User avatar

Joined: Sat Jul 31, 2010 1:53 pm
Posts: 87
You may be seeing intermittent MySQL connection issues here of late. It looks like we are hitting the maximum number of simultaneous connections for the database. I suspect a good part of the reason for this is the size of the database: we're just shy of 390,000 posts and about 4.5 million words in the word match table. [update: I've also disabled search access for guest users. No real reason they should be doing that. And blocked some Russian and Chinese search-engine spiders. S'ok, shoe, not blocked all Chinese IP addresses!]

As a first step, I'll be doing some late-night optimization of the tables, and also looking at slowing down search engine crawlers like Bing and Google, as they can seriously hammer a site by making a lot of simultaneous connections. That may help speed things up and reduce the load. If that doesn't fix the problem, then it'll probably be time for a "reset". Long-time members may remember, we did this in July 2010: moving the current forum and all its contents to an "archive" subdomain, freezing it, and then opening up a new, fresh board.

Stay tuned...


Top 
 Post subject: Re: MySQL errors
 Post Posted: Mon May 22, 2017 3:51 pm 
Offline
User avatar

Joined: Sat Jul 31, 2010 4:29 pm
Posts: 7047
Location: Tucson
Thank you for all you do. (and AOG)

_________________
Per Mare, Per Terras
KC
30


Top 
 Post subject: Re: MySQL errors
 Post Posted: Wed May 24, 2017 3:32 pm 
Offline
User avatar

Joined: Sat Jul 31, 2010 4:29 pm
Posts: 7047
Location: Tucson
During the current GDT, all other forums seem to be fine, nut I keep getting this error when clicking on the GDT forum over the last 20 minutes or so.

_________________
Per Mare, Per Terras
KC
30


Top 
Display posts from previous:  Sort by  
 
 Page 1 of 1 [ 3 posts ] 




Board index » Site info » Site Info


Who is online

Users browsing this forum: No registered users and 1 guest

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: