MySQL Forums
Forum List  »  InnoDB

Re: Problem of data corruption
Posted by: Mickael Garnier
Date: January 27, 2005 02:55AM

Hi,

I haven't set the value to 2000M but I don't think this could be the problem.
I use a kernel 2.6.3 and the support for the big file is included. With the ext2 FS, the max size for a file is 2To.

I noticed that the corruption was everytime on the same table, whose index was on a column with a type of varchar(255). I removed the index and I noticed no more corruption, until this morning :o(
The table is again the same and has a primary key with a column of type varchar(255) !

The only parameter I change between yesterday and today was the size of the innodb_buffer_pool_size. I changed it from 384M to 512M.

I begin to believe that the pb is not OS/driver/hardware as says Heikki, but is in Mysql/innodb and the index or primary key with column's type varchar(255).

Heikki, can you help me findind a solution ?

Best regards,
Mickael

Options: ReplyQuote


Subject
Views
Written By
Posted
4329
January 21, 2005 07:49AM
2731
January 21, 2005 07:53AM
2679
January 21, 2005 03:52PM
2616
January 25, 2005 04:57PM
Re: Problem of data corruption
2850
January 27, 2005 02:55AM
2756
February 16, 2005 07:58AM
2548
February 25, 2005 06:54AM
2568
March 03, 2005 03:07AM
2771
February 16, 2005 11:15AM
3528
February 17, 2005 03:40AM
2580
February 17, 2005 03:25PM
2577
March 17, 2005 01:55AM
2571
March 18, 2005 11:19AM
2900
March 31, 2005 01:04PM
2617
April 04, 2005 08:21AM
2795
April 04, 2005 09:24AM
2971
April 04, 2005 11:38PM
2612
April 19, 2005 09:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.