On 11/20/2013 3:29 AM, lst_ho...@kwsoft.de wrote: > Zitat von Charles Douglass <chas.dougl...@gmail.com>: > >> I ran mysqltuner before the backup and increased a couple of buffer >> sizes as well as taking this suggestion: >> innodb_flush_log_at_trx_commit=0 Then I ran a full backup and see >> this: 18-Nov 12:45 maple-sd JobId 46: Sending spooled attrs to the >> Director. Despooling 153,470,245 bytes ... 18-Nov 21:41 maple-dir >> JobId 46: Bacula maple-dir 5.2.6 (21Feb12): Build OS: >> x86_64-pc-linux-gnu ubuntu 13.04 So spooling/despooling took just >> about 9 hours. > Even for MySQL on a not too fast machine this is ridiculus slow. We > despool around 1.2GB attributes within around 2 minutes to our > Postgres server. Something is still wrong with your setup. Have you > checked with tools like iotop,top,vmstat what the server is actually > doing during the 9 hours.
Yes. Something is wrong. Is there a script configured to run after the job? Is there a broken disk drive? Is the machine low on RAM and using swap space constantly? Are other processes slow on this machine while the despooling is in progress? Is there a messed up or missing index? Have you tried rebuilding the database from a dump file? ------------------------------------------------------------------------------ Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
