… answers to the second portions of the questions you asked Heikki. If you have not seen the first part it can… the answers under PZ and will use HT for original Heikkis answer. Q26: You also say on Unix/Linux only one… would take days to do operations on them. Idea for Heikki – it should be possible to implement online reorganize which locks…

… example you give is: DELETE FROM USERS WHERE NAME LIKE “%Heikki%”; First of all, mysql will not be able to use… of records (or zero records) that have a NAME with Heikki in it. No consider the following schedule: BEGIN BEGIN [nothing happens here] INSERT “fooHeikkibar” DELETE WHERE NAME LIKE “%Heikki%”; [nothing happens here] INSERT “barHeikkifoo” END END In this schedule…

At Users Conference Heikki did good presentation about Innodb planned features. I did not … has which in certain cases makes them 10 times + larger. Heikki plans to have gzip like page compression but it would… so it is not easy to fix. But I guess Heikki will have to do it otherwise with raise of MultiCores…

…€”— TR1 – BEGIN TR1 – DELETE FROM USERS WHERE NAME LIKE “%Heikki%”; TR2 – BEGIN TR2 – INSERT INTO USERS VALUES(“HeikkiTuuri”); TR2 – END TR1 – SELECT NAME FROM USERS WHERE NAME LIKE “%Heikki%” LOCK IN SHARE MODE TR1 – END If the DELETE statement…