Hi,
Inserting the value* innodb_flush_log_at_trx_commit=2* in my.cnf
did the trick (innodb_flush_log_at_trx_commit=0 works fine two), but the
default value (innodb_flush_log_at_trx_commit=1), seems to be doing
something wrong.
One full backup (7 GB) has decreased the backup time from 4h (45
spooling data, and 3h 15h despolling attrs) to 45 min
Regards, I
2013/11/27 Iban Cabrillo <cabri...@ifca.unican.es>
> Hi Cejka,
> The server runs smooth :
>
> top - 14:11:06 up 20:18, 2 users, load average: 0.00, 0.01, 0.24
> Tasks: 154 total, 1 running, 153 sleeping, 0 stopped, 0 zombie
> Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Cpu1 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Cpu3 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Cpu5 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Cpu7 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
> 0.0%st
> Mem: 8177080k total, 6680440k used, 1496640k free, 151984k buffers
> Swap: 585724k total, 2516k used, 583208k free, 1713752k cached
>
>
> HDDs are not SSD but SAS over RAID1 hardware
> my.cnf :
>
> open-files-limit=8192
> max_connections=500
> wait_timeout=86800
> innodb_data_home_dir=/data/mysql
> innodb_file_per_table
> innodb_lock_wait_timeout=500
> innodb_log_file_size=1G
> innodb_buffer_pool_size=4G
>
> query_cache_size=128M
> tmp_table_size=256M
> thread_cache_size=16
> query_cache_limit=16M
> max_heap_table_size=256M
> table_cache=256
>
>
> I see my bacula version is 5.2.6 (21 February 2012) From Ubuntu 12.10
> repo, yours 5.2.12 (12Sep12), I do not know if there are many improvements
> in th DB between both releases.
>
>
> Regards, I
>
>
>
>
> 2013/11/27 Cejka Rudolf <cej...@fit.vutbr.cz>
>
>> Iban Cabrillo wrote (2013/11/27):
>> > Data spooling: 0 active jobs, 0 bytes; 1 total jobs, 1,845,487,814 max
>> > bytes/job.
>> > Attr spooling: 1 active jobs, 18,289,433 bytes; 0 total jobs,
>> 18,289,433
>> > max bytes.
>> >
>> > Data spooling about 10 minutes, Attr Spooling more than 30 minutes and
>> > growing....
>> > This happen for LT03 and LT=5 tapes
>>
>> Could you look at mysql server please? Its CPU usage, disk usage,
>> swapping, memory usage...
>>
>> Here are examples from my backup server with mysql:
>>
>> 1) 18,688,335 files in 37 minutes, which is ~ 500,000 files per minute:
>>
>> 03-Nov 08:37 backup-sd: Sending spooled attrs to the Director.
>> +Despooling 6,159,834,448 bytes ...
>> 03-Nov 09:14 backup-dir: Bacula backup-dir 5.2.12 (12Sep12):
>>
>> 2) 309,936 files in time is under 1 minute:
>>
>> 02-Nov 14:00 backup-sd: Sending spooled attrs to the Director.
>> +Despooling 86,532,417 bytes ...
>> 02-Nov 14:00 backup-dir: Bacula backup-dir 5.2.12 (12Sep12):
>>
>> I think that there are three key settings on my server:
>>
>> 1) MyISAM tables
>> 2) delay_key_write = ALL in my.cnf
>> 3) Database on SSD
>>
>> Best regards.
>>
>> --
>> Rudolf Cejka <cejkar at fit.vutbr.cz> http://www.fit.vutbr.cz/~cejkar
>> Brno University of Technology, Faculty of Information Technology
>> Bozetechova 2, 612 66 Brno, Czech Republic
>>
>
>
>
> --
> ####################################
> Iban Cabrillo Bartolome
> Instituto de Fisica de Cantabria (IFCA)
> Santander, Spain
> Tel: +34942200969
> ####################################
> Bertrand Russell:
> *"El problema con el mundo es que los estúpidos están seguros de todo y
> los inteligentes están llenos de dudas*"
>
--
####################################
Iban Cabrillo Bartolome
Instituto de Fisica de Cantabria (IFCA)
Santander, Spain
Tel: +34942200969
####################################
Bertrand Russell:
*"El problema con el mundo es que los estúpidos están seguros de todo y los
inteligentes están llenos de dudas*"
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
