Check your mysql server sessions, you should see what is going on with the query that is running.
On 13 Nov 2012, at 9:08 PM, Johnson, SE wrote: > I am running this on a nightly basis: > > # clean quarantine > baruwa-admin cleanquarantine >/dev/null 2>&1 > # clean up the DB > baruwa-admin dbclean >/dev/null 2>&1 > # update sa rule definitions > baruwa-admin updatesarules >/dev/null 2>&1 > # clean up stale sessions > baruwa-admin cleanup >/dev/null 2>&1 > # update geoip database > perl /usr/share/doc/GeoIP-*/fetch-geoipdata.pl > > From: [email protected] > [mailto:[email protected]] On Behalf Of Jeremy McSpadden > Sent: Tuesday, November 13, 2012 12:41 PM > To: Baruwa users list > Cc: [email protected] > Subject: Re: [Baruwa] reports and large deployments > > Yes, you should. What are the specs of your server? Have you bumped up your > PHP timeout? Also, are you running a cronjob to clean out database ? > > -- > Jeremy McSpadden > Flux Labs | Endless Solutions > Office:850-250-5590x101 Cell : 850-890-2543 | Fax : 850-254-2955 > > On Nov 13, 2012, at 12:29 PM, "Johnson, SE" <[email protected]> wrote: > > > I’m not really sure how large our site compared to other users of baruwa is > but we get about 10-15,000 emails / day. Right now I have about 1,215,302 > messages in baruwa. > > I’m not sure if this is what’s causing the report issues we have or if > there’s another issue going on. Should I be able to pull reports with that > many emails in baruwa? I’d like to be able to pull some spam statistics for > the management… > > Thanks! > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 -- www.baruwa.org _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
