>>>>> "Andrey" == Andrey Kotrekhov <kota@stripped> writes:
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> 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
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:
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!