Baseball for the Thinking Fan

Login | Register | Feedback

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, 2015

Site Slowdowns

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

Jim Furtado Posted: September 09, 2015 at 10:19 AM | 112 comment(s) Login to Bookmark
  Related News:

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.

You must be Registered and Logged In to post comments.



<< Back to main

BBTF Partner

Support BBTF


Thanks to
Adam S
for his generous support.


You must be logged in to view your Bookmarks.


Page rendered in 0.2146 seconds
55 querie(s) executed