-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/14/2013 08:59 AM, Novosielski, Ryan wrote: > 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
Actually, > after re-reading that, I'm a little confused. I don't know whether it says to "drop all indexes except for primary and then drop the listed indices" or "drop everything except for primary and except for the listed indices." In any case, this solved the problem for me. I wonder if a repair would have also and maybe that's why? - -- - ---- _ _ _ _ ___ _ _ _ |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/ iEYEARECAAYFAlD0D7oACgkQmb+gadEcsb4ttgCg4qEBugxxEnadoBZK7bkraZwv ox0AoI+m8TMdoqhP9Yaz5h3Ba5Nbhkk4 =+mF6 -----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
