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]
