Tobias,
----- Alkuperäinen viesti ----- Lähettäjä: "Tobias Asplund" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <mysql@lists.mysql.com>
Lähetetty: Tuesday, February 08, 2005 7:46 PM
Aihe: Re: InnoDB crash and runaway rollback - help pls
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?
the problem in INSERT ... SELECT ... is that if we commit that kind of statement at every 10 000 rows, and mysqld crashes, then we cannot roll back the entire SQL statement, and the binlog will not be consistent with the actual contents of the database.
Regards,
Heikki
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
