I have a site that's becoming more active. I use a MySQL Database, .NET 3.5, IIS6, Memcached, and state server.
I was looking into ways to improve performance and found that web garden adds additional threads for requests. I read that this should be equal to, or equal to + 1, the number of physical processors in the machine. So I tried setting it to 2. I did notice an improvement, but I also notice some weird things too. MySQL started timing out and dumping sort errors. And also when I would copy bin files over users would get a yellow error page. I'd have to copy them again. Yellow error page is obviously worse than a delay.
Is there a trick to web garden to prevent the yellow error page? Is there any reason why MySQL (5.1) wouldn't work with it? I'm kinda concerned about that one if it's gonna do the same thing if I need to add another web server. I'm using the .NET Connector for MySQL.