On 08/06/17 13:47, 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 ?
Hi Ulrich, Yes, you'd have to recompile with --disable-batch-insert. There is no configuration directive to enable/disable it, or command to enable/disable it interactively. I certainly wouldn't ask you to test the change in a production environment. I also wouldn't be testing (or running) against MyISAM in the first place. Honestly, the MyISAM storage engine is *LONG* past its expiration date, and Oracle is actively working towards removing support for it. I fully expect it to be disabled by default in MySQL 8. It is fragile, and its concurrent performance in write-heavy loads is just terrible. A *substantial* number of the customer site-performance issues we see at my employer are directly attributable to MyISAM. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ 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
