Roman, ----- Alkuperäinen viesti ----- Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Friday, September 26, 2003 12:02 PM Aihe: Re: innodb: storage requirements
> # [EMAIL PROTECTED] / 2003-09-25 08:58:09 +0300: > > From: "Roman Neuhauser" <[EMAIL PROTECTED]> > > > > > Also, is there a way to *measure* the fragmentation of a table? > > > > > If there is, how should the info be interpreted? > > > > Sorry, no. But adding such a feature would be easy: just look at page > > numbers, page fillfactors, and the total size of the 'segment' storing > > the B-tree leaf pages. > > Having this, and other management features, in InnoDB would be a > boon. InnoDB adds much complexity to MySQL, but the administrator > doesn't have many tools to monitor its health. Many more parts that > can break, but that are not visible to the administrator. > > What I've been missing most dearly from MySQL/InnoDB lately is > documentation to the output of SHOW INNODB STATUS and friends. > Section 9.1 of the InnoDB manual doesn't cut it. > > Also, don't be afraid to dive into finer details when describing > the innards of InnoDB: I was trying to help myself before posting > here, but found that section 12 just scratches the surface. > > All in all, thanks for InnoDB, and thanks for the support. it would be nice if academic people and others would publish more papers on the internals. The page http://www.innodb.com/books.html contains some links. The source code itself contains very long comments at the start of some .c files. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL support from http://www.mysql.com/support/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
