List:General Discussion« Previous MessageNext Message »
From:Jennifer Goodie Date:January 14 2003 11:44pm
Subject:RE: Avg_row_length
View as plain text  
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,

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