Re: [dspam-users] purge-4.1.sql hanging?!

> kalin mintchev wrote:
>> hi all...
>>
>> purge-4.1.sql has been in place since about a month ago - first dspam
>> set up.
>> this morning it hung up the whole mail server for about 3 hrs. i had to
>> kill it... no mail was delivered - all dbs were locked...
>> any ideas? nothing in the sql.error log... all the data and stats seem
>> to
>> be there... i guess the sql 'TRANSACTION' saved it... and dspam seems to
>> be working again....
>> found stuff on line to add indexes to the tables... maybe i will... but
>> even without them 3 hrs is a bit too much...
>>
>> thanks...
>>
>>
>>
>>
> Not much to go on, but my first instincts are to ask:
> Perhaps your database has grown in size? Does your sql server has
> enough RAM allocated to it?

i think so. i checked those right away. it might be related but there was
ram available - wasn;t all used up... dbs right now are about a gig...

> -Troy
>
Received on Tue Mar 27 20:50:45 2007