tpcc测试步骤,请参考以下步骤操作
1.操作系统设置
groupadd kingbase
useradd -m -d /home/kingbase -g kingbase kingbase
/home/kingbase/KingbaseES/SupTools/kb_modify_syscfg/optimize_system_conf.sh
2.磁盘IO调度策略,设置为deadline
lsblk
echo deadline > /sys/block/sda/queue/scheduler
cat /sys/block/sda/queue/scheduler
none
3.如果是裸金属上测,内存超过256GB,可以开启内存大页,具体步骤请参考pg官方文档,搜索huge_page,可以看到开启步骤。
4.数据库参数
单机参数:
shared_preload_libraries='liboracle_parser'
commit_delay = 10
commit_siblings = 16
shared_buffers = 120GB #根据warehouse数及现场内存进行调整,调整原则尽量将数据都放入内存中
listen_addresses = '*'
port = 54321
huge_pages = off
maintenance_work_mem = 2GB
dynamic_shared_memory_type = posix
bgwriter_delay = 20ms
bgwriter_lru_maxpages = 1000
bgwriter_lru_multiplier = 10.0
effective_io_concurrency = 2
wal_level = minimal
synchronous_commit = off
wal_sync_method = open_sync
full_page_writes = off
fsync = off
wal_buffers = 1GB
wal_writer_delay = 20ms
checkpoint_timeout = 1d
max_wal_size = 100GB
checkpoint_completion_target = 0.8
effective