202 File size limit exceeded

[steve]

I am setting up a huge database in mysql, and I get the above error in
Linux. I believe it is related to the size of one of my tables, which
is 4,294,966,772 bytes in size. Can someone help. How can I break
that barrier.

A google search did not turn up anything useful.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-202-Fi...ict212659.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=727265

[Bill Karwin]

Re: 202 File size limit exceeded

steve wrote:[color=blue]
> I am setting up a huge database in mysql, and I get the above error in
> Linux. I believe it is related to the size of one of my tables, which
> is 4,294,966,772 bytes in size. Can someone help. How can I break
> that barrier.[/color]

Did you find these pages?

http://dev.mysql.com/doc/mysql/en/table-size.html

http://jeremy.zawodny.com/blog/archives/000796.html

Also read this following excerpt from the Bugzilla manual:

By default, MySQL will limit the size of a table to 4GB. This limit is
present even if the underlying filesystem has no such limit. To set a
higher limit, follow these instructions.

Run the MySQL command-line client and enter:

mysql> ALTER TABLE attachments
AVG_ROW_LENGTH= 1000000, MAX_ROWS=20000;


The above command will change the limit to 20GB. Mysql will have to make
a temporary copy of your entire table to do this. Ideally, you should do
this when your attachments table is still small.

Regards,
Bill K.

[steve]

Re: Re: 202 File size limit exceeded

"Bill Karwin1" wrote:[color=blue]
> steve wrote:[color=green]
> > I am setting up a huge database in mysql, and I get the[/color]
> above error in[color=green]
> > Linux. I believe it is related to the size of one of my[/color]
> tables, which[color=green]
> > is 4,294,966,772 bytes in size. Can someone help. How can[/color]
> I break[color=green]
> > that barrier.[/color]
>
> Did you find these pages?
>
> http://dev.mysql.com/doc/mysql/en/table-size.html
> http://jeremy.zawodny.com/blog/archives/000796.html
>
> Also read this following excerpt from the Bugzilla manual:
>
> By default, MySQL will limit the size of a table to 4GB. This
> limit is
> present even if the underlying filesystem has no such limit.
> To set a
> higher limit, follow these instructions.
>
> Run the MySQL command-line client and enter:
>
> mysql> ALTER TABLE attachments
> AVG_ROW_LENGTH= 1000000, MAX_ROWS=20000;
>
>
> The above command will change the limit to 20GB. Mysql will
> have to make
> a temporary copy of your entire table to do this. Ideally, you
> should do
> this when your attachments table is still small.
>
> Regards,
> Bill K.[/color]

Hi Bill

THANK YOU!!

That solved my problem. I was thinking this was an OS limit, and was
searching in the wrong places it looks like.

Everything good now. Thanks again. The references did it, specially
the 2nd one.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-202-Fi...ict212659.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=727493