basically - amazing performance difference !
few other things you might want to do as well - are you familiar with any of the tuning tools for mysql? might help to use mysqltuner.pl and tuning-primer.sh Glenn On Dec 13, 2012, at 11:06 AM, Johnson, SE wrote: > Ah, so its each table gets a table. I'll look closer at that! > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Glenn Kelley > Sent: Thursday, December 13, 2012 10:04 AM > To: Baruwa users list > Subject: Re: [Baruwa] reports and large deployments > > 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 > > -- > 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
