Maximizing Sysbench OLTP performance for MySQL

MySQL 的优化是一个永恒的话题,这篇博客介绍了作者用 sysbench 测试结果,并提供的最佳参数:

  1. Use multiple sysbench threads via the --num-threads parameter
  2. Set innodb_thread_concurrency = 0 in my.cnf
  3. Set innodb_buffer_size equal to or greater than the table size