Page 1 of 1

TFL Busy?

Posted: Sun Oct 10, 2010 5:37 pm
by Countdown
I seem to get the following error when visiting TFL. It happens kind of often now. Am I the only one?
INSERT INTO `outtage_log` (`ip`,`time`) VALUES (INET_ATON('69.218.241.143'), 'October 10, 2010, 6:36 pm')
Transformerland Server Busy

Transformerland.com is currently experiencing unusually high traffic. Please sit back, relax, enjoy a cup of coffee. Do not attempt to click on anything for the next minute and the problem will fix itself faster! Thank you :)
Click here to return to Transformerland.

Posted: Sun Oct 10, 2010 10:12 pm
by Swindle
Me too lately.

Posted: Mon Oct 11, 2010 11:07 am
by trance
Yes, luckily it only lasts a few minutes each time, I've been working on solving the issue...I can now see exactly when the site does that.

It's a combination of server traffic and very big database tables.

It's not an easy fix, without altering some of the functionality of the site, but I am hacking away at it!

Posted: Mon Oct 11, 2010 10:06 pm
by trance
*crosses fingers* anything today? not showing any outages today in my logs :)

Posted: Mon Oct 11, 2010 10:23 pm
by Countdown
No, I haven't had any problems today. Been great! :)

Posted: Mon Oct 11, 2010 11:22 pm
by trance
Countdown wrote:No, I haven't had any problems today. Been great! :)
There was just an outage, but only 1 all day, pretty good improvement.

Just now I worked with TT to remove nearly 1/3 of dead space from one of the biggest tables, and, I just learned about indexing. After making these changes, queries are running at 1.5 milliseconds as opposed to 7.5 milliseconds prior to these changes. Huge improvement, but still crossing fingers!