[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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:
Just curious, how big of a difference (indeed, what difference) does
64bit make?
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.

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 distresses me.

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?

Reply to: