Skip to content
This repository has been archived by the owner on Mar 20, 2021. It is now read-only.

OLTPBenchmark Configurations

Jump to bottom
Dana Van Aken edited this page Jul 27, 2019 · 2 revisions

Connection Details

MySQL

<dbtype>mysql</dbtype>
<driver>com.mysql.jdbc.Driver</driver>
<DBUrl>jdbc:mysql://localhost:3306/tpcc</DBUrl>
<username>user</username>
<password></password>
<isolation>TRANSACTION_REPEATABLE_READ</isolation>

Postgres

<dbtype>postgres</dbtype>
<driver>org.postgresql.Driver</driver>
<DBUrl>jdbc:postgresql://localhost:5432/tpcc</DBUrl>
<username>user</username>
<password></password>
<isolation>TRANSACTION_READ_COMMITTED</isolation>

Configurations

TPC-C

<?xml version="1.0"?>
<parameters>
	
    <!-- Connection details -->
    <dbtype>mysql</dbtype>
    <driver>com.mysql.jdbc.Driver</driver>
    <DBUrl>jdbc:mysql://localhost:3306/tpcc</DBUrl>
    <username>user</username>
    <password></password>
    <isolation>TRANSACTION_REPEATABLE_READ</isolation>

    <!-- OtterTune website upload details -->
    <uploadCode>your_upload_code</uploadCode>
    <uploadUrl>http://Repo_Hostname/new_result/</uploadUrl>
    
    <!-- Scale factor is the number of warehouses in TPCC -->
    <scalefactor>200</scalefactor>
    
    <!-- The workload -->
    <terminals>50</terminals>
    <works>
        <work>
          <time>300</time>
          <rate>unlimited</rate>
          <weights>45,43,4,4,4</weights>
        </work>
    </works>
	
	<!-- TPCC specific -->  
   	<transactiontypes>
    	<transactiontype>
    		<name>NewOrder</name>
    	</transactiontype>
    	<transactiontype>
    		<name>Payment</name>
    	</transactiontype>
    	<transactiontype>
    		<name>OrderStatus</name>
    	</transactiontype>
    	<transactiontype>
    		<name>Delivery</name>
    	</transactiontype>
    	<transactiontype>
    		<name>StockLevel</name>
    	</transactiontype>
   	</transactiontypes>	
</parameters>

SEATS

<?xml version="1.0"?>
<parameters>

    <!-- Connection details -->
    <dbtype>mysql</dbtype>
    <driver>com.mysql.jdbc.Driver</driver>
    <DBUrl>jdbc:mysql://localhost:3306/seats</DBUrl>
    <username>user</username>
    <password></password>
    <isolation>TRANSACTION_REPEATABLE_READ</isolation>

    <!-- OtterTune website upload details -->
    <uploadCode>your_upload_code</uploadCode>
    <uploadUrl>http://Repo_Hostname/new_result/</uploadUrl>
    
    <!-- Scalefactor in SEATS scales by *1000 the number of customers-->
    <scalefactor>100</scalefactor>

    <!-- The workload -->
    <terminals>50</terminals>
    <works>
        <work>
          <time>300</time>
          <rate>unlimited</rate>
          <weights>10,10,35,20,10,15</weights>
        </work>
    </works>

    <!-- SEATS Procedures declaration -->
    <transactiontypes>
        <transactiontype>
                <name>DeleteReservation</name>
        </transactiontype>
        <transactiontype>
                <name>FindFlights</name>
        </transactiontype>
        <transactiontype>
                <name>FindOpenSeats</name>
        </transactiontype>
        <transactiontype>
                <name>NewReservation</name>
        </transactiontype>
        <transactiontype>
                <name>UpdateCustomer</name>
        </transactiontype>
        <transactiontype>
                <name>UpdateReservation</name>
        </transactiontype>
    </transactiontypes>
</parameters>

Wikipedia

