RE: MySQL Memory Requirements...

2001-02-06 Thread Daniel Kirk 

What it looks like i'm going for is the following setup

30gb eide hdd
celeron 700Mhz processor
256MB RAM
red hat linux
mysql
apache/tomcat

I'm a bit worried because the database is on the same server as the website.
Will the machine fall over because it doesn't have enough ram/CPU power (for
about 20k users per week as below)?  any ball park comments eg no worries,
close call, not a chance?

thx

dan


-Original Message-
From: Daniel Kirk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 February 2001 09:38
To: [EMAIL PROTECTED]
Subject: MySQL Memory Requirements...


Can someone please give me a rough estimate of how much RAM MySQL would
require to run something like :

A connection pool of around 50 connections
20,000 users every week re-using these 50 connections
around 50 inserts per user (each row around 30 bytes)
around 20 queries per user
Installation on Linux

is it possible to estimate RAM required for that information - is there
anything else I could provide?

thanks for your help

Dan


-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Monday, 5 February 2001 07:55
To: Vangipuram, Anand; [EMAIL PROTECTED]
Subject: Re: System Requirements...


It will run on most computers of today.  Question is what system have you
got/want, what are you going to use it for and what is the expected volume
of information?


- Original Message -
From: "Vangipuram, Anand" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 0:31
Subject: System Requirements...



  What are the system requirements for installing mysql?
 
  Anand Vangipuram
  414-566-6701
 


 

 This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL Memory Requirements...

2001-02-06 Thread Rafael Martinez 

---Reply to mail from Daniel Kirk about MySQL Memory Requirements...
 What it looks like i'm going for is the following setup
 
 30gb eide hdd
 celeron 700Mhz processor
 256MB RAM
 red hat linux
 mysql
 apache/tomcat
 
 I'm a bit worried because the database is on the same server as the website.
 Will the machine fall over because it doesn't have enough ram/CPU power (for
 about 20k users per week as below)?  any ball park comments eg no worries,
 close call, not a chance?
 

I will be more worried about that EIDE 30Gb disk than about the rest. I
would invest a little more money in a SCSI system. The diference in
performance will be enormous, specially with many processes using the disk
at the same time.

Sincerely
Rafael Martinez



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL Memory Requirements...

2001-02-06 Thread Daniel Kirk 

thanks for your advice vivek  rafael.

can anyone tell me why someone tried unsubscribing me from this list?  Bit
rude I thought, esp with no explanation.  I don't mind being told if my
questions are in the wrong place or anything like that.

dan


-Original Message-
From: Vivek Khera [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 February 2001 08:39
To: [EMAIL PROTECTED]
Subject: RE: MySQL Memory Requirements...


 "DK" == Daniel Kirk [EMAIL PROTECTED] writes:

DK 30gb eide hdd

DK Will the machine fall over because it doesn't have enough ram/CPU
DK power (for about 20k users per week as below)?  any ball park
DK comments eg no worries, close call, not a chance?

Your bottleneck on a database is almost never the CPU.  It is almost
always the disk.  Get a faster disk.  More RAM never hurts, either.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php