Re: Avg_row_length

[Keith C. Ivey]

On 16 Jan 2003, at 0:37, Stefan Hinz wrote:

> > There's a formula to calculate the row length for dynamic MyISAM
> > tables here:
> >    http://www.mysql.com/doc/en/Dynamic_format.html
> 
> Thanks for the hint, but this doesn't explain fixed length row
> calculations where char(10) will give an average row length of 11
> (bytes), or does it?

You're right, it doesn't.  I forgot that you were talking about fixed-
length records.  I'm afraid I don't have anything else to add then, 
since I know nothing about the storage format other than what I've 
seen in the documentation.

[Filter fodder: SQL]

-- 
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org
Phone [phone]