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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users