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
