Zitat von bdelagree <bacula-fo...@backupcentral.com>: > This post follows one of my old posts (see : > http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/slow-backup-how-to-optimize-122683/index-15.html) > > My backups are still long . > After listening to the network and servers I think my problem comes > from the database. > After much research some say migrate from MySQL to PostgreSQL . > > Before doing so I need your opinion , is there a real added value?
You should first check how long it actually takes to insert the attributes in the database. With this information you can decide if you are optimizing the right point. For example our biggest job has around 1.1TB with 4 mio files which grow to around 1.2G attributes per job according to the logs. This job finish within around 32 hours but inserting the attributes only takes ~3 minutes. We have additional overhead per file and overall throughput because using encryption and Windows isn't that fast either. So what is the time it takes to insert the attributes? What is the transfer speed you get? Do you use data/attribute spooling as you should? What is the transfer speed to tape (LTO-5)? Without carefully measuring this values no one could say if you got a real value from switching to PostgreSQL. Regards Andreas ------------------------------------------------------------------------------ Time is money. Stop wasting it! Get your web API in 5 minutes. www.restlet.com/download http://p.sf.net/sfu/restlet _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
