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]

steve wrote:

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.

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]

"Bill Karwin1" wrote:

steve wrote:

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.

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.

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