Thread: 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.
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..."
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
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
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 <jeff@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/
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)
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