Note: There is an updated post on this topic here. Interviewing people for our Job Openings I like to ask them a basic question – if you have a server with 16GB of RAM which will be dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and interestingly enough most people fail to come up with anything reasonable. So I decided to publish the answer
![Innodb Performance Optimization Basics](https://cdn-ak-scissors.b.st-hatena.com/image/square/c3a941588c5b5303aaaece906e01205d89f1f2e8/height=288;version=1;width=512/https%3A%2F%2Fno-cache.hubspot.com%2Fcta%2Fdefault%2F758664%2F2b8a3d1c-4cb0-4e8b-8362-e90bf9438cc0.png)