# [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.
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
