hi,
am using mysql 3.23.49 on win2k, and i have an application accessing the database an updating a particular table at least twice every minute, and inserting new records every 10 minutes.
My problem is that, am experiencing data corruption on that particullar table every day at least once.
The query responsible for that has been isolated (it's an update sql statement: "update table_name set x=something, y=others_things"
.
I tried to flush the tables before the query and after the query in the code, and set the flush_time option to "0", but it still happens (less than before though!).
Has anybody experienced something like this before??
What's the way forward to solve that problem?? La faim justifie les moyens!
am using mysql 3.23.49 on win2k, and i have an application accessing the database an updating a particular table at least twice every minute, and inserting new records every 10 minutes.
My problem is that, am experiencing data corruption on that particullar table every day at least once.
The query responsible for that has been isolated (it's an update sql statement: "update table_name set x=something, y=others_things"
.I tried to flush the tables before the query and after the query in the code, and set the flush_time option to "0", but it still happens (less than before though!).
Has anybody experienced something like this before??
What's the way forward to solve that problem?? La faim justifie les moyens!