Re: [Bacula-users] restore performance
2013-01-14 09:01:07
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 01/14/2013 08:52 AM, Uwe Schuerkamp wrote:
> On Mon, Jan 14, 2013 at 08:44:06AM -0500, John Drescher wrote:
>
>> I did not mean file table indices (I am not sure about these - I
>> use postgresql with bacula). However I meant tuning the database
>> parameters to allow mysql server to use more memory. I have had
>> to do that for other mysql usage.
>>
>> John
>
> Sure, on our db server (18GB RAM, latest MariaDB 64bit) I have
> allocated about 8G for key buffers, but the idea that File table
> indices slow bacula down in recent versions needs clarification
> ;-)
>
> I was hoping Ryan could link to the article in question.
According to this anyhow:
http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog
- --
- ---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Sr. Systems Programmer
|$&| |__| | | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/EI-Academic Svcs. - ADMC 450, Newark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/
iEYEARECAAYFAlD0DvAACgkQmb+gadEcsb7I1wCgwyT7xz6uRG7LodjMDUMDgDxY
8DYAn0DoZ3xGyv8ZXJZTqHvc79Z5m27o
=kLIG
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
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
|
|
|