Re: [Bacula-users] Re-2: Sending spooled attrs to the Director takes a long time
Zitat von Carsten Pache pa...@vgr-gruppe.de: It seems that Sending spooled attrs to the Director takes much longer than before. Can you give me some aid in solving this problem? Which database backend is this? When you upgraded Ubuntu, did the catalog database get recreated? Maybe it has lost some indexes or the rdbms configuration has changed? An additional option is that after upgrading the database server it returned to the default database config file which in a lot of cases is optimized for machines with a few MB (yes MB) of memory. I do not remember that I had to change the defaut database configuration when I installed Bacula 5.0.3 two years ago. So which config file do you mean? Can you give me some hints what I should change in this file? My Bacula server has 2 GB RAM. For a high insert rate you normaly have to extend the size or number of redo logs. For MySQL this might be possible in /etc/my.cnf or the like but i don't use MySQL so you have to RTFM. Regards Andreas -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Re-2: Sending spooled attrs to the Director takes a long time
On 10/31/12 18:26, lst_ho...@kwsoft.de wrote: Zitat von Carsten Pache pa...@vgr-gruppe.de: I do not remember that I had to change the defaut database configuration when I installed Bacula 5.0.3 two years ago. So which config file do you mean? Can you give me some hints what I should change in this file? My Bacula server has 2 GB RAM. For a high insert rate you normaly have to extend the size or number of redo logs. For MySQL this might be possible in /etc/my.cnf or the like but i don't use MySQL so you have to RTFM. Only applicable to InnoDB tables, but then you ARE using InnoDB, not MyISAM right? *Right?* - Stop MySQL. - Move [mysql data directory]/ib_logfile* somewhere else. - Edit /etc/my.cnf to change innodb_log-file-size and innodb_log_files_in_group. - Restart MySQL. Wait while it prepares the new log files. - Check the MySQL error log to make sure InnoDB started up correctly. Don't go hog wild. The performance gain from increasing the size of InnoDB log files isn't all that dramatic, and largely comes from increasing the interval between checkpoints, but it also increases the time taken for checkpoints. If you really badly need more MySQL performance, you're probably much better off updating to a newer MySQL branch and learning how to tune it properly. MySQL 5.6 should go general-availability any time now, and has still further performance gains over 5.5. That said, unless your Bacula catalog is on a separate machine from your Director, 2GB isn't very much RAM for a machine that's running both your Director and your catalog DB. Especially since in my experience, most servers running 2GB of RAM or less are also usually running a 32-bit OS even if they're on 64-bit-capable hardware. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re-2: Sending spooled attrs to the Director takes a long time
Last week I updated my bacula server from Ubuntu 10.04 to 12.04. During this update Bacula was also updated from 5.0.3 to 5.2.5. Since then the backups of my Windows 2003 servers take much longer than before. ... It seems that Sending spooled attrs to the Director takes much longer than before. Can you give me some aid in solving this problem? Which database backend is this? MySQL 5.5.24. When you upgraded Ubuntu, did the catalog database get recreated? Maybe it has lost some indexes or the rdbms configuration has changed? I do not know. How can I find out? At least I see no errors in Bacula's log file. Carsten -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re-2: Sending spooled attrs to the Director takes a long time
It seems that Sending spooled attrs to the Director takes much longer than before. Can you give me some aid in solving this problem? Which database backend is this? When you upgraded Ubuntu, did the catalog database get recreated? Maybe it has lost some indexes or the rdbms configuration has changed? An additional option is that after upgrading the database server it returned to the default database config file which in a lot of cases is optimized for machines with a few MB (yes MB) of memory. I do not remember that I had to change the defaut database configuration when I installed Bacula 5.0.3 two years ago. So which config file do you mean? Can you give me some hints what I should change in this file? My Bacula server has 2 GB RAM. Carsten -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users