try this link http://jeremy.zawodny.com/blog/archives/000796.html setting avg_row_length at 50 worked for me I tested and got mytable up to 9GB, (large table with variable size records ) the only reason I could see that it would matter to have an accurate value for the avg_row_length would be if mysqld uses that value to make reads and writes faster. I too would like to know more, mysqld is fast, I would hate to slow it down in any way if it could be prevented. > On Thu, 2003-09-04 at 17:02, [EMAIL PROTECTED] wrote: > > > > 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] > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
