From owner-freebsd-questions  Tue Jul 27  3: 3:52 1999
Delivered-To: freebsd-questions@freebsd.org
Received: from mailhost.criterion.canon.co.uk (mailhost.criterion.canon.co.uk [194.223.249.254])
	by hub.freebsd.org (Postfix) with ESMTP id E056E1539B
	for <freebsd-questions@FreeBSD.ORG>; Tue, 27 Jul 1999 03:03:40 -0700 (PDT)
	(envelope-from adamn@csl.com)
Received: from csl.com (hermes.criterion.canon.co.uk [194.223.249.13]) by mailhost.criterion.canon.co.uk (8.8.8/8.7.3) with ESMTP id KAA17293 for <freebsd-questions@FreeBSD.ORG>; Tue, 27 Jul 1999 10:53:27 +0100 (BST)
Message-ID: <379D80A2.AB5FF304@csl.com>
Date: Tue, 27 Jul 1999 10:49:22 +0100
From: Adam Nealis <adamn@csl.com>
Organization: Criterion Software, Ltd.
X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.34 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: freebsd-questions <freebsd-questions@FreeBSD.ORG>
Subject: mySQL 3.22.21 + 'BSD 2.2.7-STABLE - what kind of throughput can I 
 expect?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

FreeBSD 2.2.7-STABLE built Thu Nov 19 1998
DELL poweredge 2200
PII 266/64MB RAM
Apache/1.3.6 (Unix) mod_perl/1.19 mod_ssl/2.2.8
OpenSSL/0.9.2b PHP/3.0.11
mySQL 3.22.21
On a shared 2MB/s connection to the 'Net, behind a firewall.

I suppose a RAM upgrade to at least 128MB RAM would b
sensible (at present top tells me my apache processes have a
footprint of SIZE=~2104K, RES=~4000K, mysqld has
SIZE=11172K, RES=988K).

This is for a shopping cart type application, developed
in-house and uses perl to drive the database/cart. The PHP3
stuff is for the Phorum forum software.

I already kow this box is more than adequate for our current
web serving needs.

Initially I want to run mySQL on this same box that is doing
the web serving and https, but I am aware that if things get
heavy in terms of throughput I should consider breaking the
DB out onto a separate box.

Presumably there is a lot of tuning I can do to apache
itself to improve efficiency.

So my questions are:

 o WRT the database side, where can I go to get some data on
what kind of performance I can expect for the same class of
system?
 o What are good indicators to watch for that might help me
deduce that the machine is getting a good hammering?
 o Are there any database benchmarking suites out there that
I could try on a similar system?

Thanks,
Adam.


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message