[prev in list] [next in list] [prev in thread] [next in thread] 

List:       baruwa
Subject:    Re: [Baruwa] reports and large deployments
From:       "Johnson, SE" <sjohnson () edina ! k12 ! mn ! us>
Date:       2012-12-13 17:13:12
Message-ID: 89BF87FCFFEEB64A89903D6E9CD8E82C39B824FF () Exchange2010 ! ISD273 ! ORG
[Download RAW message or body]

No but I will look at those; thanks.  I was using the slow query analyzer and wasn't \
coming up with anything before...  But haven't tried those tools yet...

-----Original Message-----
From: baruwa-bounces@lists.baruwa.org [mailto:baruwa-bounces@lists.baruwa.org] On \
                Behalf Of Glenn Kelley
Sent: Thursday, December 13, 2012 10:18 AM
To: Baruwa users list
Subject: Re: [Baruwa] reports and large deployments

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: baruwa-bounces@lists.baruwa.org 
> [mailto:baruwa-bounces@lists.baruwa.org] 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: baruwa-bounces@lists.baruwa.org 
> > [mailto:baruwa-bounces@lists.baruwa.org] 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

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


[prev in list] [next in list] [prev in thread] [next in thread]