Git Product home page Git Product logo

Comments (1)

JennyJennyChen avatar JennyJennyChen commented on September 28, 2024

1、TPCC推荐配置:
如三台机器16core + 64G,则tpcc的参数配置可以是
conn=jdbc:postgresql://192.168.0.2:11379,102.168.0.3:11381,192.168.0.4:11379/global?loadBalanceHosts=true&oracle_compile=true
warehouses=500
loadWorkers=32
terminals=96

内核参数:
persistent_datanode_connections = 'on'
enable_material = 'off'
enable_bitmapscan = 'off'
max_wal_size = '12GB'
shared_buffers = '16GB'
checkpoint_timeout = '600'
min_wal_size = '4GB'
pooler_scale_factor = '64'
archive_status_control = 'continue'
maintenance_work_mem = '4GB'
effective_cache_size = '50GB'
max_parallel_workers_per_gather = '0'
max_pool_size = '65535'
work_mem = '8MB'
wal_keep_segments = '4096'

2、针对你说的 select * from pg_prepared_xacts; 查询到的是2PC事务中处于prepare阶段的事务,在分布式系统中属于正常会自动结束,如果某个事务长时间不结束可能存在2PC残留的情况,可参考下面的材料进行人工自动清理:
https://github.com/Tencent/TBase/wiki/11-v2.3.0%E5%8D%87%E7%BA%A7%E7%89%B9%E6%80%A7pg_clean%E4%BD%BF%E7%94%A8%E8%AF%B4%E6%98%8E

from tbase.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.