User Comments, Suggestions, or Complaints | Privacy Policy | Terms of Service | Advertising
Page rendered in 0.4298 seconds
40 querie(s) executed
You are here > Home > Jim's Lab Notes > Discussion
| ||||||||
Jim's Lab Notes — Site News, Baseball Talk, and a Bunch of Other Stuff Wednesday, September 09, 2015Site SlowdownsA number of people have complained about slow load times for pages at different times during the day. After spending some time monitoring the server a little more closely the last few days, I’ve narrowed down the cause to a few Mysql queries that have been locking some of the database’s biggest tables. When that happens the other queries pause and fall into the queue until the table lock is released. I’ve already fixed some issues created within the forums by archiving the old Lounges. I need to spend more time researching some of the other queries to work around the issue by rewriting or disabling the errant queries. When that’s done I will spend a little time tweaking the Mysql configuration to get thing working to satisfaction. Thankfully, the issues are not related to the site’s hardware. I apologize for the inconveniences and for not setting aside time to fix things sooner. |
BookmarksYou must be logged in to view your Bookmarks. Hot TopicsPlease Excuse the Mess
(193 - 4:10pm, Aug 25) Last: Smitty* Site Issue Fixed (2 - 10:02am, Aug 17) Last: SoSH U at work Sorry about the Downtime Today (11 - 4:48pm, Apr 02) Last: bjhanke Join Jim's OOTP League (2 - 9:27am, Sep 06) Last: jimfurtado How much do minor league players get paid? (33 - 2:48pm, Apr 20) Last: Man o' Schwar Site Slowdowns (161 - 3:05pm, Nov 16) Last: Golfing Great Mitch Cumstein Sorry for the Downtime This Morning (10 - 5:43pm, Oct 13) Last: Infinite Yost (Voxter) Recent Updates and Turning off Advertisements (55 - 5:50pm, Mar 28) Last: Jose is an Absurd Sultan We're Moved! (And Burst.net can bite me!) (118 - 10:56am, May 20) Last: Hot Wheeling American We're Back Up! (84 - 4:05pm, Apr 03) Last: snapper (history's 42nd greatest monster) microBBTFs: I Have Keys and I am not Afraid to Give Them Out (33 - 4:32pm, Aug 16) Last: Publius Publicola Join My Sim League (30 - 1:36pm, Jan 03) Last: booond BBTF.org Beta, Take 2 (24 - 9:34am, Dec 28) Last: jimfurtado Staying Logged In Issue (135 - 6:20am, Sep 16) Last: Bote Man BBTF.org Beta (18 - 12:47pm, Aug 02) Last: JJ1986 |
|||||||
About Baseball Think Factory | Write for Us | Copyright © 1996-2021 Baseball Think Factory
User Comments, Suggestions, or Complaints | Privacy Policy | Terms of Service | Advertising
|
| Page rendered in 0.4298 seconds |
Reader Comments and Retorts
Go to end of page
Statements posted here are those of our readers and do not represent the BaseballThinkFactory. Names are provided by the poster and are not verified. We ask that posters follow our submission policy. Please report any inappropriate comments.
Hip
Hooray!
That's a feature.
Just an FYI, sometimes the ads on the site slow down the page load. I notice the difference when I view things when I am not logged in. I've moved your membership into the Patron member group (which doesn't see ads). Can you check to see whether this impacts your page views?
Does this happen all the time or just randomly?
That can't be right, can it?
Internet Explorer 5 (for Mac)?! The last update for that was 2003!
I have to believe that no one really expects a website to be compatible for software that is 12 years old.
What is a Patron member?
Those who like over priced but not much better Tequila.
Perhaps you're posting too much??
Let me try and test with this post.
Edit test.
Yeah, it now loaded really quickly. But sometimes it's fine regardless. I'll repost in this thread if it pops up again. Thank you!
Thanks for everything.
I've been monitoring things closely the last couple of weeks. For the most part, the server slowdowns pop up only periodically. I am still working to reduce them as much as I can. (One of the biggest triggers is Forum/Lounge searches.) If you are consistently experiencing slow page loads I suspect it might be related to the ads that target you. (Sorry, I can't completely get rid of ads because the site needs to at least pay for itself.)
That is a commonplace these days. This is by far the worst performing site of any of the ones I use regularly.
I'm having the same problem, but only on my Android.
Yes, ditto for me.
Agreed, and while I value the conversation that goes on here and the many great folks I've met through this site, the consistently poor performance is the reason I've not donated to the site, and won't unless the performance improves on a consistent basis. Some might posit there's a chicken/egg problem with my way of thinking. So be it.
Over and over and over again tonight. Mac OS 10.10.5, Chrome.
And I'm with Scoriano. I'm not sure I've ever stayed with a site with this kind of issue over this long a period. I've been a loyal user for 13 years, and have donated money from time to time. But this is really testing my patience.
That was to load the main page this morning. Windows 7 Enterprise (Service Pack 1), Google Chrome Version 45.0.2454.93 m. Ads on the page are Smile Train (top banner), AT&T (bottom box), and a rollover-slowly-expanding Cricket Wireless ad (left side banner) that seemed to be stalled in loading until I rolled over it deliberately and repeatedly, at which point it slowly took over the screen.
It's still the same on my phone. And it's always a Comcast ad (of different sizes). As it's the ad content that seems to be the issue, and I do understand that the ads are a necessary evil to keep the site viable, is it possible to find a different ad supplier without these issues? It would be ironic if the site died off due to the means that is supposed to keep it alive.
And a damned shame.
Just clicked on the X, and it does take me to the Comcast site, so it appears to be the same thing.
I used to have problems because of the ads here at work (if I tried to navigate on any page before all the ads had loaded the browser would crash), but we were on a really old version of IE at the time, and once I started logging in (and thereby not having ads) the problem went away.
Since I often load up a page literally when I'm hopping into the subway I often have just one crack at it and if I misfire then I can't read the page during my subway ride due to the lack of wireless.
These are among the most pressing problems on the planet earth, I know.
I thought I was the only one! (I've gotten pretty good at hitting that X on my first try, though. It beats Angry Birds.)
Doesn't seem so.
The first time I brought up BBTF on my Android this morning I hit the lone Comcast ad, but I refreshed and have had no problems since.
I would have posted that five minutes sooner, but, well, y'know.
As someone said, it will be a particular shame if the server problems can't be fixed for the post-season.
Script Executed in 135.3262 seconds
PROGRESS!
Whatever happens, it had better happen soon, before more people abandon the site on account of these delays.
-
Ummm.... these comments seem bizarre. Are you guys not reading this thread, that Jim (a) set up three weeks ago expressly for the purpose of informing/addressing questions related to the site slowdown, and (b) has commented in specifically explaining what he's trying to do?
Jim has commented twice, once the day he started the thread, and most recently nearly two weeks ago. I don't think finding that a bit sparse with continued, consistent site problems that unreasonable.
Primey.
Believe me I want this fixed. It impacts me as well. I ask for a little more patience. If I can't find the time in the next few days to get to the bottom of the problem, I will take a day out of work early next week.
This issue has brought to a head my Catch-22 for the site. I don't have enough time to keep up with all the requirements of keeping this place running. At the same time the site doesn't generate enough money to offload some of the work.
As longtime visitors know, this site has been a labor of love and not a "business". For years I had enough free time to keep things running. Unfortunately, my schedule and responsibilities at work have changed over the years. At this point, and entering my 20th year on the web, I need to either just focus on the stuff I really love doing or turn this place into a viable business. The status quo can't stand.
Again I apologize for the problem and promise to get this particular problem sorted out as quickly as I can.
Just something to think about.
For what it's worth, acknowledging the opinion of some dude on the internet ain't much, I greatly doubt this site could be turned into a viable business, as trying to monetize it beyond bare sustenance would (a) introduce enough intrusive advertising that many users would flee, and (b) require trying to vastly increase the userbase so as to increase revenue, which would destroy BBTF's niche on the internet, would definitely chase off its veterans, and end up with the site competing directly with the Hardballtalks and ESPN.coms of the world, a competition it won't win because the big boys have already claimed all of that turf.
I'd be interested in what others think about that issue. If BBTF is to continue to exist as we know it, someone has to be willing to pour a lot of time--basically doing a part-time job for free--into administering it. And not just any random teenager with loads of free time that happens along, either; it would have to be someone that groks BBTF and can be trusted with the responsibility. It may well be that, if Jim must bow out, no such person will prove to exist.
when faced with a situation that generates a lot of griping i choose some combination of telling people to shut up, taking care of the issue myself or get others to handle.
posters have some cause so i am slow to take the first route, cannot handle personally given my lack of skills in the area of need but am certainly willing to financially support enlisting the help of others.
no rational poster expects you to sacrifice your professional or personal life for the sake of the site.
This particular issue will be addressed. As for the broader issues, things will work out one way or another.
-----
Experienced another slowdown this morning. I'll be updating the underlying CMS in case a bug has crept into the software. Troubleshooting sporadic issues can be time consuming. It's all about checking off boxes.
If the choice is between having a well-functioning BBTF site without OT threads or having a frustrating annoyingly laggy BBTF site with OT threads, I know which I would choose. :)
Of course I could just stop living in OTP threads and get a life :)
I'll also be reworking the link submission page to take the changes into account. The restructuring will allow me to make a much requested change to the way Hot Topics work (allowing people to remove OTP stuff from their page). I'm not sure, however, whether I'll be able to make that update Monday, though.
If thread size is indeed the issue, is there a way to automatically cap the size of threads, say, keep it to a max of 500? I don't see why any single thread needs to be bigger than that, if people can go back to the old ones as they please. Just do a new OT thread daily, and put the date in the title. If people really need more than that, there are dozens of empty forums for them. In the rare event you need more than 500 comments per day for a given mainland thread, someone with keys can just open up a new one, and give it the same name as roman numeral II. Just please don't reduce the comments per page from 100 on the mainland -- that's a pain.
And yes, I am experiencing deja vu all over again.
The Omnichatters frequently clear 300 this time of year, and probably clear 500 at times once we get deep in the playoffs. That might be a low threshold to auto-lock a thread. 1000 might work (but, again, OTP frequently clears 1000 in less than a week).
The question is whether we can remove specific OT threads without removing all of them, for instance can I remove the soccer and gaming threads from the Hot Topics bar while keeping all the others?
I just experienced a severe lag when trying to load pages.
If by "container" is meant "Newsblog", "Jim's Lab Notes", etc., then maybe the solution is to create an "Off-topic" container?
You must be Registered and Logged In to post comments.
<< Back to main