mysql table locking

I ran into an interesting issue recently, and since I had so much trouble finding a solution, I’ll post about it. We have a very large WordPress site with somewhere around 32,000 posts. Sometime during…