Bacula-users

Re: [Bacula-users] restore performance

2013-01-14 08:26:45
Subject: Re: [Bacula-users] restore performance
From: John Drescher <drescherjm AT gmail DOT com>
To: "Novosielski, Ryan" <novosirj AT umdnj DOT edu>, bacula-users <Bacula-users AT lists.sourceforge DOT net>
Date: Mon, 14 Jan 2013 08:24:07 -0500
> I just ran into this. After a Google search, I turned up an article that
> says the indices that used to make Bacula run faster now cause a performance
> problem with recent versions of Bacula and recent versions of MySQL (it's on
> the Bacula wiki, the address for which I don't have handy). I removed all of
> the indices I had on the file table and restores only take a few minutes
> now.

Even though you have a tiny database I would still look into tuning
your mysql settings. A lot of distributions ship with a ridiculous
default configuration that assumes your PC has 64MB of ram or similar.

John

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users