<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="19. TPC C Benchmark Kit" />
<meta name="dc.subject" content="19. TPC C Benchmark Kit" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="tpcc.html" title="Chapter Contents" />
<link rel="prev" href="tpcctestdb.html" title="Building the Test Database" />
<link rel="next" href="tpcctuningparams4users.html" title="Tuning Parameters and Number of Users" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>19. TPC C Benchmark Kit</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="tpccusingtestprg" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>19. TPC C Benchmark Kit</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="tpcc.html">Chapter Contents</a> | <a class="link" href="tpcctestdb.html" title="Building the Test Database">Prev</a> | <a class="link" href="tpcctuningparams4users.html" title="Tuning Parameters and Number of Users">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div class="selected">
<a href="tpcc.html">TPC C Benchmark Kit</a>
</div>
<br />
<div>
<a href="tpcctestdb.html">Building the Test Database</a>
</div>
<div class="selected">
<a href="tpccusingtestprg.html">Using the Test Program</a>
</div>
<div>
<a href="tpcctuningparams4users.html">Tuning Parameters and Number of Users</a>
</div>
<div>
<a href="omissionsexcp.html">Omissions, Exceptions from the Definition</a>
</div>
<div>
<a href="sampleconf.html">Sample Configuration</a>
</div>
<div>
<a href="otherfactors.html">Other Factors</a>
</div>
<div>
<a href="tpccprocs.html">TPC C Procedures</a>
</div>
<div>
<a href="ddlstmt.html">DDL Statements</a>
</div>
<div>
<a href="storedprocs.html">Stored Procedures</a>
</div>
<br />
</div>
<div id="text">
<a name="tpccusingtestprg" />
<h2>19.2. Using the Test Program</h2>
<p>
The tpcc program simulates one user making random transactions according
to the specified mix of:
</p>
<div>
<pre class="screen">
10 new order transactions, each with 10 order lines
10 payment transactions, 60% by name
1 delivery transaction
1 stock level transaction
1 order status transaction, 60% by name.
</pre>
</div>
<p>
Each instance of the test program has a home warehouse on which it does
most of its operations. If there are more than one operation the test
program will give a supply warehouse different from the local warehouse
to 10% of new order lines.
</p>
<p>
The test is started with:
</p>
<div>
<pre class="screen">
tpcc <database> <username> <password> r
<n-10-new-order-sets> <local warehouse> <n warehouses>
</pre>
</div>
<p>
e.g.
</p>
<div>
<pre class="screen">
./tpcc 1111 dba dba r 10
</pre>
</div>
<p>
for 10 sets of the transaction mix on warehouse 1 in a 1 warehouse
database or,
</p>
<div>
<pre class="screen">
./tpcc 1111 r 100 12 100
</pre>
</div>
<p>
to perform 100 sets of transactions on warehouse 12 in a 100 warehouse
database.
</p>
<p>
The program reports a tpmC rate after performing each set of 10 new orders
and the related support transactions. A statistic will be printed every
10 sets of 10 new orders showing the time spent on each of the benchmark
transactions done during the last run of 100 new orders, 100 payments
10 deliveries, stock levels and order status queries.
</p>
<p>
The throughput will increase during the first minutes of the run to
level off at the attained rate.
</p>
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="tpcctestdb.html" title="Building the Test Database">Previous</a>
<br />Building the Test Database</td>
<td align="center" width="34%">
<a href="tpcc.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="tpcctuningparams4users.html" title="Tuning Parameters and Number of Users">Next</a>
<br />Tuning Parameters and Number of Users</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
898
