Lessons of the day:
- When the database-server juggles a few thousand tables around, a table-cache of only 64 is probably not going to be very effective.
- When you’re dealing with this many tables, increasing the key buffer improves the server performance at the cost of sharing a bit more RAM between the multiple MySQL instances.
Really. 🙂