Re: [OT] Server for Debian + MySQL
On 12/10/08 05:34, kj wrote:
Ron Johnson wrote:
On 12/09/08 03:49, kj wrote:
Anoop Aryal wrote:
It will make all the difference on a box with 16GB. On a 32bit
machine, you can use a PAE enabled kernel to allow the operating
system to address all the memory, but you're still stuck with a 4GB
per-process limit, which means if this will be a dedicated MySQL
server, you're wasting 12GB of memory.
Just curious, how big of a difference (indeed, what difference) does
Why wouldn't Linux use that 12GB for applications and (more
importantly) as a really big read cache?
If the box is a dedicated DB server, then there aren't (shouldn't be)
any other applications running other than the essentials.
As a "large systems" developer, this (pervasive) attitude really
Of curse the
kernel would do what the kernel does, but it makes more sense to have
MySQL use that memory for caches/buffers dedicated to its own purposes,
for example, caching query results.
Well, yes, eliminating an intermediate layer between MySQL and the
disk drive is always good.
So again, the per-process memory
limit is a disadvantage.
Ron Johnson, Jr.
Jefferson LA USA
How does being physically handicapped make me Differently-Abled?
What different abilities do I have?