Citando Uwe Schuerkamp <uwe.schuerk...@nionex.net>:
What kind of files are you backing up? I've seen speeds as low as 0,5
MB / sec on a more or less idle host which has a gazillion of small
image files on it. In fact I've needed to split up the backup into
several sub-jobs to prevent it from running more than 48h or so ;-)
Also, I've seen jobs which start off incredibly slow only to pick up
speed near the end... very weird. (bacula version 5.2.6 in this
case).
Have you checked your mysql tables for a corrupt index on the "File"
or "Filename" tables?
All the best,
Uwe
--NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA
I'm backing up multiple different clients, some with lots of small files
like the mail server and others with big files. All of them starts the
backup fast and end slow.
Here is the show index, I don't know if it's right or not:
show index from File;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| File | 0 | PRIMARY | 1 | FileId | A
| 274094 | NULL | NULL | | BTREE | | | File
| 1 | JobId | 1 | JobId | A | 31
| NULL | NULL | | BTREE | | | File | 1 |
JobId_2 | 1 | JobId | A | 31 | NULL |
NULL | | BTREE | | | File | 1 | JobId_2
| 2 | PathId | A | 3559 | NULL | NULL
| | BTREE | | | File | �
� 1 | JobId_2 | 3 | FilenameId | A | 274094 |
NULL | NULL | | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
show index from Filename;
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Filename | 0 | PRIMARY | 1 | FilenameId | A
| 1588498 | NULL | NULL | | BTREE | | | Filename
| 1 | Name | 1 | Name | A | 1588498
| 255 | NULL | | BTREE | |
+----------+------------+----------+--------------+-------------+-----------+-------------+------
----+--------+------+------------+---------+ show index from Path; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Path | 0 | PRIMARY | 1 | PathId | A | 40618 | NULL | NULL | | BTREE | | | Path | 1 | Path | 1 | Path | A | 40618 | 255 | NULL | | BTREE |
|
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
------------------------------------------------------------------------------
Got visibility?
Most devs has no idea what their production app looks like.
Find out how fast your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219671;13503038;y?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
