Re: [Bacula-users] Too much files to save in catalog - MysQL performance tips.

2013-06-20 Thread Ralf Brinkmann
Am 17.06.2013 19:03, schrieb Luis H. Forchesatto: Is there any tip to optimize the catalog operation or MySQL performance to make the job less resource hungry? For our LTO4 tape changer I replaced /etc/my.cnf by /usr/share/mysql/my-huge.cnf also provided 1500GB diskspace for

Re: [Bacula-users] Too much files to save in catalog - MysQL performance tips.

2013-06-18 Thread lst_hoe02
Zitat von Luis H. Forchesatto luisforchesa...@gmail.com: Greetings. I'd like to discuss my situation here where I have a job who backups only 200GB in files, but it has 2 million more files to save on catalog (MySQL). When the file copy is complete the storage server, who also runs the

[Bacula-users] Too much files to save in catalog - MysQL performance tips.

2013-06-17 Thread Luis H. Forchesatto
Greetings. I'd like to discuss my situation here where I have a job who backups only 200GB in files, but it has 2 million more files to save on catalog (MySQL). When the file copy is complete the storage server, who also runs the director, spend many hours to save the files in the catalog. This

Re: [Bacula-users] Too much files to save in catalog - MysQL performance tips.

2013-06-17 Thread Jérôme Blion
Le 17/06/2013 19:03, Luis H. Forchesatto a écrit : Greetings. I'd like to discuss my situation here where I have a job who backups only 200GB in files, but it has 2 million more files to save on catalog (MySQL). When the file copy is complete the storage server, who also runs the