<?xml version="1.0"?>
<parameters>

    <!-- Connection details -->
    <dbtype>mysql</dbtype>
    <driver>com.mysql.jdbc.Driver</driver>
    <DBUrl>jdbc:mysql://localhost:3306/wikipedia</DBUrl>
    <username>user</username>
    <password></password>
    <isolation>TRANSACTION_REPEATABLE_READ</isolation>

    <!-- OtterTune website upload details -->
    <uploadCode>your_upload_code</uploadCode>
    <uploadUrl>http://Repo_Hostname/new_result/</uploadUrl>

    <!-- Scale factor is the number of wikipages *1000 -->
    <scalefactor>75</scalefactor>
    
	<!-- The workload -->
 	<terminals>50</terminals>
    <works>
        <work>
          <time>300</time>
          <rate>unlimited</rate>
          <weights>3,3,10,80,4</weights>
        </work>
    </works>
    
    <!-- Wikipedia Procedures Declaration -->
	<transactiontypes>
        <transactiontype>
                <name>AddWatchList</name>
        </transactiontype>
        <transactiontype>
                <name>RemoveWatchList</name>
        </transactiontype>
        <transactiontype>
                <name>UpdatePage</name>
        </transactiontype>
        <transactiontype>
                <name>GetPageAnonymous</name>
        </transactiontype>
        <transactiontype>
                <name>GetPageAuthenticated</name>
        </transactiontype>
    </transactiontypes>
</parameters>

YCSB

<?xml version="1.0"?>
<parameters>

    <!-- Connection details -->
    <dbtype>mysql</dbtype>
    <driver>com.mysql.jdbc.Driver</driver>
    <DBUrl>jdbc:mysql://localhost:3306/ycsb</DBUrl>
    <username>user</username>
    <password></password>
    <isolation>TRANSACTION_REPEATABLE_READ</isolation>

    <!-- OtterTune website upload details -->
    <uploadCode>your_upload_code</uploadCode>
    <uploadUrl>http://Repo_Hostname/new_result/</uploadUrl>

    <!-- Scalefactor in YCSB is *1000 the number of rows in the USERTABLE-->
    <scalefactor>18000</scalefactor>
    
    <!-- The workload -->
    <terminals>50</terminals>
    <works>
        <work>
          <time>300</time>
          <rate>unlimited</rate>
          <weights>ycsb_a</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <groupings>
            <grouping>
                <name>ycsb_a</name>
                <weights>50,0,0,50,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_b</name>
                <weights>95,0,0,5,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_c</name>
                <weights>100,0,0,0,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_d</name>
                <weights>95,5,0,0,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_e</name>
                <weights>0,5,95,0,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_f</name>
                <weights>50,0,0,0,0,50</weights>
            </grouping>
            <grouping>
                <name>ycsb_7</name>
                <weights>50,50,0,0,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_8</name>
                <weights>75,0,0,25,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_9</name>
                <weights>25,0,0,75,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_10</name>
                <weights>50,0,25,25,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_11</name>
                <weights>95,0,0,0,0,5</weights>
            </grouping>
            <grouping>
                <name>ycsb_12</name>
                <weights>85,5,0,10,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_13</name>
                <weights>80,0,10,10,0,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_14</name>
                <weights>90,5,0,0,5,0</weights>
            </grouping>
            <grouping>
                <name>ycsb_15</name>
                <weights>50,0,0,0,0,50</weights>
            </grouping>
        </groupings>
        <transactiontype>
                <name>ReadRecord</name>
        </transactiontype>
        <transactiontype>
                <name>InsertRecord</name>
        </transactiontype>
        <transactiontype>
                <name>ScanRecord</name>
        </transactiontype>
        <transactiontype>
                <name>UpdateRecord</name>
        </transactiontype>
        <transactiontype>
                <name>DeleteRecord</name>
        </transactiontype>
        <transactiontype>
                <name>ReadModifyWriteRecord</name>
        </transactiontype>
    </transactiontypes>
