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
4384
January 21, 2005 07:49AM
2772
January 21, 2005 07:53AM
2734
January 21, 2005 03:52PM
2661
January 25, 2005 04:57PM
Re: Problem of data corruption
2889
January 27, 2005 02:55AM
2801
February 16, 2005 07:58AM
2589
February 25, 2005 06:54AM
2609
March 03, 2005 03:07AM
2812
February 16, 2005 11:15AM
3574
February 17, 2005 03:40AM
2650
February 17, 2005 03:25PM
2618
March 17, 2005 01:55AM
2614
March 18, 2005 11:19AM
2953
March 31, 2005 01:04PM
2661
April 04, 2005 08:21AM
2836
April 04, 2005 09:24AM
3005
April 04, 2005 11:38PM
2654
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.