Re: [OT] Server for Debian + MySQL

[kj <koffiejunkielistlurker@koffiejunkie.za.net>]

Adrian Chapela wrote:
> kj escribió:
> > 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.
> No, you are wasting 14 GB. The 2 GB limitation is a limitation of 
> MySQL server.
You're right.

> PAE is good but it has a lower performance than a 64 bit platform. PAE 
> is a workaround if you can't have a 64 bit machine if your application 
> is only 32 bits and need too much memory.
PAE is useful but it still won't allow any single process to access more 
than 4GB of memory.  So no use in this case. 

--kj