On 12/1/2011, at 10:47pm, Kaddeh wrote: > ... > First, addressing the SQL issue and why I think that that could be one of > the causes. The entire site, for the most part is all in one giant DB > (~9GB) a significant part of that is a 3gb table full of raw image data > (yes, I know that this is a REALLY bad idea to do, but I didn't design the > site, I just did a migration to off-site) that being said, there could be a > problem with that.
I think I may have heard database guys argue for keeping image data in the DB. I'm not sure that it's always a bad idea. However: how much swap do you have? If you have a 12GB swap file, perhaps you will no longer see this problem? Stroller.