<!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="tpccusingtestprg.html" title="Using the Test Program" />
<link rel="next" href="omissionsexcp.html" title="Omissions, Exceptions from the Definition" />
<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="tpcctuningparams4users" />
<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="tpccusingtestprg.html" title="Using the Test Program">Prev</a> | <a class="link" href="omissionsexcp.html" title="Omissions, Exceptions from the Definition">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>
<a href="tpccusingtestprg.html">Using the Test Program</a>
</div>
<div class="selected">
<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="tpcctuningparams4users" />
<h2>19.3. Tuning Parameters and Number of Users</h2>
<p>
You may run several instances of tpcc, each representing one user. You
will see CPU utilization improve as users are added since there are more
possibilities of interleaving I/O and CPU.
</p>
<p>
The amount of RAM (number_of_buffers: in wi.cfg) is the single most
important factor influencing throughput. Setting this to about half the system RAM is usually good.
One will remember that each buffer takes
8.5K of actual RAM. One should be careful not to cause the server process
to swap.
</p>
<p>
Striping should be used if there are multiple independent disks, one stripe per physically independent volume. Each stripe should have its own I/O queue. If there is a RAID, then striping is less beneficial. Also one should have multiple handles per files, see FDSPerFile in the configuration file.
</p>
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="tpccusingtestprg.html" title="Using the Test Program">Previous</a>
<br />Using the Test Program</td>
<td align="center" width="34%">
<a href="tpcc.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="omissionsexcp.html" title="Omissions, Exceptions from the Definition">Next</a>
<br />Omissions, Exceptions from the Definition</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
>
897
