execution errors jdbc_st ate‐ ment_execute _la‐ tency_millis H IS TO GR AM Statement execution latency jdbc_tra nsac‐ tions_total G AU GE Total number of transactions, classify by commit and rollback classify by commit, roll‐ back p roxy_exec ute_laten cy_millis H I S T O G R A M Execute latency millis histogram of ShardingSphere‐Proxy proxy_ex ecute_err ors_total C O U N T E R Total executor Performance Test 470 Apache ShardingSphere document Latency (ms): min: 5.37 # minimum latency avg: 17.13 # average latency max: 109.75 # maximum latency 95th percentile: 24.83 # average response time

execution errors jdbc_st ate‐ ment_execute _la‐ tency_millis H IS TO GR AM Statement execution latency jdbc_tra nsac‐ tions_total G AU GE Total number of transactions, classify by commit and rollback classify by commit, roll‐ back p roxy_exec ute_laten cy_millis H I S T O G R A M Execute latency millis histogram of ShardingSphere‐Proxy proxy_ex ecute_err ors_total C O U N T E R Total executor Performance Test 499 Apache ShardingSphere document Latency (ms): min: 5.37 # minimum latency avg: 17.13 # average latency max: 109.75 # maximum latency 95th percentile: 24.83 # average response time

G AU GE proxy connection total pr oxy_execute_l atency_millis H IS TO GR AM proxy executor latency millis proxy_execut e_error_total C OU NT ER proxy executor error total route_sql _se‐ lect_total events: 1397185 # toal number of transactions Latency (ms): min: 5.37 # minimum latency avg: 17.13 # average latency max: 109.75 # maximum latency 95th percentile: 24.83 # average response time

events: 1397185 # toal number of transactions Latency (ms): min: 5.37 # minimum latency avg: 17.13 # average latency max: 109.75 # maximum latency 95th percentile: 24.83 # average response time

语句执行总数 jdbc_statement_e xe‐ cute_errors_total C OUN TER 语句执行错误总数 jdbc_statement_exe cute_latency_millis HIS TOG RAM 语句执行耗时 jdbc _transac‐ tions_total C OUN TER 事务总数，按 commit，rollback 分类 nsac‐ tions_total C OUN TER ShardingSphere‐Proxy 的事务总数，按 commit，rollback 分类 proxy_execute _latency_millis HIS TOG RAM ShardingSphere‐Proxy 的执行耗时毫秒直方图 proxy_execu te_errors_total C OUN TER General statistics: total time: 120.0463s # 总共耗时 total number of events: 1397185 # 总共发生多 少事务数 Latency (ms): min: 5.37 # 最小延时 avg: 17.13 # 平均延时 max: 109.75 # 最大延时 95th percentile: 24.83 # 超过 95%

语句执行总数 jdbc_statement_e xe‐ cute_errors_total C OUN TER 语句执行错误总数 jdbc_statement_exe cute_latency_millis HIS TOG RAM 语句执行耗时 jdbc _transac‐ tions_total C OUN TER 事务总数，按 commit，rollback 分类 nsac‐ tions_total C OUN TER ShardingSphere‐Proxy 的事务总数，按 commit，rollback 分类 proxy_execute _latency_millis HIS TOG RAM ShardingSphere‐Proxy 的执行耗时毫秒直方图 proxy_execu te_errors_total C OUN TER General statistics: total time: 120.0463s # 总共耗时 total number of events: 1397185 # 总共发生多 少事务数 Latency (ms): min: 5.37 # 最小延时 avg: 17.13 # 平均延时 max: 109.75 # 最大延时 95th percentile: 24.83 # 超过 95%

语句执行总数 j dbc_statement_exe cute_errors_total C OU NT ER 语句执行错误总数 jdb c_statement_execu te_latency_millis H IS TO GR AM 语句执行耗时 jdbc_t ransac‐ tions_total C OU NT ER 事务总数，按 commit，rollback nsac‐ tions_total C OUN TER ShardingSphere‐Proxy 的事务总数，按 commit，rollback 分类 proxy_execute _latency_millis HIS TOG RAM ShardingSphere‐Proxy 的执行耗时毫秒直方图 proxy_execu te_errors_total C OUN TER General statistics: total time: 120.0463s # 总共耗时 total number of events: 1397185 # 总共发生多 少事务数 Latency (ms): min: 5.37 # 最小延时 avg: 17.13 # 平均延时 max: 109.75 # 最大延时 95th percentile: 24.83 # 超过 95%

The OLTP option may re‐ duce time cost of writing packets to client, but it may increase the latency of SQL ex‐ ecution if client connections are more than proxy-frontend-netty-executor-size, especially

The OLTP option may re‐ duce time cost of writing packets to client, but it may increase the latency of SQL execution and block other clients if client connections are more than proxy-frontend-executor-size

The OLTP option may re‐ duce time cost of writing packets to client, but it may increase the latency of SQL execution and block other clients if client connections are more than proxy-frontend-executor-size