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

Today's Xiaobian shares a performance test report on DM database. Maybe you are familiar with DM database or have never known DM database. But don't worry, today's editor will explain the principle of clustering algorithm with the simplest description.

I. environment briefing

1.1 Tester environment:

Description:

Test machine environment for the general host can be, the requirements are not high

1.2 Virtual machine environment:

II. test topology

Description:

1. Performance testing for different hosts i.e. tester and DUT not on one machine

2. The tester can be a general host

3. The minimum network between the tester and the physical machine is a gigabit network

Note: Currently Huawei Kunpeng server. The same applies to Great Wall servers

III. test step

3.1 Create test user and table

Enter in the database:

create tablespace "TPCC" datafile 'TPCC.dbf' size 10000 autoextend on;

create user benchmarksql identified by 123456789 default tablespace "TPCC";

grant dba to benchmarksql;

3.2 Executing Tools Creating Tables

[root@benchmarksql run]# ./ runSQL.sh props.dm sqlTableCreates

3.3 Execution tool loads test data, note that xxx should be maintained with the value of warehouses in the configuration file

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

3.4 Executing tools to create database indexes

[root@benchmarksql run]# ./ runSQL.sh props.dm sqlIndexCreates

3.5 Library expansion and logging

alter tablespace "ROLL" resize datafile 'ROLL.DBF' to 5000;

alter database resize logfile 'DAMENG01.log' to 20000;

alter database resize logfile 'DAMENG02.log' to 20000;

SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'ITEM', 1);

SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'WAREHOUSE', 1);

SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'DISTRICT', 1);

3.6 Set parameters to restart database services

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 = 64MAX_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

3.7 Load data into memory

select count() from "BENCHMARKSQL". "CUSTOMER" union all

select count() from "BENCHMARKSQL". "DISTRICT" union all

select count() from "BENCHMARKSQL". "ITEM" union all

select count() from "BENCHMARKSQL". "NEW_ORDER" union all

select count() from "BENCHMARKSQL". "OORDER" union all

select count() from "BENCHMARKSQL". "ORDER_LINE" union all

select count() from "BENCHMARKSQL". "STOCK" union all

select count() from "BENCHMARKSQL". "WAREHOUSE" union all

select count(*) from "BENCHMARKSQL". "HISTORY" union all

select count("C_PAYMENT_CNT") from "BENCHMARKSQL". "CUSTOMER";

3.8 Execution tool starts executing tests

[root@benchmarksql run]# ./ runBenchmark.sh props.dm

3.9 view results

[root@benchmarksql run]# cat ./ log/benchmarksql.log

The above is the DM database performance test report on the details of the content, after reading whether there is any harvest? If you want to know more, welcome to the industry information!

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.