Tobias,
- Alkuperäinen viesti -
Lähettäjä: "Tobias Asplund" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio:
Lähetetty: Tuesday, February 08, 2005 7:46 PM
Aihe: Re: InnoDB crash and runaway rollback - help pls
On Tue, 8 F
On Tue, 8 Feb 2005, Heikki Tuuri wrote:
> You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
> 000 rows, and a runaway rollback can no longer happen.
This is very nice!
Are there any plans for the same with INSERT ... SELECT -type statements?
--
MySQL General Mailing List
Devananda,
the ALTER TABLE creates a temporary table #sql... The rollback is running in
that table. The manual contains instructions on how to rename and drop such
table.
You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
000 rows, and a runaway rollback can no longer hap
