but in the perl/database area, either processor load, or bandwidth between the web server and the database ...
My gut feeling is... ridiculous.
Thanks for the insult.
The web server is pinging consistently at 50 to 80ms from here, and does so even when the pages are timing out or very, very slow. This led me to believe that there are issues in how it is handling the perl and accessing the database, either because of load (zombies, stuck processes, bad scripts, etc.) or because of some flake on the database side (server maxed out, disks full/badly fragmented, etc.) ... every request to FR calls a perl script and a trip to the database. Since the web server is pinging nicely (50 to 80ms) then the trouble might be behind it ... I don't know how FR is configured (as you obviously do) so my guesses are just guesses.
Since you obviously have a better understanding than I do ... so I'll shut up now.
Posted by John Robinson to Miss Marple On News/Activism 10/25/2002 8:32 PM CDT #93 of 134 It is probably the searching that kill us. It puts an inconsistent load on the system. We're talking about offloading the search engine and its own database onto another machine.
Posted by John Robinson to tubebender On News/Activism 10/25/2002 9:16 PM CDT #106 of 134 We were getting upto 150 hits/sec this afternoon. We usually get about 30-40. On top of that, the database server has been having a bad day all its own, and I can tell you the extra traffic did not help that situation.
I meant no insult. I do believe their could be a server problem, but I have see the site perform well under load. For several days during the sniper crisis, there were threads getting a thousand posts in a couple of hours, with good performance. Whatever is wrong has happened since then.
My gut feeling is that when performance is as bad as it has been, regular FReepers give up. In fact, it you count the total posts during the daylight hours today, they are very few. So who is causing the performance degredation? I don't think it's an excessive load caused by regular FReepers.