Roman, the table is probably very fragmented. The command
ALTER TABLE pmsystem2.editor_competence_product TYPE=InnoDB; will defragment it. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL ----- Original Message ----- From: "Roman Neuhauser" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, September 23, 2003 6:38 PM Subject: innodb: storage requirements > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
