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,mysql
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
data partition is not full (%24 used). I have read that mysql 3.23openbsd's
supports up to 2 terabytes table size. Not so sure but I know
file size limit is bigger than 4G. Here is my error log.too
Failed on my_net_write, writing to stderr instead: Found block with
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:<[EMAIL PROTECTED]>
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
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