Am 06.05.19 um 03:40 schrieb Lv Haijiao:
> Hi, Andreas
> 
> We run with MySQL.  And tried an estimate,  it seems the estimated time
> is close to the actual backup time. 
Estimate traverses the Fileset on the bareos-fd just like it would for a
backup. It doesn't touch the file's contents at all.
So if this takes 14 hours, you either have lots and lots of files, a
really slow filesystem (what is the fs-type) or a fileset that slows
down a lot (a lot of wildcard or regexp include/exclude).
Can you rerun the estimate (you don't have to wait for it to finish) and
look at the utilization of the machine running the fd? If the fd takes
one cpu and maxes that out it is probably the fileset.
If you see a lot of i/o waiting, then it is probably the filesystem or
drives.

Concerning MySQL: do you realize that PostgreSQL is the preferred DBMS
for Bareos? Would you shed a light on how the decision to go with MySQL
was made (this is off-topic for your question, but I'm trying to find
out why so many people still use MySQL).

Best Regards,
Andreas

-- 
  Andreas Rogge                             [email protected]
  Bareos GmbH & Co. KG                      Phone: +49 221-630693-86
  http://www.bareos.com

  Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
  Komplementär: Bareos Verwaltungs-GmbH
  Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to