MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Aman Raheja Date:July 26 2004 6:03pm
Subject:Re: File size limits with mysql 4.1
View as plain text  
You must be getting an error code when inserting now.
If that is related to index file size (that's what I had)
.
You can do ALTER TABLE <tablename> MAX_ROWS=<big_num>


On Mon, 2004-07-26 at 11:48, Michael Dykman wrote:
> I am using a development build of 4.1.3 (the last 4.1.3 release I think;
> mysql-4.1.3-beta-nightly-20040628) so I suppose I have this coming, but
> here goes:
> 
> As I am running on RH Enterprise Server 3 with a Pentium Xeon (32-bit)
> According to the documentation, for a 32 bit processor, I should be able
> to grow data files to 16G on a 32 bit system, assuming the OS supports
> it.  I am using the ext3 file system which should support at least 2TB.
> However, I had all insertions to one table grind suddenly to a halt when
> the data grew to 4294967292 bytes (2^32-2).
> 
> Has anyone else encountered this or have any practical advice on how to
> transcend this limitation?
> 
> 
> -- 
>  - michael dykman
>  - michael@stripped
-- 
Aman Raheja		      Linux+ Certified
araheja@stripped	      Brainbench Certified Linux (General) Admin
www.TechQuotes.com	      Brainbench Certified Linux (RedHat 9) Admin

Thread
File size limits with mysql 4.1Michael Dykman26 Jul
  • Re: File size limits with mysql 4.1Aman Raheja26 Jul
  • Re: File size limits with mysql 4.1Paul DuBois26 Jul
    • Re: File size limits with mysql 4.1Michael Dykman26 Jul
    • Re: File size limits with mysql 4.1Michael Dykman26 Jul