I did that - and it helped a great deal. Rather than 1 very large file - each table gets its own - so it can filter through each smaller file for the results needed.
Actually worked quite well on my end. Saw quite a performance increase after rebuilding the db On Dec 13, 2012, at 10:59 AM, Johnson, SE wrote: > There's only one DB on this server and it's for the mail filtering/baruwa... > So I'm not sure separating them out would buy me anything. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Andrew Colin Kissa > Sent: Tuesday, December 11, 2012 2:01 PM > To: Baruwa users list > Subject: Re: [Baruwa] reports and large deployments > > > On 11 Dec 2012, at 8:58 PM, Johnson, SE wrote: > >> The file system the database is on is ext3 and I've found references to a >> data file over a couple of gig causes issues with speed. The data file for >> mysql is 22gb in size (and yes, I'm running the cron cleanup job on it). >> This is only for a couple of months of email. > > Is that your ibdata1 file ? You could also try configuring mysql to create > one per table, could cut down on the size for the tables you actually query. > > - Andrew > > -- > www.baruwa.org > > > > > _______________________________________________ > 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 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
