Skip to content
This repository was 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

YCSB #1 (Workload A)

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #2 (Workload B)

<?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>95,0,0,5,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #3 (Workload C)

<?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>100,0,0,0,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #4 (Workload D)

<?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>95,5,0,0,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #5 (Workload E)

<?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>0,5,95,0,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #6 (Workload F)

<?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>50,0,0,0,0,50</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #7

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #8

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #9

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #10

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #11

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #12

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #13

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #14

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #15

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

YCSB #16

<?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>50,0,0,50,0,0</weights>
          <skew>0.6</skew>
        </work>
    </works>

    <!-- YCSB Procedures declaration -->
    <transactiontypes>
        <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>

Home

Installation

Development (Test Website)

Development

Development Notes

Clone this wiki locally