Home | History | Annotate | Download | only in workloads
      1  5184  ek110237 #
      2  5184  ek110237 # CDDL HEADER START
      3  5184  ek110237 #
      4  5184  ek110237 # The contents of this file are subject to the terms of the
      5  5184  ek110237 # Common Development and Distribution License (the "License").
      6  5184  ek110237 # You may not use this file except in compliance with the License.
      7  5184  ek110237 #
      8  5184  ek110237 # You can obtain a copy of the license at usr/src/OPENSOLARIS.LICENSE
      9  5184  ek110237 # or http://www.opensolaris.org/os/licensing.
     10  5184  ek110237 # See the License for the specific language governing permissions
     11  5184  ek110237 # and limitations under the License.
     12  5184  ek110237 #
     13  5184  ek110237 # When distributing Covered Code, include this CDDL HEADER in each
     14  5184  ek110237 # file and include the License file at usr/src/OPENSOLARIS.LICENSE.
     15  5184  ek110237 # If applicable, add the following below this CDDL HEADER, with the
     16  5184  ek110237 # fields enclosed by brackets "[]" replaced with your own identifying
     17  5184  ek110237 # information: Portions Copyright [yyyy] [name of copyright owner]
     18  5184  ek110237 #
     19  5184  ek110237 # CDDL HEADER END
     20  5184  ek110237 #
     21  5184  ek110237 #
     22  9801    Andrew # Copyright 2009 Sun Microsystems, Inc.  All rights reserved.
     23  5184  ek110237 # Use is subject to license terms.
     24  5184  ek110237 #
     25  5184  ek110237 
     26  9801    Andrew # $dir - directory for datafiles
     27  9801    Andrew # $eventrate - event generator rate (0 == free run)
     28  5184  ek110237 # $iosize - iosize for database block access
     29  5184  ek110237 # $nshadows - number of shadow processes
     30  5184  ek110237 # $ndbwriters - number of database writers
     31  5184  ek110237 
     32  5184  ek110237 set $dir=/tmp
     33  9801    Andrew set $eventrate=0
     34  5184  ek110237 set $iosize=2k
     35  5184  ek110237 set $nshadows=200
     36  5184  ek110237 set $ndbwriters=10
     37  9801    Andrew set $runtime=30
     38  5184  ek110237 set $usermode=20000
     39  5184  ek110237 set $memperthread=1m
     40  5184  ek110237 
     41  5184  ek110237 debug 1
     42  9801    Andrew eventgen rate=$eventrate
     43  5184  ek110237 
     44  5184  ek110237 # Define a datafile and logfile
     45  5184  ek110237 define file name=aux.df,path=$dir,size=251m,reuse,prealloc,paralloc
     46  5184  ek110237 define file name=control_001,path=$dir,size=2m,reuse,prealloc,paralloc
     47  5184  ek110237 define file name=cust_0_0,path=$dir,size=6704m,reuse,prealloc,paralloc
     48  5184  ek110237 define file name=cust_0_1,path=$dir,size=6704m,reuse,prealloc,paralloc
     49  5184  ek110237 define file name=cust_0_2,path=$dir,size=6704m,reuse,prealloc,paralloc
     50  5184  ek110237 define file name=cust_0_3,path=$dir,size=6704m,reuse,prealloc,paralloc
     51  5184  ek110237 define file name=dist_0_0,path=$dir,size=31m,reuse,prealloc,paralloc
     52  5184  ek110237 define file name=hist_0_0,path=$dir,size=3002m,reuse,prealloc,paralloc
     53  5184  ek110237 define file name=icust1_0_0,path=$dir,size=4943m,reuse,prealloc,paralloc
     54  5184  ek110237 define file name=icust2_0_0,path=$dir,size=4943m,reuse,prealloc,paralloc
     55  5184  ek110237 define file name=idist_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
     56  5184  ek110237 define file name=iitem_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
     57  5184  ek110237 define file name=iordr2_0_0,path=$dir,size=1651m,reuse,prealloc,paralloc
     58  5184  ek110237 define file name=istok_0_0,path=$dir,size=2262m,reuse,prealloc,paralloc
     59  5184  ek110237 define file name=item_0_0,path=$dir,size=21m,reuse,prealloc,paralloc
     60  5184  ek110237 define file name=iware_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
     61  5184  ek110237 define file name=nord_0_0,path=$dir,size=561m,reuse,prealloc,paralloc
     62  5184  ek110237 define file name=ordr_0_0,path=$dir,size=44301m,reuse,prealloc,paralloc
     63  5184  ek110237 define file name=roll1,path=$dir,size=2001m,reuse,prealloc,paralloc
     64  5184  ek110237 define file name=sp_0,path=$dir,size=1001m,reuse,prealloc,paralloc
     65  5184  ek110237 define file name=stok_0_0,path=$dir,size=8052m,reuse,prealloc,paralloc
     66  5184  ek110237 define file name=stok_0_1,path=$dir,size=8052m,reuse,prealloc,paralloc
     67  5184  ek110237 define file name=stok_0_2,path=$dir,size=8052m,reuse,prealloc,paralloc
     68  5184  ek110237 define file name=stok_0_3,path=$dir,size=8052m,reuse,prealloc,paralloc
     69  5184  ek110237 define file name=stok_0_4,path=$dir,size=8052m,reuse,prealloc,paralloc
     70  5184  ek110237 define file name=system_1,path=$dir,size=401m,reuse,prealloc,paralloc
     71  5184  ek110237 define file name=temp_0_0,path=$dir,size=4943m,reuse,prealloc,paralloc
     72  5184  ek110237 define file name=temp_0_1,path=$dir,size=4943m,reuse,prealloc,paralloc
     73  5184  ek110237 define file name=ware_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
     74  5184  ek110237 define file name=log_1_1,path=$dir,size=1021m,reuse,prealloc,paralloc
     75  5184  ek110237 
     76  5184  ek110237 # Define database writer processes
     77  5184  ek110237 define process name=dbwr,instances=$ndbwriters
     78  5184  ek110237 {
     79  5184  ek110237   thread name=dbwr,memsize=$memperthread,useism
     80  5184  ek110237   {
     81  5184  ek110237 	flowop aiowrite name=dbaiowrite-aux.df,filename=aux.df,
     82  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     83  5184  ek110237         flowop aiowrite name=dbaiowrite-control_001,filename=control_001,
     84  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     85  5184  ek110237         flowop aiowrite name=dbaiowrite-cust_0_0,filename=cust_0_0,
     86  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     87  5184  ek110237         flowop aiowrite name=dbaiowrite-cust_0_1,filename=cust_0_1,
     88  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     89  5184  ek110237         flowop aiowrite name=dbaiowrite-cust_0_2,filename=cust_0_2,
     90  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     91  5184  ek110237         flowop aiowrite name=dbaiowrite-cust_0_3,filename=cust_0_3,
     92  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     93  5184  ek110237         flowop aiowrite name=dbaiowrite-dist_0_0,filename=dist_0_0,
     94  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     95  5184  ek110237         flowop aiowrite name=dbaiowrite-hist_0_0,filename=hist_0_0,
     96  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     97  5184  ek110237         flowop aiowrite name=dbaiowrite-icust1_0_0,filename=icust1_0_0,
     98  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
     99  5184  ek110237         flowop aiowrite name=dbaiowrite-icust2_0_0,filename=icust2_0_0,
    100  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    101  5184  ek110237         flowop aiowrite name=dbaiowrite-idist_0_0,filename=idist_0_0,
    102  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    103  5184  ek110237         flowop aiowrite name=dbaiowrite-iitem_0_0,filename=iitem_0_0,
    104  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    105  5184  ek110237         flowop aiowrite name=dbaiowrite-iordr2_0_0,filename=iordr2_0_0,
    106  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    107  5184  ek110237         flowop aiowrite name=dbaiowrite-istok_0_0,filename=istok_0_0,
    108  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    109  5184  ek110237         flowop aiowrite name=dbaiowrite-item_0_0,filename=item_0_0,
    110  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    111  5184  ek110237         flowop aiowrite name=dbaiowrite-iware_0_0,filename=iware_0_0,
    112  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    113  5184  ek110237         flowop aiowrite name=dbaiowrite-nord_0_0,filename=nord_0_0,
    114  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    115  5184  ek110237         flowop aiowrite name=dbaiowrite-ordr_0_0,filename=ordr_0_0,
    116  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    117  5184  ek110237         flowop aiowrite name=dbaiowrite-roll1,filename=roll1,
    118  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    119  5184  ek110237         flowop aiowrite name=dbaiowrite-sp_0,filename=sp_0,
    120  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    121  5184  ek110237         flowop aiowrite name=dbaiowrite-stok_0_0,filename=stok_0_0,
    122  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    123  5184  ek110237         flowop aiowrite name=dbaiowrite-stok_0_1,filename=stok_0_1,
    124  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    125  5184  ek110237         flowop aiowrite name=dbaiowrite-stok_0_2,filename=stok_0_2,
    126  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    127  5184  ek110237         flowop aiowrite name=dbaiowrite-stok_0_3,filename=stok_0_3,
    128  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    129  5184  ek110237         flowop aiowrite name=dbaiowrite-stok_0_4,filename=stok_0_4,
    130  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    131  5184  ek110237         flowop aiowrite name=dbaiowrite-system_1,filename=system_1,
    132  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    133  5184  ek110237         flowop aiowrite name=dbaiowrite-temp_0_0,filename=temp_0_0,
    134  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    135  5184  ek110237         flowop aiowrite name=dbaiowrite-temp_0_1,filename=temp_0_1,
    136  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    137  5184  ek110237         flowop aiowrite name=dbaiowrite-ware_0_0,filename=ware_0_0,
    138  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio,iters=10
    139  5184  ek110237 	flowop hog name=dbwr-hog,value=10000
    140  5184  ek110237 	flowop semblock name=dbwr-block,value=100,highwater=10000
    141  5184  ek110237 	flowop aiowait name=dbwr-aiowait
    142  5184  ek110237   }
    143  5184  ek110237 }
    144  5184  ek110237 
    145  5184  ek110237 define process name=lgwr,instances=1
    146  5184  ek110237 {
    147  5184  ek110237   thread name=lgwr,memsize=$memperthread,useism
    148  5184  ek110237   {
    149  5184  ek110237     flowop write name=lg-write,filename=log_1_1,
    150  5184  ek110237         iosize=256k,workingset=1g,random,dsync,directio
    151  5184  ek110237 #   flowop delay name=lg-delay,value=1
    152  5184  ek110237     flowop semblock name=lg-block,value=320,highwater=1000
    153  5184  ek110237   }
    154  5184  ek110237 }
    155  5184  ek110237 
    156  5184  ek110237 define process name=shadow,instances=$nshadows
    157  5184  ek110237 {
    158  5184  ek110237   thread name=shadow,memsize=$memperthread,useism
    159  5184  ek110237   {
    160  5184  ek110237         flowop read name=shadowread-aux.df,filename=aux.df,
    161  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    162  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    163  5184  ek110237         flowop read name=shadowread-control_001,filename=control_001,
    164  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    165  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    166  5184  ek110237         flowop read name=shadowread-cust_0_0,filename=cust_0_0,
    167  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    168  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    169  5184  ek110237         flowop read name=shadowread-cust_0_1,filename=cust_0_1,
    170  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    171  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    172  5184  ek110237         flowop read name=shadowread-cust_0_2,filename=cust_0_2,
    173  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    174  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    175  5184  ek110237         flowop read name=shadowread-cust_0_3,filename=cust_0_3,
    176  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    177  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    178  5184  ek110237         flowop read name=shadowread-dist_0_0,filename=dist_0_0,
    179  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    180  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    181  5184  ek110237         flowop read name=shadowread-hist_0_0,filename=hist_0_0,
    182  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    183  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    184  5184  ek110237         flowop read name=shadowread-icust1_0_0,filename=icust1_0_0,
    185  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    186  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    187  5184  ek110237         flowop read name=shadowread-icust2_0_0,filename=icust2_0_0,
    188  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    189  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    190  5184  ek110237         flowop read name=shadowread-idist_0_0,filename=idist_0_0,
    191  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    192  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    193  5184  ek110237         flowop read name=shadowread-iitem_0_0,filename=iitem_0_0,
    194  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    195  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    196  5184  ek110237         flowop read name=shadowread-iordr2_0_0,filename=iordr2_0_0,
    197  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    198  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    199  5184  ek110237         flowop read name=shadowread-istok_0_0,filename=istok_0_0,
    200  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    201  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    202  5184  ek110237         flowop read name=shadowread-item_0_0,filename=item_0_0,
    203  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    204  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    205  5184  ek110237         flowop read name=shadowread-iware_0_0,filename=iware_0_0,
    206  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    207  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    208  5184  ek110237         flowop read name=shadowread-nord_0_0,filename=nord_0_0,
    209  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    210  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    211  5184  ek110237         flowop read name=shadowread-ordr_0_0,filename=ordr_0_0,
    212  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    213  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    214  5184  ek110237         flowop read name=shadowread-roll1,filename=roll1,
    215  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    216  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    217  5184  ek110237         flowop read name=shadowread-sp_0,filename=sp_0,
    218  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    219  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    220  5184  ek110237         flowop read name=shadowread-stok_0_0,filename=stok_0_0,
    221  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    222  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    223  5184  ek110237         flowop read name=shadowread-stok_0_1,filename=stok_0_1,
    224  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    225  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    226  5184  ek110237         flowop read name=shadowread-stok_0_2,filename=stok_0_2,
    227  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    228  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    229  5184  ek110237         flowop read name=shadowread-stok_0_3,filename=stok_0_3,
    230  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    231  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    232  5184  ek110237         flowop read name=shadowread-stok_0_4,filename=stok_0_4,
    233  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    234  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    235  5184  ek110237         flowop read name=shadowread-system_1,filename=system_1,
    236  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    237  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    238  5184  ek110237         flowop read name=shadowread-temp_0_0,filename=temp_0_0,
    239  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    240  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    241  5184  ek110237         flowop read name=shadowread-temp_0_1,filename=temp_0_1,
    242  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    243  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    244  5184  ek110237         flowop read name=shadowread-ware_0_0,filename=ware_0_0,
    245  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    246  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    247  5184  ek110237         flowop read name=shadowread-log_1_1,filename=log_1_1,
    248  5184  ek110237                 iosize=$iosize,workingset=10g,random,dsync,directio
    249  5184  ek110237         flowop hog name=shadowhog,value=$usermode
    250  5184  ek110237 	flowop sempost name=shadow-post-lg,value=1,target=lg-block,blocking
    251  5184  ek110237 	flowop sempost name=shadow-post-dbwr,value=1,target=dbwr-block,blocking
    252  5184  ek110237 	flowop eventlimit name=random-rate
    253  5184  ek110237   }
    254  5184  ek110237 }
    255  5184  ek110237 
    256  9801    Andrew echo "Tpcso Version 2.1 personality successfully loaded"
    257  9801    Andrew usage "Usage: set \$dir=<dir>         defaults to $dir"
    258  9801    Andrew usage " "
    259  9801    Andrew usage "       set \$eventrate=<value> defaults to $eventrate"
    260  5184  ek110237 usage " "
    261  5184  ek110237 usage "       set \$iosize=<value>    defaults to $iosize, typically 2k or 8k"
    262  5184  ek110237 usage " "
    263  5184  ek110237 usage "       set \$memperthread=<value> defaults to $memperthread, there are 211 threads"
    264  5184  ek110237 usage " "
    265  5184  ek110237 usage "       run runtime (e.g. run 60)"
    266  5184  ek110237 usage " "
    267  5184  ek110237 usage "Note - this workload needs at least 512MB of of memory"
    268  5184  ek110237 usage " "
    269