Em 21-09-2011 10:29, Gavin McCullagh escreveu:
A 150GB database. That's pretty large. How many clients have you?
About a dozen clients - some inactive but still with valid backup - File
Retention = 6 months, Job Retention = 1 year. Most clients have few or
no changes, but my storage server has 2,825,101 files on a full backup
and almost 100.000 on an incremental.
Which database are you using (MySQL, Postgresql)?
MySQL.
If you haven't seen it
already, this might be useful:
http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog
Yes, I was there when you mail arrived. It made think about going to
Postgres. Is there any upgrade path or helper to go from mysql to
postgres? I am now optimizing File table and will then run dbcheck.
Best regards,
--
*Marcio Merlone*
------------------------------------------------------------------------------
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-d2dcopy1
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
