TFL Busy?

Countdown · Post by **Countdown** » Sun Oct 10, 2010 5:37 pm

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.

Swindle · Post by **Swindle** » Sun Oct 10, 2010 10:12 pm

Me too lately.

Post by **trance** » Mon Oct 11, 2010 11:07 am

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!

Post by **trance** » Mon Oct 11, 2010 10:06 pm

*crosses fingers* anything today? not showing any outages today in my logs

Countdown · Post by **Countdown** » Mon Oct 11, 2010 10:23 pm

No, I haven't had any problems today. Been great!

Post by **trance** » Mon Oct 11, 2010 11:22 pm

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!