EmergencyEMERGENCY? Get 24/7 Help Now!

Choosing innodb_buffer_pool_size

 | November 3, 2007 |  Posted In: Insight for DBAs

My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot […]

Read More

Nginx Powers Hulu.com ?

 | November 1, 2007 |  Posted In: Insight for Developers

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 […]

Read More

Innodb Performance Optimization Basics

 | November 1, 2007 |  Posted In: Insight for DBAs

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 […]

Read More