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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
