關(guān)于DM數(shù)據(jù)庫性能測(cè)試報(bào)告

今天小編分享的是關(guān)于DM數(shù)據(jù)庫性能測(cè)試報(bào)告，可能大家對(duì)DM數(shù)據(jù)庫并不陌生，或者從來沒有了解過DM數(shù)據(jù)庫。但是不用擔(dān)心，今天小編會(huì)以最簡(jiǎn)單的描述來講解聚類算法的原理。

一.環(huán)境說明

1.1 測(cè)試機(jī)環(huán)境：

說明：

測(cè)試機(jī)環(huán)境為一般主機(jī)即可，要求不高

1.2 虛擬機(jī)環(huán)境：

二.測(cè)試拓?fù)?br/>

說明：

1.性能測(cè)試為不同主機(jī)測(cè)試即：測(cè)試機(jī)與被測(cè)系統(tǒng)不再一個(gè)機(jī)器上面

2.測(cè)試機(jī)為一般主機(jī)即可

3.測(cè)試機(jī)與物理機(jī)之間的網(wǎng)絡(luò)最低為千兆網(wǎng)絡(luò)

注：當(dāng)前是華為鯤鵬服務(wù)器。同樣適用于長城服務(wù)器

三.測(cè)試步驟

3.1 創(chuàng)建測(cè)試用戶與表

在數(shù)據(jù)庫中輸入：

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 執(zhí)行工具創(chuàng)建表

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

3.3 執(zhí)行工具加載測(cè)試數(shù)據(jù)，注意xxx要與配置文件中的warehouses的值保持

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

3.4 執(zhí)行工具創(chuàng)建數(shù)據(jù)庫索引

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

3.5 擴(kuò)庫和日志

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 設(shè)置參數(shù)，要重啟數(shù)據(jù)庫服務(wù)

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 將數(shù)據(jù)加載到內(nèi)存

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 執(zhí)行工具開始執(zhí)行測(cè)試

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

3.9 查看結(jié)果

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

以上就是關(guān)于DM數(shù)據(jù)庫性能測(cè)試報(bào)告的詳細(xì)內(nèi)容了，看完之后是否有所收獲呢？如果如果想了解更多，歡迎來億速云行業(yè)資訊！