MySQL Performance Blog

Look at this post recently published on TechCrunch - It is ugly standard 404 error message, but what is interesting is the server line which shows nginx 0.5.32

I have checked and indeed images served from assets.hulu.com have nginx server in response header.

This would be the first site of this (planned) scale to run Nginx. So far even though Nginx was used by many major companies in Russia, the rest of the world preferred lighttpd often due to better documentation and more active development community.

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 I would like to hear extending it with basics of Hardware OS And Application optimization.
I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal settings of course depend on the workload.
[read more...]