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).
Subject
Written By
Posted
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.