Re: [Bacula-users] Restore performance

Subject:

From:

Marcio Merlone <marcio.merlone AT a1.ind DOT br>

To:

Gavin McCullagh <gavin.mccullagh AT gcd DOT ie>

Date:

Wed, 21 Sep 2011 10:56:09 -0300

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

<Prev in Thread]

Current Thread

[Next in Thread>

Previous by Date:

Re: [Bacula-users] Restore performance, Gavin McCullagh

Next by Date:

Re: [Bacula-users] Yet another 'Invalid command ".messages"' on restore, Marcello Romani

Previous by Thread:

Re: [Bacula-users] Restore performance, Gavin McCullagh

Next by Thread:

Re: [Bacula-users] Restore performance, Gavin McCullagh

Indexes:

[Date] [Thread] [Top] [All Lists]