Message-ID:

BOFH excuse #220: Someone thought The Big Red Button was a light switch.

rocksolid / Rocksolid Nodes Announce / expiring some articles on news.novabbs.org

Subject: expiring some articles on news.novabbs.org
From: Retro Guy
Newsgroups: rocksolid.nodes.announce
Organization: RetroBBS
Date: Tue, 1 Aug 2023 17:04 UTC

Path: eternal-september.org!news.eternal-september.org!i2pn.org!i2pn2.org!.POSTED!not-for-mail
From: retro.guy@rocksolidbbs.com (Retro Guy)
Newsgroups: rocksolid.nodes.announce
Subject: expiring some articles on news.novabbs.org
Date: Tue, 1 Aug 2023 17:04:13 +0000
Organization: RetroBBS
Message-ID: <8fda24d3be3659c83fba5f58a1f9987c@rocksolidbbs.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Info: i2pn2.org;
logging-data="1041386"; mail-complaints-to="usenet@i2pn2.org";
posting-account="qk6pvs/sIyKYNRNFdjVS+ghlZZkCUq7cWs+7p7kaLpU";
User-Agent: Rocksolid Light 0.8.5
X-Rslight-Site: $2y$10$l1y5h.tyDt/tDTIK6r1i7eWSi.S19PEJQi5Dfuw0OatAJxa6jPVJW
X-Face: .&YR-G(w(DZ$$,}%k=]*5*!p'=(anr"IT`wZG'2VWdfl\r)l[42u7JH`n(JUQ*e5*A|XCDf
?&\X&uwkl38"CYX3O8m}C8E4p'%N$2#kSTVzx{Ly|DjLT\Vk7NE}NQ(VC$Yq]i:7|z[.9iv^g>*8_B
H0=hZt'[%)4kG|
X-Rslight-Posting-User: 7f2224730128256930309c9186f6203084896743
X-Spam-Checker-Version: SpamAssassin 4.0.0 (2022-12-13) on i2pn2.org

View all headers

For the past couple of days, I have been pruning groups to save articles up to 90 days.

This will prune approximately 2 million posts for this run. Then it will just expire one day's postings after that (postings over 90 days old). The expirition is automatic, it just takes quite a while to expire millions of posts.

I wanted to do this as the server running news.novabbs.org is not that powerful, and wanted to see the speed changes. Also, it was a major test for rslight's expire.php program, which is performing perfectly.

Note, you can still view all these groups with much longer retention on www.novabbs.com, which has been up and running for about as long as news.novabbs.org. Note the '.org' vs. '.com'.

Right now www.novabbs.com serves approximately 3.6 million posts, and does not seem to have any trouble doing so.

Yes, I know number of active users makes a big difference, but I'm testing the db access times right now. sqlite3 is performing very nicely.

--
Retro Guy

Subject	Author
expiring some articles on news.novabbs.org	Retro Guy