List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 14 2004 7:20pm
Subject:Re: Problem with 2GB limit.
View as plain text  
In the last episode (Apr 14), Cesar Bonavides Martinez said:
> Thank you for your fast answer.
> 
> I tried everything you told me, but unfortunately another error
> message came through:
> 
> Here you have all what you asked me to do:
> 
> mysql> SHOW VARIABLES LIKE "large_files_support";
> +---------------------+-------+
> | Variable_name       | Value |
> +---------------------+-------+
> | large_files_support | ON    |
> +---------------------+-------+
> 
> After running the SHOW TABLE STATUS LIKE "align"; I got:
> 
> Name 		= align
> Type 		= MyISAM
> Row_format 	= Dynamic
> Rows		= 3398922
> Avg_row_length	= 631
> Data_length		= 2147625328
> Max_data_length	= 4294967295
> Index_length	= 1024
> Data_free		= 0
> Auto_increment	= NULL

Now that's interesting.  Max_data_length is set to 4gb, but you're
getting an error at 2gb.  Could it be a process resource limit?  What
does the "ulimit" command return?  You can reset that limit with the
"ulimit unlimited" command.

> Then I executed the last thing you told me. I used those values just
> to make sure I was really over the 2GB, but got the next:
> 
> mysql> ALTER TABLE align AVG_ROW_LENGTH=700 MAX_ROWS=4000000;
> ERROR 1030: Got error 127 from table handler

The could be due to resource limits also.  Mysql basically got an I/O
error trying to write past the 2gb point, so the table got marked as
crashed.  You will have to run "REPAIR TABLE align" before mysql will
let you do anything with it.

$ perror 127
127 = Record-file is crashed

-- 
	Dan Nelson
	dnelson@stripped
Thread
Problem with 2GB limit.Cesar Bonavides Martinez14 Apr
  • Re: Problem with 2GB limit.Dan Nelson14 Apr
    • RE: Problem with 2GB limit.Cesar Bonavides Martinez14 Apr
      • Re: Problem with 2GB limit.Dan Nelson14 Apr
        • Re: Problem with 2GB limit.Sean Quinlan14 Apr
          • Re: Problem with 2GB limit.Dan Nelson14 Apr
            • Re: Problem with 2GB limit.Sean Quinlan14 Apr
          • RE: Problem with 2GB limit.Cesar Bonavides Martinez14 Apr