Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 66 lines (51 sloc) 1.826 kB
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
1 <?xml version="1.0"?>
5345a3b @nniclausse rename idx-tsunami to tsung step 3
nniclausse authored
2 <!DOCTYPE tsung SYSTEM "@prefix@/share/@PACKAGE_NAME@/@DTD@">
3 <tsung loglevel="notice">
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
4
5 <clients>
6 <client host="localhost" use_controller_vm="true"/>
7 </clients>
8
9 <!-- Server side setup -->
f3816a5 @nniclausse add support for multiples servers. Use RoundRobin to choose the serve…
nniclausse authored
10 <servers>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
11 <server host="127.0.0.1" port="5432" type="tcp"/>
f3816a5 @nniclausse add support for multiples servers. Use RoundRobin to choose the serve…
nniclausse authored
12 </servers>
7155210 @nniclausse major update to DTD : add sessions, load, options, information; renam…
nniclausse authored
13
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
14 <monitoring>
15 <monitor host="localhost"/>
16 </monitoring>
17
7155210 @nniclausse major update to DTD : add sessions, load, options, information; renam…
nniclausse authored
18 <load>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
19 <arrivalphase phase="1" duration="10" unit="minute">
20 <users interarrival="30" unit="second"></users>
21 </arrivalphase>
7155210 @nniclausse major update to DTD : add sessions, load, options, information; renam…
nniclausse authored
22 </load>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
23
7155210 @nniclausse major update to DTD : add sessions, load, options, information; renam…
nniclausse authored
24 <sessions>
25 <session probability="100" name="pgsql-example" type="ts_pgsql">
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
26 <transaction name="connection">
27 <request>
8d80b67 @nniclausse fix according to updated DTD
nniclausse authored
28 <pgsql type="connect" database="bench" username="bench" />
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
29 </request>
30 </transaction>
31
32 <transaction name="authentication">
33 <request>
8d80b67 @nniclausse fix according to updated DTD
nniclausse authored
34 <pgsql type="authenticate" password="sesame"/>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
35 </request>
36 </transaction>
37
e75318f @nniclausse random thinktime using a given range (TSUN-80)
nniclausse authored
38 <thinktime value="2"/>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
39
40 <transaction name="select">
8d80b67 @nniclausse fix according to updated DTD
nniclausse authored
41 <request><pgsql type="sql">SELECT * from accounts;</pgsql></request>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
42 </transaction>
43
44 <thinktime value="20"/>
45
8d80b67 @nniclausse fix according to updated DTD
nniclausse authored
46 <request><pgsql type="sql">SELECT * from users;</pgsql></request>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
47
8e11f40 @nniclausse more complex request for postgresql
nniclausse authored
48 <request><pgsql type='sql'><![CDATA[SELECT n.nspname as "Schema",
49 c.relname as "Name",
50 CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN '%_toto_% END as "Type",
51 u.usename as "Owner"
52 FROM pg_catalog.pg_class c
53 LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner
54 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
55 WHERE c.relkind IN ('r','v','S','')
56 AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
57 AND pg_catalog.pg_table_is_visible(c.oid)
58 ORDER BY 1,2;]]></pgsql></request>
59
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
60 <request><pgsql type="close"></pgsql></request>
61
62 </session>
7155210 @nniclausse major update to DTD : add sessions, load, options, information; renam…
nniclausse authored
63 </sessions>
5345a3b @nniclausse rename idx-tsunami to tsung step 3
nniclausse authored
64 </tsung>
57a0f8b @nniclausse add experimental postgresql plugin
nniclausse authored
65
Something went wrong with that request. Please try again.