Comments (1)
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)
- Foreign Key on replicated tables HOT 6
- tabse怎么更新软件版本,并保留数据 HOT 2
- Regression for `insert .. select..` in 2.3.0 HOT 4
- Unable to use immutable function in the partial functional index. HOT 3
- pgxc_ctl init all失败 HOT 1
- 至今还在PostgreSQL10的级别。TBase有考虑升级吗? HOT 1
- postgres迁移到TBase时uuid类型的字段如何处理?
- some solutions to share HOT 3
- Oriole storage engine compatibility
- 推出社区官网,丰富文档 HOT 1
- complie error
- TBase开源版本是否不支持存储过程?
- 表无法删除
- postGis插件加载不了 HOT 2
- spatial_ref_sys表有数据但查不出来 HOT 1
- Create Discord/Slack Channel for Project Communication HOT 1
- audit_admin user cannot execute ‘audit all;’ in md5 authenrization. HOT 2
- TBase data compare
- TBase是否有支持存储海量的非结构化文件数据的特性或组件?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tbase.