List:General Discussion« Previous MessageNext Message »
From:Keith C. Ivey Date:January 16 2003 4:05pm
Subject:Re: Avg_row_length
View as plain text  
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 202-667-6653
Thread
Avg_row_lengthStefan Hinz14 Jan
  • RE: Avg_row_lengthJennifer Goodie15 Jan
  • Re: Avg_row_lengthSteve Edberg15 Jan
  • Re: Avg_row_lengthDan Nelson15 Jan
  • Re: Avg_row_lengthStefan Hinz15 Jan
    • Re: Avg_row_lengthSteve Edberg15 Jan
    • Re: Avg_row_lengthKeith C. Ivey15 Jan
      • Re: Avg_row_lengthStefan Hinz16 Jan
        • Re: Avg_row_lengthKeith C. Ivey16 Jan
          • Re: Avg_row_lengthStefan Hinz16 Jan
            • Re: Avg_row_lengthSergei Golubchik16 Jan
            • Re: Avg_row_lengthZak Greant16 Jan
          • Re: Avg_row_lengthgerald_clark16 Jan
          • Re: Avg_row_lengthStefan Hinz16 Jan
            • Re: Avg_row_lengthSergei Golubchik17 Jan
            • Re: Avg_row_lengthRoger Baklund17 Jan
          • Re: Avg_row_lengthgerald_clark17 Jan
          • Re: Avg_row_lengthStefan Hinz17 Jan
  • Re: Avg_row_lengthStefan Hinz15 Jan
  • Re: Avg_row_lengthStefan Hinz15 Jan