Re: Problem of data corruption
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
Subject
Views
Written By
Posted
4695
January 21, 2005 07:49AM
2886
January 21, 2005 07:53AM
2855
January 21, 2005 03:52PM
2764
January 25, 2005 04:57PM
Re: Problem of data corruption
3002
January 27, 2005 02:55AM
2934
February 16, 2005 07:58AM
2699
February 25, 2005 06:54AM
2905
March 03, 2005 03:07AM
3150
February 16, 2005 11:15AM
3688
February 17, 2005 03:40AM
2802
February 17, 2005 03:25PM
2742
March 17, 2005 01:55AM
2750
March 18, 2005 11:19AM
3085
March 31, 2005 01:04PM
2872
April 04, 2005 08:21AM
2975
April 04, 2005 09:24AM
3154
April 04, 2005 11:38PM
2799
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.