Steve Ruby writes:
>
>
> 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.
Hi!
I guess you mean
autocommit=0
insert ..
commit
It makes sense.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
