Register    Login    Forum    Search    FAQ

Board index » Site info » Site Info




 Page 1 of 1 [ 5 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: 89
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: 7493
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: 7493
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 
 Post subject: Re: MySQL errors
 Post Posted: Mon Jul 10, 2017 8:19 am 
Offline
User avatar

Joined: Sat Jul 31, 2010 4:27 pm
Posts: 11782
So it looks like the issue is with Google Chrome right now.

I can access site with my iPhone and ipad no problem. And I am using Internet Explorer on m laptop right now to access site and type this message.

However when I use my Chrome browser on my laptop, I get SQL error and cannot access site.

Justin was saying he could get in on his phone but not his laptop.

Justin if you happen to see this, please let us know what Browser you are using.

Thanks
Shoe

_________________
trading young number one over all talent for back end of the rotation talent was fundamentally irresponsible. BFDD


Top 
 Post subject: Re: MySQL errors
 Post Posted: Mon Jul 10, 2017 2:49 pm 
Offline
User avatar

Joined: Sat Jul 31, 2010 4:29 pm
Posts: 7493
Location: Tucson
shoewizard wrote:
Justin was saying he could get in on his phone but not his laptop.

Justin if you happen to see this, please let us know what Browser you are using.

Thanks
Shoe


I use Chrome. I have Firefox too, but never use it and didn't think to test it. The strange thing is the phone/desktop thing only lasted 2 or 3 days. I am typing this on the computer.

_________________
Per Mare, Per Terras
KC
30


Top 
Display posts from previous:  Sort by  
 
 Page 1 of 1 [ 5 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: