Slow Board & "MyBB SQL Errors"

Slow Board & "MyBB SQL Errors" - Printable Version

+- The UK Babe Channels Forum (https://www.babeshows.co.uk)
+-- Forum: General (/forumdisplay.php?fid=19)
+--- Forum: Information On This Website & Help (/forumdisplay.php?fid=103)
+---- Forum: Forum Help & Advice (/forumdisplay.php?fid=91)
+---- Thread: Slow Board & "MyBB SQL Errors" (/showthread.php?tid=15660)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

RE: Slow Board & "MyBB SQL Errors" - dazaman - 01-12-2010 00:24

(01-12-2010 00:19 )rover Wrote: Also

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

RE: Slow Board & "MyBB SQL Errors" - gazfc - 01-12-2010 06:26

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

RE: Slow Board & "MyBB SQL Errors" - TheWatcher - 01-12-2010 18:17

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]

RE: Slow Board & "MyBB SQL Errors" - aceman65 - 01-12-2010 19:03

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

RE: Slow Board & "MyBB SQL Errors" - admin. - 01-12-2010 19:14

(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.

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.

RE: Slow Board & "MyBB SQL Errors" - aceman65 - 01-12-2010 20:36

Thanks Admin for the explanation. But can you explain why I keep getting messages like this one on Elites index page?

And Also similar messages, but with slightly different configurations, on other index pages!!!

RE: Slow Board & "MyBB SQL Errors" - gazfc - 01-12-2010 23:18

Had a few tonight

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

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

Image Hosting Provided By: ImageChunk

RE: Slow Board & "MyBB SQL Errors" - mucker - 01-12-2010 23:21

Got the following error messages around 22:50 and was unable to get back on the board for approx 15/20 mins.

RE: Slow Board & "MyBB SQL Errors" - admin. - 01-12-2010 23:29

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.

RE: Slow Board & "MyBB SQL Errors" - rover - 01-12-2010 23:33

this one's so long it cant fit on the page.