一、实验目标
1、使用 BenmarkSQL 运行 TPC-C ,并发数不用很高,5~10 并发即可(根据机器资源)。
2、分析 TPC-C TOP SQL,并查看 3条 SQL 的 解析执行计划 和 实际执行计划。
二、实验环境
OB环境如下
ip | 部署内容 | 备注 |
192.168.35.101 | obproxy,obclient | ob代理及客户端 |
192.168.35.102 | observer | ob集群zone1节点 |
192.168.35.103 | observer | ob集群zone2节点 |
192.168.35.104 | observer | ob集群zone3节点 |
三、ob配置
SYS 租户参数
alter system set net_thread_count = 32;
alter system set _clog_aggregation_buffer_amount=4;
alter system set _flush_clog_aggregation_buffer_timeout='1ms' ;
alter system set trace_log_slow_query_watermark='10s' ;
alter system set large_query_threshold='1s' ;
alter system set syslog_level='PERF';
alter system set clog_sync_time_warn_threshold='2000ms' ;
alter system set syslog_io_bandwidth_limit='10M' ;
alter system set enable_sql_audit=false;
alter system set enable_perf_event=false;
alter system set clog_max_unconfirmed_log_count=5000;
alter system set minor_warm_up_duration_time=0 ;
alter system set clog_transport_compress_all = true; --未成功
alter system set enable_clog_persistence_compress = true; --未成功
alter system set minor_merge_concurrency = 32;
alter system set _mini_merge_concurrency = 8;
alter system set freeze_trigger_percentage = 40;
alter system set autoinc_cache_refresh_interval='86400s';
alter system set cpu_quota_concurrency=2;
alter system set builtin_db_data_verify_cycle = 0 ;
alter system set micro_block_merge_verify_level = 0;
alter system set _ob_get_gts_ahead_interval = '0ms&#