Re: Avg_row_length

[Stefan Hinz]

Keith,

thanks once again! Well, anyone here from the MySQL developer team? Or
any other guru who can explain why 10 = 11?

Here's the problem once again:

mysql> DESCRIBE myrowisam;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| col   | char(10) | YES  | MUL | NULL    |       |
+-------+----------+------+-----+---------+-------+
mysql> SHOW TABLE STATUS LIKE 'myrowisam';
+-----------+--------+------------+------+----------------+
| Name      | Type   | Row_format | Rows | Avg_row_length |
+-----------+--------+------------+------+----------------+
| myrowisam | MyISAM | Fixed      |  109 |             11 |
+-----------+--------+------------+------+----------------+

Regards,
--
  Stefan Hinz <hinz@stripped>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: [phone]  Fax: [phone]

----- Original Message -----
From: "Keith C. Ivey" <keith@stripped>
To: <mysql@stripped>
Cc: "Stefan Hinz" <hinz@stripped>
Sent: Thursday, January 16, 2003 5:05 PM
Subject: Re: Avg_row_length


> 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]