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
4545
January 21, 2005 07:49AM
2822
January 21, 2005 07:53AM
2793
January 21, 2005 03:52PM
2707
January 25, 2005 04:57PM
Re: Problem of data corruption
2934
January 27, 2005 02:55AM
2855
February 16, 2005 07:58AM
2635
February 25, 2005 06:54AM
2661
March 03, 2005 03:07AM
2853
February 16, 2005 11:15AM
3626
February 17, 2005 03:40AM
2695
February 17, 2005 03:25PM
2667
March 17, 2005 01:55AM
2661
March 18, 2005 11:19AM
3010
March 31, 2005 01:04PM
2706
April 04, 2005 08:21AM
2878
April 04, 2005 09:24AM
3043
April 04, 2005 11:38PM
2700
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.