I just changed back to the 'order by id LIMIT 5000' and I have not seen
further
corruption.
I also wanted to mention the other details about the system:
The system is running Linux 2.6.16.21-0.8-smp (SLES10)
mysql-5.0.18-20.5
And I do grant that we probably need to change the key cache.
mys
I am getting table corruption on one machine that I was testing a change
to get better performance.
This is using the C API to connect to the database. With the delete
without
the sort by id, I started getting the database key corruption. There
were about
2.6 million rows matched to be delete
