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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
