From: Dan Nelson
Date: January 15 2003 12:22am
Subject: Re: Avg_row_length
List-Archive: http://lists.mysql.com/mysql/129956
Message-Id: <20030115002255.GF42135@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jan 14), Stefan Hinz said:
> here's my final stupid question for today. Why is the average row
> length 11 when it should be 10?
> 
> mysql> DESCRIBE myrowisam;
> +-------+----------+------+-----+---------+-------+
> | Field | Type     | Null | Key | Default | Extra |
> +-------+----------+------+-----+---------+-------+
> | col   | char(10) | YES  |     | NULL    |       |
> +-------+----------+------+-----+---------+-------+
> 
> mysql> SHOW TABLE STATUS LIKE 'myrow%';
> +-------------+--------+------------+------+----------------+
> | Name        | Type   | Row_format | Rows | Avg_row_length |
> +-------------+--------+------------+------+----------------+
> | myrowisam   | MyISAM | Fixed      |   68 |             11 | <---

 * Each `NULL' column takes one bit extra, rounded up to the nearest
   byte.


-- 
	Dan Nelson
	dnelson@stripped