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
4266
January 21, 2005 07:49AM
2694
January 21, 2005 07:53AM
2636
January 21, 2005 03:52PM
2580
January 25, 2005 04:57PM
Re: Problem of data corruption
2821
January 27, 2005 02:55AM
2727
February 16, 2005 07:58AM
2513
February 25, 2005 06:54AM
2545
March 03, 2005 03:07AM
2743
February 16, 2005 11:15AM
3503
February 17, 2005 03:40AM
2546
February 17, 2005 03:25PM
2542
March 17, 2005 01:55AM
2549
March 18, 2005 11:19AM
2862
March 31, 2005 01:04PM
2581
April 04, 2005 08:21AM
2766
April 04, 2005 09:24AM
2946
April 04, 2005 11:38PM
2583
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.