putting linux & MySQL on 6 year old box - hwo much RAM, Hard drive space do I need?

[NotGiven]

setting up LAMP server. on old server with single Intel PII 450 MGHz, 64 MG
Ram and two 9.1 GB Hard drives.

How much RAM do I need to run MySQL efficiently?

[Joe Makowiec]

On 19 Dec 2005 in mailing.databas e.mysql, NotGiven wrote:

setting up LAMP server. on old server with single Intel PII 450
MGHz, 64 MG Ram and two 9.1 GB Hard drives.

How much RAM do I need to run MySQL efficiently?

I don't know about 'efficiently', but I'm running FC4 on a PII/400 with
320M of memory with 184-odd gig of disk, running Apache, MySQL and Samba.
Free reports:

[joe@linuxserver 3 ~]$ free -k
total used free shared buffers cached
Mem: 320108 306952 13156 0 11520 142964
-/+ buffers/cache: 152468 167640
Swap: 1052248 708 1051540
--
Joe Makowiec
http://makowiec.org/
Email: http://makowiec.org/contact/?Joe

[Bill Karwin]

"NotGiven" <no****@nonegiv en.invalid> wrote in message
news:pm******** *********@bigne ws7.bellsouth.n et...

setting up LAMP server. on old server with single Intel PII 450 MGHz, 64
MG Ram and two 9.1 GB Hard drives.

How much RAM do I need to run MySQL efficiently?

Impossible to say, without knowing how you're using MySQL. Many factors
affect the memory usage: what size of database, what types of queries, how
many simultaneous connections, would you benefit from using MySQL query
caching, etc. Also, are you also going to install and run a web server or
application server on the same box?

Anyway, these days, it seems that a server should have at least 1GB of
memory.

If it were me, I'd just max out the memory in that machine. A PC of that
era probably has a maximum of either 512MB or 1GB of RAM, unless it was
originally a server platform. I would just fill it up with the biggest
memory it can support, and throw out the 64MB it currently has. It probably
takes SDRAM DIMM's, but check the motherboard documentation to make sure you
get the memory clock speed right.

Old-technology memory is probably going to be more expensive (per megabyte)
than memory for newer machines, but check www.froogle.com and
www.pricewatch.com. I bet you can max it out for about US$100.

Regards,
Bill K.

[Markus Popp]

Hi,

that's like asking how fast must a car be able to drive that it runs
comfortably - some people are comfortable with a car that runs 100 km/h and
others believe that only a car that runs 250 km/h provides comfortable
driving.

As Bill already said, it's up to your needs - if you use the server to learn
the basics of MySQL, it might even run fast enough with 64 MB RAM (although
that's very little, but if you use it for MySQL only, it should work).
However, if you want to run a production server, put in as much RAM as
possible, like Bill suggested ;-).

Markus

[NotGiven]

"Joe Makowiec" <ma******@inval id.invalid> wrote in message
news:Xn******** *************** ***********@24. 24.2.166...

On 19 Dec 2005 in mailing.databas e.mysql, NotGiven wrote:

setting up LAMP server. on old server with single Intel PII 450
MGHz, 64 MG Ram and two 9.1 GB Hard drives.

How much RAM do I need to run MySQL efficiently?

I don't know about 'efficiently', but I'm running FC4 on a PII/400 with
320M of memory with 184-odd gig of disk, running Apache, MySQL and Samba.
Free reports:

[joe@linuxserver 3 ~]$ free -k
total used free shared buffers cached
Mem: 320108 306952 13156 0 11520 142964
-/+ buffers/cache: 152468 167640
Swap: 1052248 708 1051540
--
Joe Makowiec
http://makowiec.org/
Email: http://makowiec.org/contact/?Joe

for some reason, I didn't think you could have that much hard drive on a
older processor