thank you, raymond -----Original Message----- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 28, 2006 16:07 To: Jacob, Raymond A Jr; mysql@lists.mysql.com Subject: Re: Sorry for the dumb question how do I fix table is full?
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]
