Set Autocommit=0 In Data Dump

[j_freeman]

In the Dump Data dialog, there's a checkbox for “Set FOREIGN_KEY_CHECKS=0”. Why not have a similar option such as “Set AUTOCOMMIT=0”? Checking the option would do something like this to the batch file:

Code:

SET AUTOCOMMIT=0;
/* batch file statements here */
COMMIT;

Currently I'm doing that manually, and it makes all the difference in import time with databases that have InnoDB tables. We're talking 1-2 minutes vs. 10+ minutes. 😀

[peterlaursen]

Basically we know that we will soon need to focus a little more on transactions with SQLyog!

Undoubtedly MyISAM will gradually disappear and be replaced by transactional engines (innoDB, Falcon, SolidDB, Primebase).

I think that we can start working on this late summer/early autumn!

[j_freeman]

Looking forward to what the future holds! 🙂

[Author]

Posts