Re: Benchmark

От:

"Balazs Wellisch" <balazs@neusolutions.com>

Дата:

15 августа 2003 г. в 15:47:47

You might want to check out these links:

http://www.loadtestingtool.com/download.html
http://www.opensta.org/
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/itsol
utions/intranet/downloads/webstres.asp?frame=true
http://www.softwareqatest.com/qatweb1.html


Balazs



-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of mixo
Sent: Thursday, August 14, 2003 11:34 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Benchmark

I have the following setup :
  Apache 2 + mod_perl 2
  Postgres 7.3.2

I need to is measure the perfomance of a ticketing system (written in
perl)
which has web interface (html::mason, apache2) with Pg as a backend.
Users
of the ticketing system can only connect to the backend via the web 
interface
and they usually login to the system at the begining of the the day and 
remain
connected untill they knock of. I have setup two test machines, one with
Pg
and the other with Mysql. Both machine have the same data (sample).

I am looking for a benchmark utilty that the simulate a user session.
For example, a user login in, displaying a ticket and searching for
tickets;
all these invlove a user connecting to the a url, like for search, a 
user needs
to open "somehost.domain/path/to/search.html?with=arguments". The 
utiltly needs
to simulate these actions.

The following tools currently have so far caught my attention:
   Apache Jmeter
   ab

I need suggestions for other utilities.



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: Benchmark

От:

Josh Berkus <josh@agliodbs.com>

Дата:

15 августа 2003 г. в 13:44:41

Mixo,

> I need to is measure the perfomance of a ticketing system (written in perl)
> which has web interface (html::mason, apache2) with Pg as a backend. Users
> of the ticketing system can only connect to the backend via the web
> interface

I'd suggest Perl LWP.  There's even a good article on how to use it in last 
month's Linux Magazine (or the previous month, not sure).  

Don't forget to come back here for help in tweaking your PostgreSQL settings!

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

Re: Benchmark

От:

Richard Huxton <dev@archonet.com>

Дата:

15 августа 2003 г. в 11:35:42

On Friday 15 August 2003 07:33, mixo wrote:
> I have the following setup :
>   Apache 2 + mod_perl 2
>   Postgres 7.3.2
>

> I am looking for a benchmark utilty that the simulate a user session.
> For example, a user login in, displaying a ticket and searching for
> tickets; all these invlove a user connecting to the a url, like for search,
> a user needs
> to open "somehost.domain/path/to/search.html?with=arguments". The
> utiltly needs
> to simulate these actions.
>
> The following tools currently have so far caught my attention:
>    Apache Jmeter
>    ab

Depending on how complex things are, you may be able to use Tomka's suggestion 
of a batch of wget commands.

However, if you want to be able to fill in forms, handle cookies and react to 
results you might want to look at something based on Perl's LWP bundle 
(LWP::UserAgent is a good start point).

If you want to see how many users can be supported, don't forget to include 
plausible delays in the test sequence where the users would be 
reading/entering data.

If you do find some flexible, scriptable web testing system that can read/fill 
out forms etc please post to the list - I've had no luck finding anything I 
like.

-- 
  Richard Huxton
  Archonet Ltd

Benchmark

От:

mixo <mixo@coza.net.za>

Дата:

15 августа 2003 г. в 06:13:23

I have the following setup :
  Apache 2 + mod_perl 2
  Postgres 7.3.2

I need to is measure the perfomance of a ticketing system (written in perl)
which has web interface (html::mason, apache2) with Pg as a backend. Users
of the ticketing system can only connect to the backend via the web 
interface
and they usually login to the system at the begining of the the day and 
remain
connected untill they knock of. I have setup two test machines, one with Pg
and the other with Mysql. Both machine have the same data (sample).

I am looking for a benchmark utilty that the simulate a user session.
For example, a user login in, displaying a ticket and searching for tickets;
all these invlove a user connecting to the a url, like for search, a 
user needs
to open "somehost.domain/path/to/search.html?with=arguments". The 
utiltly needs
to simulate these actions.

The following tools currently have so far caught my attention:
   Apache Jmeter
   ab

I need suggestions for other utilities.

Re: Benchmark

От:

David Emery <dave@skiddlydee.com>

Дата:

17 августа 2003 г. в 00:52:44

On Saturday, August 16, 2003, at 01:21 AM, Josh Berkus wrote:

> Mixo,
>
>> I need to is measure the perfomance of a ticketing system (written in  
>> perl)
>> which has web interface (html::mason, apache2) with Pg as a backend.  
>> Users
>> of the ticketing system can only connect to the backend via the web
>> interface
>
> I'd suggest Perl LWP.  There's even a good article on how to use it in  
> last
> month's Linux Magazine (or the previous month, not sure).
>

The Perl module HTTP::WebTest should help you do what you want.

http://search.cpan.org/author/ILYAM/HTTP-WebTest-2.03/lib/HTTP/ 
WebTest.pm

It should save a ton of time over building one from scratch. Lots of  
docs too. There are other Perl web testing tools too if you do a search  
at:

http://search.cpan.org

HTH,
Dave

Re: Benchmark

От:

Jeff <threshar@torgo.978.org>

Дата:

15 августа 2003 г. в 15:24:13

On Fri, 15 Aug 2003, Richard Huxton wrote:

> If you do find some flexible, scriptable web testing system that can read/fill
> out forms etc please post to the list - I've had no luck finding anything I
> like.
>
There was a tool created by altavista R&D called "WebL" that I used on a
project.  I think if you search around you'll be able to find it.

However, I think it has developed "bit rot" from not being touched in so
long. My old webl stuff will no longer work.

But what is it?  it is a web scraping language written in java. Fast it is
not. Easy to scrape and interact with pages: YES.  It has all sorts of
things for locating fields, locating table cells, etc.  (I used it for
writing a prototype that would scrape a competitors site and import the
data into our application :)

but if it doesn't work LWP isn't _that_ bad. You will end up in regex hell
though.

--
Jeff Trout 
http://www.jefftrout.com/
http://www.stuarthamm.net/

Re: Benchmark

От:

Tomka Gergely <tomka@zeus.gau.hu>

Дата:

15 августа 2003 г. в 07:26:45

2003-08-15 ragyogó napján mixo ezt üzente:

> For example, a user login in, displaying a ticket and searching for tickets;
> all these invlove a user connecting to the a url, like for search, a
> user needs
> to open "somehost.domain/path/to/search.html?with=arguments". The
> utiltly needs
> to simulate these actions.

Maybe a simple script, with lines like this:
#!/bin/bash
wget http://somehost.domain/path/to/search.html?with=arguments
wget http://somehost.domain/another/script.html
...

?

-- 
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."