Bacula version 5.0.3
In BAT, when trying to restore a directory (roughly 31,000 files in 560 sub
folders) The "Filling Database Table" takes an extremely long time to complete
(about an hour or so).
I've been looking around for a way to speed this up. Found a post on here that
referred to an article that basically said PostgreSQL was the way to go as far
as speed
(http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog).
So I converted from MySQL to PostgreSQL using the conversion procedure in the
Bacula documentation. We are now on PostgreSQL, but the speed seems just as
slow (if not slower). Is there anything else that can be done to speed this
process up?
I've also tried the running the DB under MySQL with MyISAM and InnoDB tables.
Both had the same slow performance here. With MySQL, I also tried using the
my-large.cnf and my-huge.cnf files. Neither helped.
Server load is very low during this process (0.06). BAT process is at about 3%
cpu and 1.6% memory. Postgres service is about 1%cpu, 0.6% memory. Drive
array is pretty quiet also.
Any help would be greatly appreciated. If any extra info is needed, I will
gladly provide it.
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
