Due to the fact that piping a table from mysqldump to an INNODB table
can be as much as 30X slower if the insert is not done with
transactions,
would it make sense to add some option to mysqldump to make every X
inserts a transaction.
for example
mysqldump --transactionrows=100000 mydatabase | mysql -hsomeserver
database
where the above would wrap every 100,000 inserts with begin; commit;
right now it is non-trivial to insert the transaction
lines every so often, or even around all of the data.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
