Tuning Issues

  • Make use of the Innodb pool (give the database memory)
  • Wait timeout issues/keep thread count slow (creation is cheap with MySQL!)
  • fsync() changes
  • 2x the number of processors for IO threads (more like 4x)