Am Dienstag, 20. November 2007 17:12 schrieb Martin Simmons:
> >>>>> On Tue, 20 Nov 2007 14:03:30 +0100, Christian Schneider said:
> > Maybe I am missinterpreting
> > something, but the backup job seems to be paused during
> > tree-build-phase. Should I switch to a different maschine with
> > another bacula dir and mysql db instance to do the restores?
>
> Having a separate catalog would work, but you would need to schedule
> a time to copy from one to the other.
I would push the SQL dump after catalog backup to the second maschine.
Having faster tapedrives would also bring some idle time and let the
backup complete in 2-3 days or maybe faster. :)
> > I there a chance, that this problem went away with an update to the
> > latest 2.2.x version of bacula?
> >
> > A little kick in the right direction would be very appreciated!
>
> What indexes does your catalog have? Maybe it is missing one that
> would make the tree building run faster?
I have checked that months ago but let's have a look... The attached
indexes.txt contains the actual configuration. Did I miss something?
The catalog contains one year of weekly backkups - every single backup
contains about 800-1000GB of data and about 10 million files.
> Have you considered splitting the fileset into several smaller
> filesets? If you have lots of data that never changes much, then
> that could be backed up less often.
Hmm, not really. There is only one client who is collects the data from
our whole network and does every sunday an export to a seperate
directory. This directory (containing subdirectories of servergroups)
is weekly backed up to tape using bacula. Splitting this directory tree
isn't impossible, but it's also not so simple... Also this could give
us a performancy gain during spooling the small files over gigabit
ethernet... I will think about it.
Thanks in advance,
Christian
mysql> show index from Filename;
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Filename | 0 | PRIMARY | 1 | FilenameId | A |
6897774 | NULL | NULL | | BTREE | NULL |
| Filename | 1 | Name | 1 | Name | A |
6897774 | 255 | NULL | | BTREE | NULL |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
2 rows in set (0.01 sec)
mysql> show index from Path;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Path | 0 | PRIMARY | 1 | PathId | A |
90115814 | NULL | NULL | | BTREE | NULL |
| Path | 1 | Path | 1 | Path | A |
90115814 | 255 | NULL | | BTREE | NULL |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
2 rows in set (0.00 sec)
mysql> show index from File;
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| File | 0 | PRIMARY | 1 | FileId | A |
54933091 | NULL | NULL | | BTREE | NULL |
| File | 1 | JobId | 1 | JobId | A |
10 | NULL | NULL | | BTREE | NULL |
| File | 1 | PathId | 1 | PathId | A |
7847584 | NULL | NULL | | BTREE | NULL |
| File | 1 | FilenameId | 1 | FilenameId | A |
3433318 | NULL | NULL | | BTREE | NULL |
| File | 1 | FilenameId | 2 | PathId | A |
54933091 | NULL | NULL | | BTREE | NULL |
| File | 1 | JobId_2 | 1 | JobId | A |
10 | NULL | NULL | | BTREE | NULL |
| File | 1 | JobId_2 | 2 | PathId | A |
7847584 | NULL | NULL | | BTREE | NULL |
| File | 1 | JobId_2 | 3 | FilenameId | A |
54933091 | NULL | NULL | | BTREE | NULL |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
8 rows in set (0.00 sec)
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
