gemma hiles

GEMMA HILES free subscription click here

Post Reply 
 
Thread Rating:
  • 33 Vote(s) - 3.27 Average
  • 1
  • 2
  • 3
  • 4
  • 5

Slow Board & "MyBB SQL Errors"

Author Message
dazaman Away
Posting Machine
*****

Posts: 1,439
Joined: Jan 2010
Reputation: 108
Post: #81
RE: Slow Board & "MyBB SQL Errors"
(01-12-2010 00:19 )rover Wrote:  Also

[Image: babeshow430.jpg]

Yep i got that one about a hour ago, took almost a min to get on to this page to write this Sad

http://epetitions.direct.gov.uk/petitions/13222

You can follow me on Twitter
01-12-2010 00:24
Find all posts by this user Quote this message in a reply
gazfc Away
You can't delete truth
*****

Posts: 5,362
Joined: Jun 2010
Reputation: 121
Post: #82
RE: Slow Board & "MyBB SQL Errors"
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@babeshows.co.uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.14 (Unix) mod_ssl/2.2.14 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_fcgid/2.3.5 Server at babeshows.co.uk Port 80
01-12-2010 06:26
Visit this user's website Find all posts by this user Quote this message in a reply
TheWatcher Offline
Ex Moderator
*****

Posts: 10,497
Joined: Nov 2008
Reputation: 221
Post: #83
RE: Slow Board & "MyBB SQL Errors"
Not seen this one before, 6.15pm tonight, 800 users
Did not see it again and no speed problems at this time for me

[Image: 2010_12_01_181322_609x218_scrot.png]
01-12-2010 18:17
Find all posts by this user Quote this message in a reply
aceman65 Offline
Cappers Union
*****

Posts: 5,258
Joined: Nov 2009
Reputation: 173
Post: #84
RE: Slow Board & "MyBB SQL Errors"
I think, quite a few of us have been getting something similar to that, over the past few days. Sad

But I haven't quite seen that configuration of it before. bladewave

And the speeds fine for me as well at present. Big Grin
(This post was last modified: 01-12-2010 19:06 by aceman65.)
01-12-2010 19:03
Find all posts by this user Quote this message in a reply
admin. Offline
Administrator
*******

Posts: 9,242
Joined: Jul 2008
Post: #85
RE: Slow Board & "MyBB SQL Errors"
(28-11-2010 23:27 )aceman65 Wrote:  since we hit the favorite 22:00 - 02:00 slot, it's been horrendous.

I just keep getting this 10% of the time, during those hours.
[Image: mybbsql01.jpg]

Thanks to aceman65 for reporting this problem (post 206), and thanks also to mucker (191), Sooky™ (195), Chilly (207) and quiquems (217) who reported the problem too. The cause of the error was a large number of requests to the database to provide the (long) listing of members who have been online in the last 24 hours.

There are 2 issues here, firstly that the list has got so long now, sometimes going to over 2,600 names and it's therefore a drain on the database to keep providing it, but more importantly that being on the index page it was being requested all the time, over and over again and the database was struggling to keep up. The index page is the most visited page in the forum and at busy times can be loaded about twice every second, so the database was being asked to churn that list out like crazy.

I've addressed the problem by moving this feature off the index page and putting it on the forum stats page. Anyone who wants to see this feature can therefore still access it, as it's working exactly the same as it was before, with the information just being displayed in a different location now, but the list won't be generated about 70,000 times every day like it was before. When the error message reported by the 5 people above occurred, the database was effectively refusing to produce the online today list for them, as the number of requests for the index page at the time the error messages were seen was close to 150 a minute.
01-12-2010 19:14
Find all posts by this user Quote this message in a reply
aceman65 Offline
Cappers Union
*****

Posts: 5,258
Joined: Nov 2009
Reputation: 173
Post: #86
RE: Slow Board & "MyBB SQL Errors"
Thanks Admin for the explanation. But can you explain why I keep getting messages like this one on Elites index page?

[Image: mybbsql02.jpg]

And Also similar messages, but with slightly different configurations, on other index pages!!!
(This post was last modified: 01-12-2010 20:37 by aceman65.)
01-12-2010 20:36
Find all posts by this user Quote this message in a reply
gazfc Away
You can't delete truth
*****

Posts: 5,362
Joined: Jun 2010
Reputation: 121
Post: #87
RE: Slow Board & "MyBB SQL Errors"
Had a few tonight

Had this one after I clicked on the deselected quote after antecedently clicking the quote button on a post

[Image: hannah_martin_26_11_10.png]

Then when I was trying to get back on the forum i got these two along with a 503 server error

[Image: n1_105_thumb.jpg] [Image: 25n_thumb.jpg]
Image Hosting Provided By: ImageChunk
01-12-2010 23:18
Visit this user's website Find all posts by this user Quote this message in a reply
mucker Offline
Posting Machine
*****

Posts: 3,264
Joined: Nov 2009
Reputation: 145
Post: #88
RE: Slow Board & "MyBB SQL Errors"
Got the following error messages around 22:50 and was unable to get back on the board for approx 15/20 mins.
[Image: 2010_12_01_225131.jpg] [Image: 2010_12_01_231315.jpg]
01-12-2010 23:21
Find all posts by this user Quote this message in a reply
admin. Offline
Administrator
*******

Posts: 9,242
Joined: Jul 2008
Post: #89
RE: Slow Board & "MyBB SQL Errors"
Thanks for your report, mucker. This problem was due to some action taken by the host, who were adjusting some settings in order to try and give the forum better performance and eliminate the error messages we've been getting recently. Unfortunately the change they were making caused an effective outage of 17 minutes.
01-12-2010 23:29
Find all posts by this user Quote this message in a reply
rover Offline
.
*****

Posts: 6,307
Joined: Sep 2008
Reputation: 179
Post: #90
RE: Slow Board & "MyBB SQL Errors"
this one's so long it cant fit on the page.

[Image: babeshow516_102.jpg]

Do not walk behind me, for I may not lead. Do not walk ahead of me, for I may not follow. Do not walk beside me,either. Just leave me alone.
01-12-2010 23:33
Find all posts by this user Quote this message in a reply
Post Reply 



GEMMA HILES free subscription click here

gemma hiles