List:General Discussion« Previous MessageNext Message »
From:Veysel Harun Sahin Date:February 3 2003 4:14pm
Subject:Re: 4G file limit - solved
View as plain text  
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.

kenm@stripped 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" <vharun@stripped>
>To: <mysql@stripped>
>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 <mysql-thread131508@stripped>
>>To unsubscribe, e-mail
>>    
>>
><mysql-unsubscribe-kenm=icarz.com@stripped>
>  
>
>>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/


Thread
4G file limitVeysel Harun Sahin3 Feb
  • Re: 4G file limitKen Menzel3 Feb
  • re: 4G file limitEgor Egorov3 Feb
  • Re: 4G file limit - solvedVeysel Harun Sahin3 Feb