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" <[EMAIL PROTECTED]>
To: "Dan Buettner" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
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:[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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
