Its almost a month since I promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I got answers to… you delete a lot of scattered rows you may not see a “free space” in Innodb tablespace to grow significantly. Q6: Does Innodb… MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages per flush. That…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
At Users Conference Heikki did good presentation about Innodb planned features. I did not see some of big and … delete. For Insert operation Innodb uses nice tecnique called Insert Buffer which speeds up inserts for non-unique indexes a lot. However deletes… to fix. But I guess Heikki will have to do it otherwise with raise of MultiCores Innodb will become unusable for more…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… or broken down RAID. We can undelete Innodb data – Heikki was very nice and treats deleted rows very gently allowing them to be 100% recovered if they were not overwritten yet, as well as recover dropped Innodb… task to write more details about Innodb data recovery process and release code for our innodb recovery toolset, so you can recover…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
… done beause Innodb can only lock current version of row. Think about similar case and row being deleted. Even if Innodb would be… missing in Innodb locking.? In my oppinion few rather important peices missing in Locking implementation of Innodb are: Lock table Innodb can lock…. Unlocking non matched rows Imagine you’re running DELETE FROM USERS WHERE NAME LIKE “%Heikki%”; How any rows do you think will…
