I agree it's not very clear. I think Brent's example is perfect:
ALTER TABLE data max_rows=100000000 (or whatever number you believe is appropriate for your table) Dan On 6/28/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote:
The documentation does not seem very clear, at least me on how to increase the max_rows. Could you give me an example? Thank you raymond -----Original Message----- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 28, 2006 15:38 To: Jacob, Raymond A Jr Cc: mysql@lists.mysql.com Subject: Re: Sorry for the dumb question how do I fix table is full? Your table has just about max'd out - you're using 4,294,967,280 bytes out of a maximum of 4,294,967,295 bytes (15 bytes free). You need to tell mysql to expand this table, with an alter table command to increase max rows: http://dev.mysql.com/doc/refman/5.0/en/table-size.html Dan On 6/28/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote: > mysql> SHOW TABLE STATUS LIKE 'data'; > +------+--------+---------+------------+---------+----------------+--- > +------+--------+---------+------------+---------+----------------+-- > --------+-----------------+------ > --------+-----------+----------------+---------------------+---------- > --------+-----------+----------------+---------------------+-- > ---------+------------+---------- > ---------+----------+----------------+---------+ > | Name | Engine | Version | Row_format | Rows | Avg_row_length | > Data_length | Max_data_length | Index > _length | Data_free | Auto_increment | Create_time | Update_time > | Check_time | Collation > | Checksum | Create_options | Comment | > +------+--------+---------+------------+---------+----------------+--- > +------+--------+---------+------------+---------+----------------+-- > --------+-----------------+------ > --------+-----------+----------------+---------------------+---------- > --------+-----------+----------------+---------------------+-- > ---------+------------+---------- > ---------+----------+----------------+---------+ > | data | MyISAM | 9 | Dynamic | 8593198 | 499 | > 4294967280 | 4294967295 | 11 > 5791872 | 0 | NULL | 2006-03-02 18:47:02 | 2006-06-09 > 21:08:48 | NULL | latin1_sw > edish_ci | NULL | | | > +------+--------+---------+------------+---------+----------------+--- > +------+--------+---------+------------+---------+----------------+-- > --------+-----------------+------ > --------+-----------+----------------+---------------------+---------- > --------+-----------+----------------+---------------------+-- > ---------+------------+---------- > ---------+----------+----------------+---------+ > 1 row in set (0.07 sec) > > mysql> > > -----Original Message----- > From: Dan Buettner [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 28, 2006 12:43 > To: Jacob, Raymond A Jr > Cc: mysql@lists.mysql.com > Subject: Re: Sorry for the dumb question how do I fix table is full? > > Raymond, can you post the output of > > SHOW TABLE STATUS LIKE 'data'; > > that should show how big your table is and how big it can be... > > Dan > > > > On 6/28/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote: > > Environment: Freebsd 6.0 > > Mysql : mysql Ver 14.7 Distrib 4.1.18, for porbld-freebsd6.0 (i386) > > using 5.0 > > > > On the client, I get /var/log/messages, I get the errors: > > kernel: 9643D22706C > > and > > database: mysql_error: The table 'data' is full SQL=INSERT INTO data > > (sid,cid,data_payload) VALUES" > > > > > > I have 7Gig free on the database Server. > > > > I assumed tables became full when I ran out of disk space. I guess I > > was wrong. > > > > On the server /var/log/messages is clear except for entries when I > > ran > > > out of disk space On June 3,2006. > > > > Please tell what do I need to do stop the client from generating > > error > > > messages and sending Data to the server? > > > > Thank you, > > raymond >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
