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 director, spend many hours to save the files in the 
> catalog. This also cause low mysqld performance at all.
>
> Is there any tip to optimize the catalog operation or MySQL 
> performance to make the job less resource hungry?
>
> The job runs once a week with no concurrent jobs. Director and storage 
> runs at the same computer but the client is another server, at the 
> same network who can transport up to 1Gb of data between the servers.
>
> Any tips will be apretiated.
>
>
Hello,

InnoDB ? MyISAM ?
tuning-primer.sh + mysqltuner.pl please...

Best regards.
Jerome Blion.

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users