Learn how to Tune MySQL: Review

Log an issue

Fork and edit

Discuss on Discord

What you've learned

You should now know how to:

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?

One

Total number of CPUs on the system

Half the number of CPUs on the system

What is the recommended size for the MySQL buffer pool?

Up to 40% of system memory

Up to 20% of system memory

Up to 80% of system memory

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

Increasing mutex lock checks before a yield speeds up disk access

Increasing mutex lock checks before a yield reduces context switching, which is expensive

Increasing mutex lock checks before a yield speeds up buffer pool reads

Back