On Wed, May 01, 2013 at 08:40:51AM -0700, Tim Gustafson wrote:
> I've used MySQL in the past, and Bacula is just apparently not
> optimized for it (or vice-versa, I'm not sure which).  We run a fairly
> beefy MySQL server and we have hundreds of apps and web sites that all
> use that server and all of them work extremely well but when we used
> it for Bacula, the query that it used to build a list of files to
> restore took *ages* - in some cases more than 24 hours, and in some
> cases it never finished at all - for our data set.  When we switched

I like having one database server for serveral/almost all applications,
however, I always have a seperate one for bacula. The bacula workload is
different from most other database applications as is mainly writes.
I'd personally go with postgres.

Regards,
        Adrian
-- 
LiHAS - Adrian Reyer - Hessenwiesenstraße 10 - D-70565 Stuttgart
Fon: +49 (7 11) 78 28 50 90 - Fax:  +49 (7 11) 78 28 50 91
Mail: lihas AT lihas DOT de - Web: http://lihas.de
Linux, Netzwerke, Consulting & Support - USt-ID: DE 227 816 626 Stuttgart

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users