List:General Discussion« Previous MessageNext Message »
From:Dan Buettner Date:June 28 2006 8:06pm
Subject:Re: Sorry for the dumb question how do I fix table is full?
View as plain text  
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 <raymond.jacob@stripped> 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:drbuettner@stripped]
> Sent: Wednesday, June 28, 2006 15:38
> To: Jacob, Raymond A Jr
> Cc: mysql@stripped
> 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 <raymond.jacob@stripped> 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:drbuettner@stripped]
> > Sent: Wednesday, June 28, 2006 12:43
> > To: Jacob, Raymond A Jr
> > Cc: mysql@stripped
> > 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 <raymond.jacob@stripped> 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
> >
>
Thread
Sorry for the dumb question how do I fix table is full?Raymond A Jr Jacob28 Jun
  • Re: Sorry for the dumb question how do I fix table is full?Dan Buettner28 Jun
    • RE: Sorry for the dumb question how do I fix table is full?Raymond A Jr Jacob28 Jun
      • Re: Sorry for the dumb question how do I fix table is full?Brent Baisley28 Jun
      • Re: Sorry for the dumb question how do I fix table is full?Dan Buettner28 Jun
Re: Sorry for the dumb question how do I fix table is full?Dan Buettner28 Jun
  • RE: (thank you) Sorry for the dumb question how do I fix table is full?Raymond A Jr Jacob28 Jun