下载

https://sourceforge.net/projects/benchmarksql/?source=typ_redirect

0. Requirements


Use of JDK7 is required.---经过我测试，使用rhel自带的openjdk就行。


1. Create the benchmarksql user and a database


As Unix user postgres use the psql shell to connect to the postgres
database and issue the CREATE USER and CREATE DATABASE commands.

@H_502_20@[postgres#localhost ~] $ psql postgres psql (9.5.2) Type "help" for help. postgres=# CREATE USER benchmarksql WITH ENCRYPTED PASSWORD 'changeme'; postgres=# CREATE DATABASE benchmarksql OWNER benchmarksql; postgres=# \q [postgres#localhost ~] $


2. Compile the Benchmarksql source code

@H_502_20@[wieck@localhost ~] $ cd benchmarksql yum install ant vi +23 build.xml 定位到第23行 <javac encoding="utf-8" srcdir="${src}" destdir="${build}" classpathref="classpath" ~~~~~~~~~~~~~~~这是新加的 vi +36 build.xml 定位到第36行 osCollectorDevices=net_enp0s3 blk_sda ~~~~~~~~~~~~~~此处自己写网卡名称和磁盘名称。 [wieck@localhost ~] $ cd benchmarksql [wieck@localhost benchmarksql] $ ant



3. Create the benchmark configuration file


[wieck@localhost benchmarksql] $ cd run
[wieck@localhost run] $ cp props.pg my_postgres.properties
[wieck@localhost run] $ vi my_postgres.properties
[wieck@localhost run] $
如下是修改过的参数
@H_502_20@[highgo@hgdb01 run]$ cat my_postgres.properties db=postgres driver=org.postgresql.Driver conn=jdbc:postgresql://192.168.80.172:5432/benchmarksql?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory user=benchmarksql password=changeme warehouses=1 loadWorkers=4 terminals=5 //To run specified transactions per terminal- runMins must equal zero runTxnsPerTerminal=0 //To run for specified minutes- runTxnsPerTerminal must equal zero runMins=10 //Number of total transactions per minute limitTxnsPerMin=0 --->>>表示不限制每分钟的事务数 //Set to true to run in 4.x compatible mode. Set to false to use the //entire configured database evenly. terminalWarehouseFixed=true //The following five values must add up to 100 //The default percentages of 45,43,4,4 & 4 match the TPC-C spec newOrderWeight=45 paymentWeight=43 orderStatusWeight=4 deliveryWeight=4 stockLevelWeight=4 // Directory name to create for collecting detailed result data. // Comment this out to suppress. resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS osCollectorScript=./misc/os_collector_linux.py osCollectorInterval=1 //osCollectoRSSHAddr=user@dbhost osCollectorDevices=net_enp0s3 blk_sda [highgo@hgdb01 run]$ 4. Build the schema and initial database load Execute the runDatabaseBuild.sh script with your configuration file. [wieck@localhost run]$ ./runDatabaseBuild.sh my_postgres.properties 5. Run the configured benchmark [wieck@localhost run]$ ./runBenchmark.sh my_postgres.properties 6. Scale the benchmark configuration. Change the my_postgres.properties file to the correct scaling (number of warehouses and concurrent connections/terminals). Switch from using a transaction count to time based: runTxnsPerTerminal=0 runMins=180 Rebuild the database (if needed) by running [wieck@localhost run]$ ./runDatabaseDestroy.sh my_postgres.properties [wieck@localhost run]$ ./runDatabaseBuild.sh my_postgres.properties Then run the benchmark again. Rinse and repeat. 7. Result report Benchmarksql collects detailed performance statistics and (if configured) OS performance data. The example configuration file defaults to a directory starting with my_result_. Use the generateReport.sh DIRECTORY script to create an HTML file with graphs. This requires R to be installed,which is beyond the scope of this HOW-TO.