A simple question regarding storage allocated / reported by MySQL/InnoDB.
If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns,
why is the reported avg. row length 148 bytes?
mysql> show table status from pmsystem2 like 'editor_competence_product'\G
*************************** 1. row ***************************
Name: editor_competence_product
Type: InnoDB
Row_format: Fixed
Rows: 152100
Avg_row_length: 148
Data_length: 22626304
Max_data_length: NULL
Index_length: 23199744
Data_free: 0
Auto_increment: NULL
Create_time: NULL
Update_time: NULL
Check_time: NULL
Create_options:
Comment: kompetence techniku; InnoDB free: 6144 kB; (zipid) REFER
pmsystem2/zip(id) ON DELETE CASCADE; (brandid) REFER pmsystem2/brand(id) ON DELETE
CASCADE; (editorid) REFER pmsystem2/editor(id) ON DELETE CASCADE
1 row in set (0.18 sec)
mysql> desc pmsystem2.editor_competence_product;
+-----------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| zipid | bigint(20) unsigned | | PRI | 0 | |
| brandid | bigint(20) unsigned | | PRI | 0 | |
| productid | bigint(20) unsigned | | PRI | 0 | |
| editorid | bigint(20) unsigned | | PRI | 0 | |
+-----------+---------------------+------+-----+---------+-------+
4 rows in set (0.02 sec)
BTW InnoDB deserves much more detailed documentation. As it is, the more
interesting the read the less information is provided. :)
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
