May 25, 2012

Post: Heikki Tuuri Innodb answers - Part I

the WHERE condition in a search. Please use this with care: you MUST use row-based binlogging and replication, and remember that theInnoDB‘s log must have the transactions in the same order, for a recovery based on MySQL‘s binlog to work. Of course, if you

Post: Bug#12704861

you can find it in the bzr tree if you‘re so interested). The first paragraph of the commit message is rather telling: Theare into InnoDB internals: The fix of Bug#12612184 broke crash recovery. When a record that contains off-page columns (BLOBs) is updated, we must

Comment: How to calculate a good InnoDB log file size

InnoDB: ERROR: the age of the last checkpoint is 9434190, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB