Re: [Bacula-users] restore performance
2013-01-14 08:35:02
On Mon, Jan 14, 2013 at 08:24:07AM -0500, John Drescher wrote:
> > 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
>
I'd like to have the above point clarified by the people in the know:
Are File table indices recommended with bacula versions > 5.0 or not?
Can the original poster provide a link to the article mentioned above?
Thanks, Uwe
--
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA
------------------------------------------------------------------------------
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Bacula-users] restore performance, Antony Mayi
- Re: [Bacula-users] restore performance, Uwe Schuerkamp
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, John Drescher
- Re: [Bacula-users] restore performance,
Uwe Schuerkamp <=
- Re: [Bacula-users] restore performance, John Drescher
- Re: [Bacula-users] restore performance, Uwe Schuerkamp
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, Uwe Schuerkamp
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, Jérôme Blion
|
|
|