List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:January 15 2003 12:22am
Subject:Re: Avg_row_length
View as plain text  
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
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