MetaPost comments and questions about the messageboards and other parts of EN World. If you have a problem, this is where to go. Moderator email addresses are posted here.
Iwas wondering if anyone else is noticing that ENWorld is really slow to load at first. I'm using IE 7 (I believe). No other websites I visitare slow, but when I want to come and visit ENWorld I can go make a pot of coffee before the page loads. [Not kidding] Just wondering if I'm the only one or not. If Iam the only one, an ideas why?
I should also say that once it does load it navigates fairly well. Perhaps a little slow, but nothing like the first page.
Anyway, thanks for your time.
NLF
__________________ Most recent products published:
Complete Control - Turn your 3.x game into a game without multiclassing, or classes for that matter! Make your character exactly how you want it.
Complete Gear - Eliminate item issues in your gaming. NPCs can have any gear without impacting game balance. Magic Marts don't need to even exist!
I have IE 7 and what you're describing has happened to me. Usually what happens is that the site takes a while to load at first but then it moves along fairly well after that.
However, if I step away from my PC for some reason and then come back to it, then I have a heck of a time getting it to load again.
It is almost like it gets stuck. I usually have to close my browser, reload it and then visit other sites for 15 to 20 minutes before I can get EN World to load again. I'm not sure what to make of it since it almost always comes back.
And note that this isn't always during the "heavy traffic" times of day. Well, not unless you consider 10pm to 1am MST to be a "heavy traffic" time period.
It's frustrating.
__________________ Robert Blezard I write; therefore, I am!
D&D v.3.5, d20 Modern, OSRIC, Pathfinder, True20... OGL Forever! Walk the Road
Avatar by Sialia
MySQL is getting overloaded and resetting itself on 4-6 hour intervals. Looking for a solution.
That would explain a lot. Let us know how this situation develops.
FYI...
For me, it's 3 a.m., and I'm definitely getting some lag. It is loading, and I can post but it takes a while, especially when posting on the blogs.
__________________ Robert Blezard I write; therefore, I am!
D&D v.3.5, d20 Modern, OSRIC, Pathfinder, True20... OGL Forever! Walk the Road
Avatar by Sialia
Darn. I just got on and it took no time to load. I came right here to tell about my victory and then the log-in page took forever. But, at least it was a different page to load slowly.
Sorry I couldn't give you all the good news and compliments I had hoped to give.
__________________ Most recent products published:
Complete Control - Turn your 3.x game into a game without multiclassing, or classes for that matter! Make your character exactly how you want it.
Complete Gear - Eliminate item issues in your gaming. NPCs can have any gear without impacting game balance. Magic Marts don't need to even exist!
I've gotten into the habit of having a sudoku window open in another tab. I click a page on EN World, wait a moment, and if it doesn't load immediately I switch to sudoku and wait. I'm not sure why my browser is willing to wait that long, but sometimes I think it can take 5 minutes or more for pages to load.
__________________ Adventure is not outside; it is within. --Found in a fortune cookie on game night
Strangely I think I'd be okay with having a PC die by a bear exploding out of his head. --Awayfarer, after having his PC put a furry ball from a Bag of Tricks into his mouth.
Cool. I'll try punishing it for a while and let you know my results.
__________________ Robert Blezard I write; therefore, I am!
D&D v.3.5, d20 Modern, OSRIC, Pathfinder, True20... OGL Forever! Walk the Road
Avatar by Sialia
Things seem better. I upped the max connections from 100 to 1000 and the keepalive timeout from 2 seconds to 4. I had lowered them because I thought they where bogging the machine down.
Things seem better. I upped the max connections from 100 to 1000 and the keepalive timeout from 2 seconds to 4. I had lowered them because I thought they where bogging the machine down.
It seems to be working a little bit better. I lost one post to the lag and had to reload my browser once while trying to switch between pages in one thread, but it seems to be running better, so far.
I'm going to punish the blogs a bit next and then check out the front page of the site. I haven't checked it in a while because of the lag.
Cheers!
KF72
__________________ Robert Blezard I write; therefore, I am!
D&D v.3.5, d20 Modern, OSRIC, Pathfinder, True20... OGL Forever! Walk the Road
Avatar by Sialia
Did anyone change something, because currently the boards run smoothly half the time and the other half it's taking like forever to do something.
Mike said above that MySQL is resetting itself. I believe that what might be happning is that most of the time the boards run fine, very fast, and then MySQL will reset which causes pages to slow down to nothing.
So I think at this piont EN World is either speedy or gone.
__________________ Adventure is not outside; it is within. --Found in a fortune cookie on game night
Strangely I think I'd be okay with having a PC die by a bear exploding out of his head. --Awayfarer, after having his PC put a furry ball from a Bag of Tricks into his mouth.
I have backed up the databases and changed the mysql settings, nearly quadrupling the allocated memory to mysql processes and bumping the concurrect mysql connection count from 650 to just over 2000. We're either going to be fine or the machine is going to melt a hole in the floor at about 1 PM tomorrow
Well, I doubt it will do that - but it could crash and crash hard, such is the reason for the database backups taken this evening. We'll see.
I'm sorry to report that site performance for me (Firefox 3 from the UK) is getting worse, not better.
Edit: The weird thing is it's so erratic. I can clink a link at one moment and it loads lightning fast... two minutes later I'll click another and it can take literally minutes to load... then five minutes later I'll open 5 in a row in FF tabs and they all load almost immediately... ten minutes later, another slow one, and so-on.
__________________ "The last time I ran into myself, I kicked my own ass." Chasing the DM, a blog for DM's like me who really feel they should know what they're doing by now.
For DM's: 4E Dungeon Index (adventures, conversions, and sidetreks by level, last updated 16th Oct. through Dungeon #171).
Last edited by wedgeski; 16th July 2008 at 11:15 PM..
I haven't seen much of a change myself (FF3, if it maters). The site still seems to work fine for a while, then it'll seem to completely stop responding for a few minutes, at which point I usually go do something else until I see that my EN World tab has lost the "loading" symbol.
__________________ Adventure is not outside; it is within. --Found in a fortune cookie on game night
Strangely I think I'd be okay with having a PC die by a bear exploding out of his head. --Awayfarer, after having his PC put a furry ball from a Bag of Tricks into his mouth.
ENWorld continues to be inconsistently slow/fast for me as well. Sometimes the pages will timeout or the connection with the server will be reset. I thought it was just me, but apparently not. Thanks for working on this.
Are you on shared hosting? First step in fixing this is moving off that if finances can support it.
Have you checked your slow query logs? This looks like the result of some really slow queries causing subsequent queries to wait.
Disk access speed could also be a culprit.
I suggest moving the wiki to a different MySQL instance.
Another suggestion, which I don't expect anyone to take seriously - remove or significantly reduce the database access occurring on the front page. I'm assuming most of your traffic hits that page. Try caching that page or just make it static altogether.