What you've learned

You should now know how to:

  • Tune MySQL to increase performance

Knowledge Check

When tuning a thread count configuration parameter like innodb_read_io_threads or innodb_write_io_threads. What can often be a good starting value?

What is the recommended size for the MySQL buffer pool?

Why might it be a good idea to increase how often a mutex lock is checked before the running thread yields?