|| |
++++++-+-+--+---++-+-+-++-+
1 row in set (0.00 sec)
There's your problem... your 3 bytes off your max_data_length .. which
is giving the table full error
Check: http://www.mysql.com/doc/en/Full_table.html at the bottom for
help to alter table to keep growing
Hey all, I have a table with the following size:
-rw-rw 1 mysqlmysql4.0G Aug 31 01:01 email_body.MYD
Thus if I try and insert one more row I get the error:
ERROR 1114: The table 'email_body' is full
Now I'm wondering why this is and if there is any options ot increase max
I'm not sure it has to do with the number of rows, but in any case this is what
happened:
mysql select count(*) from email_body;
+--+
| count(*) |
+--+
| 208853 |
+--+
1 row in set (0.00 sec)
mysql alter table email_body MAX_ROWS=70;
Query OK, 315 rows affected
On 4 Sep 2003 at 10:13, Keith Bussey wrote:
-rw-rw 1 mysqlmysql4.0G Aug 31 01:01 email_body.MYD
Thus if I try and insert one more row I get the error:
ERROR 1114: The table 'email_body' is full
By default, MyISAM tables use 4-byte pointers to indicate positions
in the
On 4 Sep 2003 at 10:53, Keith Bussey wrote:
Your suggestion seemed to wipe out my rows ! (s'ok I got a backup ;p)
Yikes! Are you running into any file system limits? Have you dealt
with files larger than 4 GB on that server before with no problems?
If not, you may have run into a MySQL bug
I also had table is full error, today
actually.
mysql alter table mytable max_rows = 2000 avg_row_length=50;
mysql show table status like 'mytable' \G
*** 1. row ***
Name: mytable
Type: MyISAM
Row_format
Most likely it's the 4GB OS limitation... My suggestion is to create a
new table using mysql's built in raid option... span the table over
multiple files to allow of much larger table growth...
migrate all the rows over to the new spanned table..
On Thu, 4 Sep 2003, Keith C. Ivey wrote:
I do have another Database on the same machine which has a table that is a lot
bigger (about 9 GIGs) and it wasn't created with any of the special table
options suggested by Keith C. Ivey below.
The difference is this table has many more fields, while the email_body one (the
one with the problem)
Hrm.. interesting.. I know I've personally hit the 4gb limit before and
had to do a fix for it.. but never hit an internal tablesize limitation..
You didn't mention what version of mysql your running...
Also if the table has alot of columns and 1 of more of those columns has
alot of data,
On 4 Sep 2003 at 15:31, Keith Bussey wrote:
I do have another Database on the same machine which has a table that
is a lot bigger (about 9 GIGs) and it wasn't created with any of the
special table options suggested by Keith C. Ivey below.
Does the other table have fixed-length records (no
Quoting Colbey [EMAIL PROTECTED]:
Hrm.. interesting.. I know I've personally hit the 4gb limit before and
had to do a fix for it.. but never hit an internal tablesize limitation..
You didn't mention what version of mysql your running...
I mentioned in my original email
Quoting Keith C. Ivey [EMAIL PROTECTED]:
On 4 Sep 2003 at 15:31, Keith Bussey wrote:
I do have another Database on the same machine which has a table that
is a lot bigger (about 9 GIGs) and it wasn't created with any of the
special table options suggested by Keith C. Ivey below.
Does
that has no text fields (in my case
atleast) ?
No, as I understand it, any MyISAM table with dynamic records should
give the table full error when it reaches 4 GB, if it was created
without specifying MAX_ROWS or AVG_ROW_LENGTH. If your other table
doesn't have fixed-length records and was created
|| |
++++++-+-+--+---++-+-+-++-+
1 row in set (0.00 sec)
There's your problem... your 3 bytes off your max_data_length .. which
is giving the table full error
Check: http://www.mysql.com
On 4 Sep 2003 at 16:54, Keith Bussey wrote:
Thanks I will make new tables and transfer the data over =)
Just wodnering though, any advice on how to tell what to set
AVG_ROW_LENGTH to ?
Eh? Isn't that was I was saying 5.5 hours ago? This isn't anything
new. Here's the message again in
... your 3 bytes off your max_data_length .. which
is giving the table full error
Check: http://www.mysql.com/doc/en/Full_table.html at the bottom for
help to alter table to keep growing
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I am getting a table is full error but a show table status on the table specified in
the error, which I assume is a temporary table, comes back as the empty set.
I did the same for the two tables being merged and they are way under the limit as far
as pointer size and table size (both having
17 matches
Mail list logo