 | | | Sorry for the dumb question how do I fix table is full? | Sorry for the dumb question how do I fix table is full? 2006-06-28 - By Brent Baisley
Back
MySQL by default limits tables to 4GB, it looks like you hit that limit. It's
fairly easy to change that limit, ideally when you
create the table. Before MySQL 5.0.6., the default pointer size was 4bytes,
which limits you to 4GB. That's the default size, if you
specify a max_rows, that size will change.
Bottom line, run this command (it may take a while):
ALTER TABLE data max_rows=100000000
I just picked 100 million as the max_rows as an arbitrary number. You can set
it lower or higher (higher than your current 8.5
million). Here are some links that go into more detail.
http://jeremy.zawodny.com/blog/archives/000796.html
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
-- -- Original Message -- --
From: "Jacob, Raymond A Jr" <raymond.jacob@(protected)>
To: "Dan Buettner" <drbuettner@(protected)>
Cc: <mysql@(protected)>
Sent: Wednesday, June 28, 2006 3:01 PM
Subject: RE: Sorry for the dumb question how do I fix table is full?
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=brenttech@(protected)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|