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
