RE: Web site hosting environment on Sun 4500

avg small xaction:   1.3 seconds
avg medium xaction:  5.5 seconds
avg large xaction:  10.7 seconds

Most transactions are in the 1-7 second range, with some taking as long as 15 seconds, and a few in the 30-second range. I factored network latency out of these averages.

We don't keep "official" statistics on peak usage; we have customers all over North and South America and Europe. I also couldn't glean any useful information out of the apache logs, but our busiest sites average 10,000-15,000 hits per day, the mom 'n pop sites less than 100. There currently are 15-20 sites in the 10,000-15,000 range, with the majority of sites averaging less than 1,000/day. I gathered these statistics from 350 customers currently on seven machines (linux and solaris).

Thanks,
--Walt

-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com] Sent: Monday, August 07, 2000 11:01 AM
To: Weaver, Walt
Cc: Multiple recipients of list ORACLE-L Subject: Re: Web site hosting environment on Sun 4500

Walt,

Can you supply anything like an average transaction period? i.e. the average time it takes a web transaction on your host site?

Or maybe several averages; avg small xaction, avg medium xaction, avg large xaction?

Addtionaly, the incoming rate would be useful. How many of each per hour/minute at peak usage times?

Jared

On Mon, 7 Aug 2000, Weaver, Walt wrote:

> Is there anyone out there running a web site hosting environment with
Oracle
> on the back end? If so, I'd be interested in hearing what kind of hardware
> and software you're running and how well it works.
>
> We currently have about 600 hosted customers, due to expand to over a
> thousand by the end of the year. Our plan is to consolidate all of our
> customers on a single platform for easier administration; currently we're
> using MySQL, Oracle, and SQL Server on a number of hardware platforms.
>
> Our plan is to move everyone to Oracle, and we're looking at the Sun 4500
as
> our hardware platform. I'm trying to figure out how well all this stuff is
> going to scale, if we can run all these sites on a single 4500 or if we'll
> have to purchase more. The front-end web application layer will be Sun
> Netra's, and we'll be using the 4500's on the back end, either in a
> fail-over or clustered environment.
>
> SO, my question: is anyone out there doing something like this, and if so,
> what's been your experience? Is it possible to run close to a thousand
> customer web sites on a single 4500? These sites will be anything from
small
> mom 'n pop sites up to Fortune 500 company sites. Am I out of my mind to
run
> a single instance of Oracle with one schema for each site?
>
> I'd sure be interested to hear any comments, suggestions, or even derisive
> laughter.
>
> Thanks,
> --Walt Weaver
> Bozeman, Montana, USA
> --
> Author: Weaver, Walt
> INET: wweaver_at_rightnowtech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon Received on Mon Aug 07 2000 - 14:30:21 CDT