Hello Ulrich,

I obviously would be interested in seeing the statistics, and unless you take some precautions I would strongly suggest not running it on a production environment.


If you do, nevertheless, want to try, at a minimum, I would create a new database (named perhaps TestBacula. Then if you are careful to backup your catalog before experimenting, then run the tests only on the new database, you would be much less likely to mess up your production jobs.

Best regards,
Kern

On 08/06/2017 07:47 PM, Ulrich Leodolter wrote:
Hi Phil,

Phil Stracchino <ph...@caerllewys.net> hat am 6. August 2017 um 17:03 
geschrieben:

Community request:
Does anyone else here have a test environment which DOES have jobs of
that size who could perform comparison tests of the same 20-50 million
file backup job with and without batch insert?
We have one job from disk to LTO6 which has about 10 Million files and 6.6 TB.

Runs on CentOS 6.8 machine, mysql-5.1.73 MyISAM storage engine and Bacula 
Version: 7.4.8 (10 April 2017)

How can i disable batch insert, only by configure --disable-batch-inserts  and 
recompile ?

Does it make sense to do timing tests on this environment ?  Its a production 
system and i need to be careful.

Best regards
Ulrich


Ulrich Leodolter <ulrich.leodol...@obvsg.at>
Oesterreichische Bibliothekenverbund und Service GmbH
Raimundgasse 1/3, A-1020 Wien
Fax +43 1 4035158-30
Tel +43 1 4035158-21
Web https://www.obvsg.at

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to