Timeline for What dump file options or MariaDB setting is slowing down the load of data?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 24, 2017 at 0:29 | comment | added | unwrittenrainbow | With these 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"); I got 139 seconds. :( | |
| Aug 23, 2017 at 19:36 | comment | added | unwrittenrainbow | I'm not sure how to edit properties that are normally in the my.cnf file, as this is a Spring Bean. | |
| Aug 23, 2017 at 4:50 | history | answered | Evan Carroll | CC BY-SA 3.0 |