East of the Sun, West of the Moon

2005/8/11

Databases

Filed under: Software — Erwin @ 3:12 pm

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. 🙂

Powered by WordPress