Skip to main content
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
added 183 characters in body
Source Link
  1. Lots of different combinations of mysqldump options. No effect.

  2. 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.
  3. Setting the DB properties that are dynamic with the following. No effect.

         db.run("SET GLOBAL max_allowed_packet=1073741824;");
         db.run("SET GLOBAL innodb_flush_log_at_trx_commit=2;");
    
    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.

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");
  1. Lots of different combinations of mysqldump options. No effect.

  2. 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.

  3. Setting the DB properties that are dynamic with the following. No effect.

         db.run("SET GLOBAL max_allowed_packet=1073741824;");
         db.run("SET GLOBAL innodb_flush_log_at_trx_commit=2;");
    
  1. Lots of different combinations of mysqldump options. No effect.
  2. 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.

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");
Post Reopened by Hannah Vernon, RDFozz, Paul White
edited title
Link

What dump file options or MariaDB settingssetting is slowing down the load of data?

edited tags
Link
added 562 characters in body; edited title
Source Link
Loading
Post Closed as "Needs details or clarity" by Marco, John K. N., Colin 't Hart, mustaccio, SqlWorldWide
Source Link
Loading