Hi Michael,
maybe something 'off topic'...
I think a option to set 'autocommit=0' is needed.
Last week I have made some data manipulation, stupidly my 'where condition' was
not correct. After pressing 'return', mysql returns with '4576 rows affected'.
Not that was I expected...
I didn't set autocommit=0 after starting mysql, so I have to restore my DB
What do you think about this option?????????
Andre
On 16-May-01 Michael Widenius wrote:
>
> Hi!
>
>>>>>> "Steve" == Steve Ruby <[EMAIL PROTECTED]> writes:
>
> Steve> Due to the fact that piping a table from mysqldump to an INNODB table
> Steve> can be as much as 30X slower if the insert is not done with
> Steve> transactions,
> Steve> would it make sense to add some option to mysqldump to make every X
> Steve> inserts a transaction.
>
> Steve> for example
>
> Steve> mysqldump --transactionrows=100000 mydatabase | mysql -hsomeserver
> Steve> database
>
> Steve> where the above would wrap every 100,000 inserts with begin; commit;
> Steve> right now it is non-trivial to insert the transaction
> Steve> lines every so often, or even around all of the data.
>
> I don't think we actually need the above option.
>
> Try using the --quick option to mysqldump.
>
> This will MUCH faster for InnoDB, because it inserts up to 16M of data
> at a time (instead of just single rows).
>
> Could you test the above on your tables? If it doesn't give adequate
> performance, then we have to consider adding begin-ends to mysqldump.
>
> The problem with having very long transactions is that they could actually
> make things go slower because you get much bigger rollback segments.
> (I assume that if I am wrong, Heikki will correct me ...)
>
> Regards,
> Monty
>
> ---------------------------------------------------------------------
> 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
----------------------------------
E-Mail: [EMAIL PROTECTED]
Date: 17-May-01
Time: 08:52:00
() Join the ASCII ribbon campaign against html email
/\ and Microsoft attachments.
"I heard if you play the NT-4.0-CD backwards, you get a satanic message"
"That is nothing, if you play it forward, it installs NT-4.0"
----------------------------------
---------------------------------------------------------------------
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
