Checked a newly provisioned MySQL server today and realized innodb_buffer_pool_size was still sitting at the default 128MB on a 16GB machine. Bumping it up to 11GB so the working set and indexes stay in RAM dropped disk IOPS to almost zero.
Commit
af61fab
This is one important setup in any server. However it also means this RAM is never free-ed, so you may run out of memory quicker if your server performs heavy file reading or process big payload…
commit af61fab