I'm not too familiar with this.. someone else today used the value 50, when in fact based on their avg_row_length being reported as:
Avg_row_length: 2257832 Your average row length is reported as: Avg_row_length = 20564 From: http://www.mysql.com/doc/en/CREATE_TABLE.html AVG_ROW_LENGTH An approximation of the average row length for your table. You only need to set this for large tables with variable size records. So if you are using a fixed length records, you don't need this.. otherwise. my best guess is use say: 22000 ?? If someone else has more experience with this issue, please toll in and make a suggestion based on the above values... On Thu, 4 Sep 2003, Keith Bussey wrote: > Thanks I will make new tables and transfer the data over =) > > Just wodnering though, any advice on how to tell what to set AVG_ROW_LENGTH to ? > > -- > Keith Bussey > > Wisol, Inc. > Chief Technology Manager > (514) 398-9994 ext.225 > > > Quoting [EMAIL PROTECTED]: > > > > > On Thu, 4 Sep 2003, Keith Bussey wrote: > > > Running that shows me the following: > > > > > > mysql> SHOW TABLE STATUS FROM email_tracking LIKE 'email_body_old'; > > > > > > +----------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ > > > | Name | Type | Row_format | Rows | Avg_row_length | > > Data_length | > > > Max_data_length | Index_length | Data_free > > > | Auto_increment | Create_time | Update_time | Check_time > > > | Create_options | Comment | > > > > > > +----------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ > > > | email_body_old | MyISAM | Dynamic | 208853 | 20564 | > > 4294967292 | > > > 4294967295 | 1820672 | 0 > > > | 450438 | 2002-10-21 11:58:24 | 2003-08-31 01:01:41 | 2002-11-30 > > > 01:41:00 | | | > > > > > > +----------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ > > > 1 row in set (0.00 sec) > > > > > > There's your problem... your 3 bytes off your max_data_length .. which > > is giving the table full error.... > > > > Check: http://www.mysql.com/doc/en/Full_table.html at the bottom for > > help to alter table to keep growing.... > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
