 | | | (thank you) Sorry for the dumb question how do I fix table is full? | (thank you) Sorry for the dumb question how do I fix table is full? 2006-06-28 - By Jacob, Raymond A Jr
Back
thank you,
raymond
-- --Original Message-- --
From: Dan Buettner [mailto:drbuettner@(protected)]
Sent: Wednesday, June 28, 2006 16:07
To: Jacob, Raymond A Jr; mysql@(protected)
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_rows0000000
(or whatever number you believe is appropriate for your table)
Dan
On 6/28/06, Jacob, Raymond A Jr <raymond.jacob@(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:drbuettner@(protected)]
> Sent: Wednesday, June 28, 2006 15:38
> To: Jacob, Raymond A Jr
> Cc: mysql@(protected)
> 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@(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:drbuettner@(protected)]
> > Sent: Wednesday, June 28, 2006 12:43
> > To: Jacob, Raymond A Jr
> > Cc: mysql@(protected)
> > 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@(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/mysql?unsub=mysql@(protected)
|
|
|