| 1 |
I have a standard 2x RAM swap size of 4gb. |
| 2 |
The problem that I am seeing though is that the applications (MySQL and |
| 3 |
apache) are segfaulting -before- the system starts to swap, almost where |
| 4 |
they have an aversion to using swap. |
| 5 |
|
| 6 |
Cheers |
| 7 |
|
| 8 |
Kad |
| 9 |
|
| 10 |
On Thu, Jan 13, 2011 at 9:34 AM, Stroller <stroller@××××××××××××××××××.uk>wrote: |
| 11 |
|
| 12 |
> |
| 13 |
> On 12/1/2011, at 10:47pm, Kaddeh wrote: |
| 14 |
> > ... |
| 15 |
> > First, addressing the SQL issue and why I think that that could be one of |
| 16 |
> > the causes. The entire site, for the most part is all in one giant DB |
| 17 |
> > (~9GB) a significant part of that is a 3gb table full of raw image data |
| 18 |
> > (yes, I know that this is a REALLY bad idea to do, but I didn't design |
| 19 |
> the |
| 20 |
> > site, I just did a migration to off-site) that being said, there could be |
| 21 |
> a |
| 22 |
> > problem with that. |
| 23 |
> |
| 24 |
> I think I may have heard database guys argue for keeping image data in the |
| 25 |
> DB. I'm not sure that it's always a bad idea. |
| 26 |
> |
| 27 |
> However: how much swap do you have? |
| 28 |
> |
| 29 |
> If you have a 12GB swap file, perhaps you will no longer see this problem? |
| 30 |
> |
| 31 |
> Stroller. |
| 32 |
> |
| 33 |
> |
| 34 |
> |
Archives