Post #250,305
3/31/06 11:22:20 AM
|
Note on long threads:
The long threads REALLY kill the database here, folks. That 259-post thread in the test forum is responsible for the horrendous response times we have here right now.
I've locked all of the posts in that thread. In the future, please limit game threads to a reasonable number of posts before branching.
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #250,306
3/31/06 11:24:11 AM
|
Can you program a cap?
A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!"
|
Post #250,307
3/31/06 11:25:42 AM
|
Not worth the time.
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #250,313
3/31/06 12:10:56 PM
|
Over 100 posts in a thread now gives a warning
For replies to that thread.
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #250,385
3/31/06 5:23:16 PM
|
Turn out the lights, the party's over...
|
Post #250,310
3/31/06 11:57:33 AM
|
Thanks for the post Scott.
everything should be faster in any case. I pumped up the memory usage.
-- [link|mailto:greg@gregfolkert.net|greg], [link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwetheyFreedom is not FREE. Yeah, but 10s of Trillions of US Dollars? SELECT * FROM scog WHERE ethics > 0;
0 rows returned.
|
Post #250,312
3/31/06 12:06:52 PM
|
Oopsie.
Just having a bit of fun
If you push something hard enough, it will fall over. Fudd's First Law of Opposition
[link|mailto:bepatient@aol.com|BePatient]
|
Post #250,314
3/31/06 12:14:55 PM
|
Sorry 'bout that...
Still...it was fun while it lasted. If'n I can ever get out to the BeePBash, Bill & I'll have to have a drool duel...
jb4
"Every Repbulican who wants to defend Bush on [the expansion of Presidential powers], should be forced to say, 'I wouldn't hesitate to see President Hillary Rodham Clinton have the same authority'."
&mdash an unidentified letter writer to Newsweek on the expansion of executive powers under the Bush administration
|
Post #250,315
3/31/06 12:15:57 PM
|
I don't mind you doing it
Just branch once in a while, ok? :-P
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #250,317
3/31/06 12:33:08 PM
|
It is likely that both words will apply :-p
If you push something hard enough, it will fall over. Fudd's First Law of Opposition
[link|mailto:bepatient@aol.com|BePatient]
|
Post #250,328
3/31/06 1:54:49 PM
|
I'm sure they will on my part...
100 post limit before a branch eh? You game?
jb4
"Every Repbulican who wants to defend Bush on [the expansion of Presidential powers], should be forced to say, 'I wouldn't hesitate to see President Hillary Rodham Clinton have the same authority'."
&mdash an unidentified letter writer to Newsweek on the expansion of executive powers under the Bush administration
|
Post #250,329
3/31/06 1:57:20 PM
3/31/06 1:58:18 PM
|
I'm game -- deal me in!
lincoln
"Chicago to my mind was the only place to be. ... I above all liked the city because it was filled with people all a-bustle, and the clatter of hooves and carriages, and with delivery wagons and drays and peddlers and the boom and clank of freight trains. And when those black clouds came sailing in from the west, pouring thunderstorms upon us so that you couldn't hear the cries or curses of humankind, I liked that best of all. Chicago could stand up to the worst God had to offer. I understood why it was built--a place for trade, of course, with railroads and ships and so on, but mostly to give all of us a magnitude of defiance that is not provided by one house on the plains. And the plains is where those storms come from." -- E.L. Doctorow
Never apply a Star Trek solution to a Babylon 5 problem.
I am not merely a "consumer" or a "taxpayer". I am a Citizen of the United States.
[link|mailto:bconnors@ev1.net|contact me]
Edited by lincoln
March 31, 2006, 01:58:18 PM EST
|
Post #250,428
3/31/06 6:46:02 PM
|
It's not a limit, it's a request.
Regards,
-scott anderson
"Welcome to Rivendell, Mr. Anderson..."
|
Post #250,726
4/3/06 10:23:59 AM
|
So far, we're behaving ourselves...
jb4
"Every Repbulican who wants to defend Bush on [the expansion of Presidential powers], should be forced to say, 'I wouldn't hesitate to see President Hillary Rodham Clinton have the same authority'."
&mdash an unidentified letter writer to Newsweek on the expansion of executive powers under the Bush administration
|
Post #250,318
3/31/06 12:39:35 PM
|
Thanks. But...
The general response time has been very pokey over the last few weeks - even before the music madness. I look back with fondness to the olden days when refreshing was almost instantaneous...
Are there issues with the TWiki and/or spammers hitting the site?
Thanks a bunch.
Cheers,
Scott.
|
Post #250,367
3/31/06 4:40:27 PM
|
Take a look at usage stats.
Notice February and March?
See anything unusual?
I specifically #1 and #2 on [link|http://www.iwethey.org/zlogs/usage_200603.html#TOPSITES|March 2006] Top "hits" per Host, then also look Just below it at the Top 5 By KBytes.
If you'll also note that the Bestestest Referrers have quite a few pR0n sites there. Reason is, referral spam and using Z somehow (I am not showing) as a proxy to generate Site hits for those places.
Now, onto [link|http://www.iwethey.org/zlogs/usage_200602.html|February 2006] Same thing as March. [link|http://www.iwethey.org/zlogs/usage_200602.html#TOPSITES|Top "Hits" per host], the top 2 are big hitters, though #1 far exceeds double the next one. The top #1 is also related to the top 2 for March. I have thus blocked the entire subnet, based on the hostile phone call I wound up having (I called the Block owner) and basically he told me to Piss-off. So, I guess even if it was legitimate traffic, it is blocked.
Then also look on the Top by KBytes agian, search engines are really getting to like us.
Now Become.com I believe has been started in a partnership with a self-exiled person from IWETHEY. For this reason, I don't believe any harm or bother was meant. Therefore Scott and I have placed more strict robots.txt in the proper places for Z and for twiki.
This so far has kept the amount of referral-proxy down quite a bit since 8:30AM. Then I went after why the DB was goin crazy on us. That is when we found that the EvUuL Threads oF Do0m were hammering the DB.
I gave the DB more breathing room, but since the Postgresql DB connection for Zope driver doesn't do multi set queries very well, it may well do them all seperately (I think that is what was mentioned earlier today), The changes only speed it up a bit. (currently 30+ seconds to render the "7|-|R34D 0|= D347|-|" #249242).
Since we got done making threads smaller (hopefully), tweaking and blocking things, Load Averages have steadily decreased and the DB is no longer gasping for air. and basically I hope we will see a return to a respectable performance level.
-- [link|mailto:greg@gregfolkert.net|greg], [link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwetheyFreedom is not FREE. Yeah, but 10s of Trillions of US Dollars? SELECT * FROM scog WHERE ethics > 0;
0 rows returned.
|
Post #250,375
3/31/06 5:00:05 PM
|
Many thanks. :-)
|
Post #250,418
3/31/06 6:26:16 PM
|
You are a God! (or at least a demi-god...)
Thanks (again), Greg!
jb4
"Every Repbulican who wants to defend Bush on [the expansion of Presidential powers], should be forced to say, 'I wouldn't hesitate to see President Hillary Rodham Clinton have the same authority'."
&mdash an unidentified letter writer to Newsweek on the expansion of executive powers under the Bush administration
|
Post #250,436
3/31/06 7:59:14 PM
|
Appreciation: +10
I know this is a labor of love for you and Scott, still, thanks for creating and maintaining this little corner of cyberspace.
Gratefully,
Amy
"It's never too late to be who you might have been." ~ George Eliot
|
