TPCC测试

首先是需要把benchmarksql工具解压到虚拟机

初始化设置
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;

配置props.dm脚本内容

插入数据
./runLoader.sh props.dm

修改dm.ini参数
MAX_OS_MEMORY = 100 MEMORY_POOL = 1000 BUFFER = 10000 BUFFER_POOLS = 10 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

修改完参数之后重启服务

运行测试并显示结果
./runBenchmark.sh props.dm