Shulou(Shulou.com)06/01 Report--

TPCC test record of Dameng database

Test environment

The main purpose of this article is to introduce the steps of TPCC testing using benchmarksql tools.

Use tool version: benchmarksql-4.1.1

Server: Huawei Taishan v1

CPU: Hayes 1616 32 core x2

Memory: 192 GB

Hard disk: 1.2Tx5

System: won the bid Kirin release V7Update6/ (Chromium)-aarch74

1. Upload the driver package jar file of the database

Upload directory: / home/setup/tpcc/benchmarksql-4.1.1/lib/

two。 Initialize related configuration

1. Create a test user

[root@oracle dm7] # su-dmdba

[dmdba@yun201 dmdbms] $cd / dm7/bin

[dmdba@yun201 bin] $. / disql SYSDBA/SYSDBA@localhost

Create tablespace TPCC datafile 'TPCC01.dbf' size 128 autoextend on maxsize unlimited

Create user BENCHMARKSQL identified by "123456789" default tablespace TPCC

Grant DBA to BENCHMARKSQL

2. Configure the content of props.dm script

Driver=dm.jdbc.driver.DmDriver

Conn=jdbc:dm://IP address: Port number

User=BENCHMARKSQL

Password=123456789

Warehouses=100

Terminals=144

/ / To run specified transactions per terminal- runMins must equal zero

RunTxnsPerTerminal=0

/ / To run for specified minutes- runTxnsPerTerminal must equal zero

RunMins=5

/ / Number of total transactions per minute

LimitTxnsPerMin=0

/ / The following five values must add up to 100

NewOrderWeight=45

PaymentWeight=43

OrderStatusWeight=4

DeliveryWeight=4

StockLevelWeight=4

Note: runMins=5 indicates that the test time is 5 minutes.

3. Create a tabl

Includes creating table statements, expanding libraries, as well as log files, optimizing table statements

First write the SQL statement in the sqlTableCreates_DM file

[root@isdtest run] # cd / home/setup/tpcc/benchmarksql-4.1.1/run

[root@isdtest run] #. / runSQL.sh props.dm dm01_sqlTableCreates

-bash:. / runSQL.sh: insufficient permissions

If you are prompted that this execution permission is not enough, the assignment permission operation will be performed:

[root@isdtest run] # chmod-R 755 / home/setup/tpcc/benchmarksql-4.1.1

4. Create an index

[root@isdtest run] #. / runSQL.sh props.dm dm02_sqlIndexCreates

5. Load data

Simulate the transaction data of real business

[root@isdtest run] #. / runLoader.sh props.dm numWarehouses 100

This step takes a while to wait, 20 minutes for good performance and 60 minutes for Taishan server.

The following information indicates that the execution of the load data is complete.

6. Modify database parameters

Manually modify the database parameters, such as the following parameters of the Damon database dm.ini:

MAX_OS_MEMORY = 100

MEMORY_POOL = 1000

BUFFER = 100000

BUFFER_POOLS = 101

FAST_POOL_PAGES = 90000

FAST_ROLL_PAGES = 80000

RECYCLE = 8

MULTI_PAGE_GET_NUM = 64

MAX_BUFFER = 100000

VM_MEM_HEAP = 0

WORKER_THREADS = 24

WORK_THRD_STACK_SIZE = 512

CKPT_RLOG_SIZE = 0

CKPT_INTERVAL = 3600

CKPT_DIRTY_PAGES = 0

FORCE_FLUSH_PAGES = 0

IO_THR_GROUPS = 12

CHECK_DB_IS_ACTIVE = 0

BDTA_SIZE = 20

ENABLE_SPACELIMIT_CHECK = 0

RLOG_PARALLEL_ENABLE = 1

RLOG_RESERVE_SIZE = 0

SESS_CHECK_INTERVAL = 30

FAST_RELEASE_SLOCK = 0

NOWAIT_WHEN_UNIQUE_CONFLICT = 1

UNDO_EXTENT_NUM = 32

UNDO_RETENTION = 1

MAX_SESSIONS = 1000

SUBQ_EXP_CVT_FLAG = 0

PURGE_DEL_OPT = 1

ENABLE_FREQROOTS = 2

CACHE_POOL_SIZE = 100

DICT_BUF_SIZE = 20

ENABLE_MONITOR = 0

Note the formula for 1:BUFFER estimation is: no more than 100m MagneBUFFER > = 100m * in a single library. If memory allows, you can zoom in.

Note the 2:WORKER_THREADS estimation formula is: WORKER_THREADS = the number of system logic cpu

Note the 3:IO_THR_GROUPS estimation formula is: IO_THR_GROUPS = the number of system logic cpu / 2

Note 4:BDTA_SIZE=20 and UNDO_RETENTION

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.