Lots of different combinations of mysqldump options. No effect.
Resizing the number of dump files, up to an including 1 dump file for each of the 557 tables. Shaves 2-5 seconds off at best.
Lots of different combinations of mysqldump options. No effect.Setting the DB properties that are dynamic with the following. No effect.
Resizing the number of dump files, up to an including 1 dump file for each of the 557 tables. Shaves 2-5 seconds off at best.db.run("SET GLOBAL max_allowed_packet=1073741824;"); db.run("SET GLOBAL innodb_flush_log_at_trx_commit=2;");
Current Settings
mariaDb.getConfiguration().addArg("--innodb_doublewrite=0");
mariaDb.getConfiguration().addArg("--innodb_autoinc_lock_mode=2");
mariaDb.getConfiguration().addArg("--innodb_flush_log_at_trx_commit=2");
mariaDb.getConfiguration().addArg("--max_allowed_packet=536870912");
mariaDb.getConfiguration().addArg("--innodb-buffer-pool-size=536870912");