-----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 |$&| |__| | | |__/ | \| _| |novos...@umdnj.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
