try this link http://jeremy.zawodny.com/blog/archives/000796.html
setting avg_row_length at 50 worked for me I tested and got
mytable up to 9GB, (large table with variable size records )
the only reason I could see that it would matter to have an accurate
value for the avg_row_length would
I'm not too familiar with this.. someone else today used the value 50,
when in fact based on their avg_row_length being reported as:
Avg_row_length: 2257832
Your average row length is reported as:
Avg_row_length = 20564
From: http://www.mysql.com/doc/en/CREATE_TABLE.html
AVG_ROW_LENGTH A
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
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 ?
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting [EMAIL PROTECTED]:
>
> On Thu, 4 Sep 2003, Keith Bussey wrote:
> >
On Thu, 4 Sep 2003, Keith Bussey wrote:
> Running that shows me the following:
>
> mysql> SHOW TABLE STATUS FROM email_tracking LIKE 'email_body_old';
> ++++++-+-+--+---++---
On 4 Sep 2003 at 16:10, Keith Bussey wrote:
> The MYI for that table is 1.7M, and no the text field isn't indexed
>
> Other table has all fixed-length records except 2 varchar fields
>
> Thus, if I understand right, then because the field is text it uses
> more pointers than a larger table t
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 belo
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 ;p.4.0.13-
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 V
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, perh
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)
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:
> O
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
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
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 t
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 (0
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 tab
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
Hi,
I constantly get error messages like "ERROR 1114: The table 'SQL4b3_0'
is full" for a fairly simple query.
It works if I leave the "ORDER BY" away, but I really need that. The
result only has something like 2500 Results and there is an index on the
field by which I want to sort.
What can I d
19 matches
Mail list logo
