Hi, On Thu, 11 Nov 2010, Alan Brown wrote:
> What tuning (if any) have you performed on your my.cnf and how much > memory do you have? Thus far I haven't spent much time on this and haven't tuned MySQL. The slow build an annoyance, but not a killer so I've not really got around to it. The server has 6GB RAM (running an X86_64 kernel). > >Have I done something wrong? As FileId is a primary key, it doesn't seem > >like I should need an extra index on that one -- is that wrong? > > It doesn't need an extra index. Grand. > You've also got a duplicate pathid indeax which can be deleted. Ah, I didn't spot that, thanks. > This kind of thing is why it makes more sense to switch to postgres > when mysql databases get large. I see. Well, as long as I'm not missing some simple tweak to make MySQL run quicker I guess I'll plan to do that. Gavin -- Gavin McCullagh Senior System Administrator IT Services Griffith College South Circular Road Dublin 8 Ireland Tel: +353 1 4163365 http://www.gcd.ie http://www.gcd.ie/brochure.pdf http://www.gcd.ie/opendays This E-mail is from Griffith College. The E-mail and any files transmitted with it are confidential and may be privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the addressee you are prohibited from disclosing its content, copying it or distributing it otherwise than to the addressee. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and delete the e-mail from your computer. Bellerophon Ltd, trades as Griffith College (registered in Ireland No. 60469) with its registered address as Griffith College Campus, South Circular Road, Dublin 8, Ireland. ------------------------------------------------------------------------------ Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
