> -----Original Message----- > From: Lou Olsten [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 13, 2004 6:45 AM > To: [EMAIL PROTECTED] > Subject: InnoDB Questions > > Need someone with some insight or experience with InnoDB (Heikki?? :-) > > a) Where does InnoDB store all of this information (such as the deleted > rows)? In the InnoDB tablespace?
In the innodb transaction logs, usually 2 of them are created with an archive log > b) How long is it stored? It's flushed on commit and/or every few seconds > c) Can we (users) control any of this? > Sort of but not as fine grain as it seem your indicating. > 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? No, other then looking at show table status and looking at pages free. > Look up innodb start up options on mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]