Question about "<news>/db/history" file size
pety at rusnet.ru
Wed Apr 22 09:48:19 UTC 2009
On Wed, 22 Apr 2009, Jeffrey M. Vinocur wrote:
JMV> On Tue, 21 Apr 2009, Petr Novopashenniy wrote:
JMV> > What was the maximum size of your "<news>/db/history" file in production
JMV> > environment? How many GBytes?
JMV> I'm not sure what you're asking here.
Maybe.. Where better place?
JMV> The history file is about 10,000 articles per MB, so you should be able to
JMV> predict how big it will get depending on your feed settings and so on. If
JMV> you double your retention time, it will approximately double, and so on.
JMV> (Don't forget the /remember/ time in expire.ctl, if you have articles that
JMV> are retained for short times.)
Yes, you are certainly right. But I am more interested in the practical
side of the issue. With something like this success story: "my history
file size is ~20 GBytes, daily expire process uses ~5 GBytes of memory
(and works ~1 hour), no problem".
JMV> Jeffrey M. Vinocur
JMV> jeff at litech.org
More information about the inn-workers