RE: Avg_row_length

[Jennifer Goodie]

I am not a guru, but I figured I'd try to answer anyway.  It needs an extra
bit because it has NULLs.  I think it uses the bit to mark if the field is
NULL or not, but I've been known to be wrong.

http://www.mysql.com/doc/en/Data_size.html



---------
Dear gurus,

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

TIA,