Trying to get on the TDR

[barryg41]

Were yall having server problems? I hope not... . it was just unusually hard to get on tonight.



thanks

 

[chuck3]

Yes they were, tryed getting on for over an hour.

 

[illflem]

Every Tues & Weds everning for the past month it's the same story, time for a new server...

 

[admin2]

Not time for another server....

Not time for another server, just time to tune the database. The problem is connections, not server load. I've been making tweaks but there's no way to test them until the connections get high...

 

[barryg41]

The connections are HIGH... . the beam of light is upon you...



I realized it was connections after I read the server post. It said something about something about connections. Talk about rolling your eyes and going around in circles.

 

[jthorpe]

Give 'em a break guys. Mysql isn't the easiest thing in the world to tune correctly when you're starting to get a ton of users. You have to set max_connections and bunch of other stuff to get it to work right without taking up too many server resources.



Of course, I guess you knew that

 

[barryg41]

jthorpe... I want a database that goes from deflagration to detonation without regard to how many users are on.



I dont really know what it takes to tune a database, (SQL) but it must be a PITA.



The TDR guys are doing a wonderful job..... IMO



Thanks GUYS!!!

 

[illflem]

Ken, thanks for the info and work on tuning the database from a computer know nothing. Is the Server is Busy screen related to the same problem?

 

[Jim Fulmer]

TDR Admin PANIC

WWEEEEWWWW, man I thought we were down for a min, I even started going through withdraws not being able to get on the board, It's all good now thanks for the work.



Jim

 

[admin2]

Originally posted by illflem

Ken, thanks for the info and work on tuning the database from a computer know nothing. Is the Server is Busy screen related to the same problem?

The server busy message is related. Server load isn't that high when the problems occur. We've had it set to 300 connections at once and it didn't solve the problem. MySQL is getting into a "race" condition and then all connections get blocked. Then users start pounding the system, hitting "refresh" repeatedly until the race condition gets so bad that only a restart of the database will eliminate the problem.



Query A takes 5 seconds, Query B waits that 5 plus takes 5 more. Query C waits those 10 seconds, plus its 5 and so on until a query would take hours. Its problem known with MySQL since its core engine is single threaded and fine tuning will help to avoid the problem... but as mentioned by another in this thread, tuning is difficult (for ANY database engine).

 

[BushWakr - RIP]

Hey I know !!! Piers can tune anything, then all you need is 'drugs'...

Seriously, keep tuning and such, and I for one will wait patiently for you to finish. Heck, I have a hard time with a home PC sometimes.



Bob

 

[Doc Tinker]

Something must have got tuned. This site is flying for me tonight



Doc

 

[chuck3]

Man.

Wow, I guess so, better fasten my seat belt.

 

[illflem]

Flying for me also with my new (phone co finally fixed their line) 54,333 bps connection. Don't laugh it's faster than 24k. Thanks Ken!

 

[admin2]

I've just begun... it'll get faster!



Oh, to those that don't know, even with a 56k or 28. 8k modem you should average much fast than normal page load speeds when using TDR as we use GZIP to compress the pages by up to 90% before transmitting them to you. Most web browsers handle GZIP'd HTML automatically.