-----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
|$&| |__| |  | |__/ | \| _| |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/

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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users