MySQL Table Locking & WordPress Scalability
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 may the database (MySQL 5.10) started to randomly crash, taking along with it the Apache server, etc. Every time the crashes occurred, we’d find that the number of users had climbed over the available processes, in this case, 501. We went through a whole host…