MySQL Forums
Forum List  »  Perl

Re: Calculate the variable-length key size:
Posted by: Rick James
Date: August 30, 2008 03:34PM

Unclear what the question is -- you say "key size" and then "columns within the row". Are you interested in Index or Data?

The formula looks pretty good for MyISAM data. InnoDB is quite different.

By executing SHOW TABLE STATUS and parsing it into an array of hashes, you can get the actual "average row length" (correctly for MyISAM, approx for InnoDB).

Options: ReplyQuote

Written By
Re: Calculate the variable-length key size:
August 30, 2008 03:34PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.