</parameters>

TPC-H

<!-- Connection details -->
<dbtype>mysql</dbtype>
<driver>com.mysql.jdbc.Driver</driver>
<DBUrl>jdbc:mysql://localhost:3306/ycsb</DBUrl>
<username>user</username>
<password></password>
<isolation>TRANSACTION_REPEATABLE_READ</isolation>

<!-- OtterTune website upload details -->
<uploadCode>your_upload_code</uploadCode>
<uploadUrl>http://Repo_Hostname/new_result/</uploadUrl>

<scalefactor>10</scalefactor>

<!-- The workload -->
<terminals>1</terminals>
<works>
    <work>
      <time>0</time>
      <serial>true</serial>
      <rate>unlimited</rate>
      <weights>tpch_w1</weights>
    </work>
</works>

<!-- OLTPBench provides additional 'all' grouping by default -->
<transactiontypes>
    <groupings>
        <grouping>
            <name>tpch_w1</name>
            <weights>0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,1</weights>
        </grouping>
        <grouping>
            <name>tpch_w2</name>
            <weights>1,0,0,1,0,0,0,1,0,0,0,0,1,0,1,0,0,0,0,0,0,0</weights>
        </grouping>
        <grouping>
            <name>tpch_w3</name>
            <weights>0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,1,1,1,0,0</weights>
        </grouping>
        <grouping>
            <name>tpch_w4</name>
            <weights>0,0,0,0,0,1,0,0,1,0,0,1,0,1,0,0,0,0,0,0,1,0</weights>
        </grouping>
    </groupings>
    <transactiontype>
        <name>Q1</name>
        <id>1</id>
    </transactiontype>
    <transactiontype>
        <name>Q2</name>
        <id>2</id>
    </transactiontype>
    <transactiontype>
        <name>Q3</name>
        <id>3</id>
    </transactiontype>
    <transactiontype>
        <name>Q4</name>
        <id>4</id>
    </transactiontype>
    <transactiontype>
        <name>Q5</name>
        <id>5</id>
    </transactiontype>
    <transactiontype>
        <name>Q6</name>
        <id>6</id>
    </transactiontype>
    <transactiontype>
        <name>Q7</name>
        <id>7</id>
    </transactiontype>
    <transactiontype>
        <name>Q8</name>
        <id>8</id>
    </transactiontype>
    <transactiontype>
        <name>Q9</name>
        <id>9</id>
    </transactiontype>
    <transactiontype>
        <name>Q10</name>
        <id>10</id>
    </transactiontype>
    <transactiontype>
        <name>Q11</name>
        <id>11</id>
    </transactiontype>
    <transactiontype>
        <name>Q12</name>
        <id>12</id>
    </transactiontype>
    <transactiontype>
        <name>Q13</name>
        <id>13</id>
    </transactiontype>
    <transactiontype>
        <name>Q14</name>
        <id>14</id>
    </transactiontype>
    <transactiontype>
        <name>Q15</name>
        <id>15</id>
    </transactiontype>
    <transactiontype>
        <name>Q16</name>
        <id>16</id>
    </transactiontype>
    <transactiontype>
        <name>Q17</name>
        <id>17</id>
    </transactiontype>
    <transactiontype>
        <name>Q18</name>
        <id>18</id>
    </transactiontype>
    <transactiontype>
        <name>Q19</name>
        <id>19</id>
    </transactiontype>
    <transactiontype>
        <name>Q20</name>
        <id>20</id>
    </transactiontype>
    <transactiontype>
        <name>Q21</name>
        <id>21</id>
    </transactiontype>
    <transactiontype>
        <name>Q22</name>
        <id>22</id>
    </transactiontype>
</transactiontypes>

Home

Installation

Development (Test Website)

Development

Development Notes

Clone this wiki locally