mysql tpcc压测
配置
1 台 IT5.4XLARGE64 (高IO型IT5, 16核64GB）
mysql安装
安装过程（略）
重要配置
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_buffer_pool_size=32G
innodb_log_file_size = 2G
innodb_sort_buffer_size = 64M
max_connections = 5000
max_connect_errors = 1000000
table_open_cache = 2048
table_definition_cache = 2048
thread_stack = 2048K
sort_buffer_size = 4M
join_buffer_size = 4M
read_buffer_size = 8M
read_rnd_buffer_size = 4M
TPCC 安装
tpcc-mysql 安装
# 安装MySQL TPCC工具
wget https://github.com/Percona-Lab/tpcc-mysql/archive/refs/heads/master.zip
unzip master.zip
cd src
make
或
git clone https://github.com/percona/tpcc-mysql.git
cd tpcc-mysql
make
