Re: 4G file limit - solved

[Veysel Harun Sahin]

Yes, setting up MAX_ROWS parameter is the right solution i think. I have tried it with "alter table" command and it seems to work.

Thanks all.

[EMAIL PROTECTED] wrote:

Hi,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih this is to add
the MAX_ROWS table option when creating the table, just make it a
really large number like 5000000000. You can verify this effect by
BEFORE makeing the change, use SHOW TABLE STATUS LIKE 'MYTABLE' .
Then look at the max_data_length column. Before you change it will be
this 4294967295 (4.0G), after your change it will be something like
1099511627775.

Yes, the error message does not make sense. I have not had time to
build a test case to get to MySQL so they can give us a better error
message.

See this manual page for info on create table.
http://www.mysql.com/doc/C/R/CREATE_TABLE.html

You can just alter the table with this option.

Hope this helps,

----- Original Message -----
From: "Veysel Harun Sahin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 4:49 AM
Subject: 4G file limit

Hello,

I am using mysql3.23.49 on openbsd3.2. I have a myisam table with 4G
file size and now I can no longer insert records into table. My

mysql

data partition is not full (%24 used). I have read that mysql 3.23
supports up to 2 terabytes table size. Not so sure but I know

openbsd's

file size limit is bigger than 4G. Here is my error log.

Failed on my_net_write, writing to stderr instead: Found block with

too

small length at 4294914928; Skipped
Failed on my_net_write, writing to stderr instead: Found block that
points outside data file at 4294915080

Any comments?

Thanks.

mysql, sql




--------------------------------------------------------------------

-

Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail

<[EMAIL PROTECTED]>

Trouble unsubscribing? Try:

http://lists.mysql.com/php/unsubscribe.php

--
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php