Need someone with some insight or experience with InnoDB (Heikki?? :-) 1) According to a book I'm reading (High Performance MySQL) InnoDB uses MVCC, effectively allowing readers to not block writers. In Oracle (with which I am more familiar) this is accomplished via rollback segments, and now, undo tablespaces. Occasionally, if the rollback data overwrites itself, you can get a "Snapshot too old" message. But you can control the size and number of the rollback segments to fit your system. So, my InnoDB questions are:
a) Where does InnoDB store all of this information (such as the deleted rows)? In the InnoDB tablespace? b) How long is it stored? c) Can we (users) control any of this? 2) Another question I have is surrounding fragmentation. Is there a way I can monitor my InnoDB tables to see the level of fragmentation on the table and/or indexes? Thanks very much for any help that you can provide. BTW, though I'm not finished, I'm very much enjoying the book and would recommend it for someone like me who is new to MySQL but experienced in other RDBMS's. Lou
