> 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 >
