>>>>> "Andrey" == Andrey Kotrekhov <kota@stripped> writes:
Andrey> Hi!
Andrey> I use big table >1000000 records
Andrey> it contain statistics.
Andrey> every day I rotate old value.
Andrey> But sometimes I get error - my index corrupted :(
Andrey> Why?
Andrey> I do standart operation
Andrey> DELETE FROM traffic WHERE ...
>> From this DELETE I wont delete near 100000 records every day.
Andrey> I use FreeBSD2.2.8-STABLE & mysql-3-22.25
Hi!
Table rotation should not corrupt indexes. To be able to help you I
would need a lot more information.
You can find information how to do a correct bug report at:
http://www.tcx.se/Manual_chapter/manual_Questions.html#Asking_questions
PLEASE read the above before reposting your question, this will save us all
a lot of time!
Please read also the section 'Debugging the MySQL server' about how to
be able to replicate this so that we can find and fix the problem!
Yours,
Monty
