2012/1/11 Honia A <honia2...@hotmail.com>: > I'm backing up a handful number of Unix boxes, they all get backed up very > quickly but we can't access them due to the BackupCatalog job being very > slow. When I read online, I see people said it's because of the database > size getting larger and larger. > > I cancel the backup catalog job and all the servers become accessible. This > is the configuration for catalog: > > > # This is the backup of the catalog > FileSet { > Name = "Catalog" > Include { > Options { > signature = MD5 > } > File = "/var/lib/bacula/bacula.sql" > } > } >
There is really nothing you can do with the bacula config files to change that. > > All backups finish around 5 AM but all the servers remain inaccessible until > 8:30 or so. The last job running is that backup job so I thought the process > getting slower and slower everyday might have something to do with the size > of th ebacula.sql file. > > You really need to tune your mysql database / filesystem the db is on. My database is ~39GB and the catalog job takes less than 10 minutes to complete. Although I am using postgres instead of mysql both databases should be tuned in a lot of cases since the defaults are very low for for a modern machine with 8GB+ of ram. John ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users