Slow Expire: Over 24 hours to finish

[Alex Kiernan]

"James F. Hranicky" <jfh at cise.ufl.edu> writes:

>    86232   history.hash
>    114968  history.index

During expire you'll need the sum of these two as anonymous memory.

> innd size:
>     PID USERNAME     PRI NICE  SIZE    RES STATE    TIME   WCPU    CPU COMMAND
>     258 news           2   0   136M 55008K select 262:45  2.98%  2.98% innd
> 

innd's resident set is 55M

> Here's the config:
> 
> 	FreeBSD 4.3-STABLE
> 	650 MHz PIII
> 	Intel GX440 motherboard
> 	256MB RAM

but you only have this much RAM

> Do I simply need to add more memory?

Probably...

If its expireover which is slow, you could try locking the history
database files in core (though you don't have enough RAM for both, so
try for just the .hash).

If its expire which is slow you probably just need more RAM.

-- 
Alex Kiernan, Principal Engineer, Development, Thus PLC