From: Rodrigo A. A. <rod...@pe...> - 2012-09-28 16:27:20
|
Citando Uwe Schuerkamp <uwe...@ni...>: > 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 | | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ |