Re: Avg_row_length

[Dan Nelson]

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