junior carvalho wrote:
> hi all,
> Im using bacula 1.38 for make backup of 2 servers that has almost the same
> setup, the only difference is the number o files.
> One server have +/- 400.000 files, and the second have +/- 1.200.000 files.
> The size of data is almost the same too: 460GB. I have add lots of indexes
> for mysql, i used optimize table but the second server spends +/- 4 hours to
> show the list of files when is want to restore something ( restore command
> with only one jobid ), against 5 mins for the first server. I know that the
> base for the second server has a lot of lines more than the first, but my
> question is "how can i do this job more faster??" because this twos server
> are good machines, and during this time ( query to mysql ) the machine has
> just 25% of processor used. I already try buffer_size , ram used for mysl,
> put the base ( mysql base ) is a single disk, in a raid5 disk, nut none o
> this solve my problem. Can anyone help-me?
> JC
>
Did you have a "muscle" config for mysql ( based on my-huge.conf ) for your
my.cnf server conf ?
For the director on which mysql reside and that is doing only bacula we
increase quiet a lot the proposed value
to make mysql more happy with insert and query for backup.
a building tree for a typical session for 650,891 files and 245Go take less
than 2 minutes
on a AMD x2 6000 proc with 4Go ram.
Mysql reside on a single sata 7200trms disk.
here our values
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
#skip-locking
key_buffer = 512M
max_allowed_packet = 2M
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 128M
thread_cache_size = 12
query_cache_size= 84M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
character-set-server=utf8
default-collation=utf8_general_ci
[isamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 4M
write_buffer = 4M
[myisamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 4M
write_buffer = 4M
skip-innodb
skip-bdb
Last point we don't use the batch-insert mode.
Hope this help you a bit.
--
Bruno Friedmann
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|