Environment Settings Configuration 83 Heap Sizing Options 83 JMX Options 83 Further Reading on JVM Tuning 84 Authentication and Authorization Configuration 84 access.properties 84 passwd.properties Installation Create a Column Family 2 Cassandra is a Java program and requires a Java Virtual Machine (JVM) to be installed before you can start the server. For production deployments, you will need the Sun Runtime Environment 1.6.0_19 or later, but if you are just installing an evaluation instance, any JVM is fine. To check for Java, run the following command in a terminal session: # java -version If

props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # OpenTelemetry: # props: # otel.service.name: metrics. • Parameter description Name Description host host IP port port jvm‐i nformation‐collector‐enabled whether to collect JVM indicator information OpenTelemetry OpenTelemetry can export tracing data through the Maven Plugin subproject of GraalVM Native Build Tools. By running the unit test under the JVM, label the unit test with junit-platform-unique-ids*, and then build it as GraalVM Native Im‐ age

props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # OpenTelemetry: # props: # otel.service.name: metrics. • Parameter description Name Description host host IP port port jvm‐i nformation‐collector‐enabled whether to collect JVM indicator information 9.1. ShardingSphere-JDBC 134 Apache ShardingSphere through the Maven Plugin subproject of GraalVM Native Build Tools. By running the unit test under the JVM, label the unit test with junit-platform-unique-ids*, and then build it as GraalVM Native Im‐ age

props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # OpenTelemetry: # props: # otel.service.name: 插件只有构建元数据耗时日志输出，暂无其他日志输出。 Prometheus 用于暴露监控指标 • 参数说明 名称 说明 host 主机 port 端口 jvm‐information‐collector‐enabled 是否采集 JVM 指标信息 9.1. ShardingSphere-JDBC 137 Apache ShardingSphere document OpenTelemetry GraalVM Native Image 下 的 可 用 性 的 验 证， 是 通 过 GraalVM Native Build Tools 的 Maven Plugin 子项目来完成的。通过在 JVM 下运行单元测试，为单元测试 打上 junit-platform-unique-ids* 标签，此后构建为 GraalVM Native Image 进行 na‐ tiveTest 来 测 试 在

props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # OpenTelemetry: # props: # otel.service.name: ShardingSphere document Prometheus 用于暴露监控指标 • 参数说明 名称 说明 host 主机 port 端口 jvm‐information‐collector‐enabled 是否采集 JVM 指标信息 OpenTelemetry OpenTelemetry 可以导出 tracing 数据到 Jaeger，Zipkin。 • 参数说明 名称 GraalVM Native Image 下 的 可 用 性 的 验 证， 是 通 过 GraalVM Native Build Tools 的 Maven Plugin 子项目来完成的。通过在 JVM 下运行单元测试，为单元测试 打上 junit-platform-unique-ids* 标签，此后构建为 GraalVM Native Image 进行 na‐ tiveTest 来 测 试 在

props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # OpenTelemetry: # props: # otel.service.name: 插件只有构建元数据耗时日志输出，暂无其他日志输出。 Prometheus 用于暴露监控指标 • 参数说明 名称 说明 host 主机 port 端口 jvm‐information‐collector‐enabled 是否采集 JVM 指标信息 9.1. ShardingSphere-JDBC 120 Apache ShardingSphere document OpenTelemetry xy:latest 其中，ext-lib 非必需，用户可按需挂载。ShardingSphere‐Proxy 默认端口 3307，可以通过环境变量 -e PORT 指定。自定义 JVM 相关参数可通过环境变量 JVM_OPTS 设置。 说明： 支持设置 CGROUP_MEM_OPTS 环境变量: 用于在容器环境中设置相关内存参数，脚本中的默认值为： -XX:InitialRAMPercentage=80

OpenTelemetry - Logging - Prometheus plugins: Prometheus: host: "localhost" port: 9090 props: JVM_INFORMATION_COLLECTOR_ENABLED : "true" Jaeger: host: "localhost" port: 5775 props: SERVICE_NAME: ShardingSphere document, v5.1.1 Name Descrip- tion Value range Default value JVM _IN‐ FORMA‐ TION_CO LLEC‐ TOR_ENABLED Start JVM collector true、false true SER‐ VICE_NAME Tracking service name Custom a independent thread pool, it does not share thread pool even dif‐ ferent data source in same JVM i n f i n i t e ma x‐co nnec tion s‐si ze‐p er‐q uery (?) i n t Max opened connec‐ tion size for

OpenTelemetry - Logging - Prometheus plugins: Prometheus: host: "localhost" port: 9090 props: JVM_INFORMATION_COLLECTOR_ENABLED : "true" Jaeger: host: "localhost" port: 5775 props: SERVICE_NAME: ShardingSphere document, v5.1.2 Name Descrip- tion Value range Default value JVM _IN‐ FORMA‐ TION_CO LLEC‐ TOR_ENABLED Start JVM collector true, false true SER‐ VICE_NAME Tracking service name a independent thread pool, it does not share thread pool even dif‐ ferent data source in same JVM i n f i n i t e ma x‐co nnec tion s‐si ze‐p er‐q uery (?) i n t Max opened connec‐ tion size for

with no data. ● Less fragment(Allocate 2MB one time) , Less Mixed GC. ● JVM will never free BucketCache’s byte buffer. ● But JVM will still sweep the buffer and compact them. (old generation) BucketCache no data. After GC (G1) bucket-4KB (2MB) bucket-8KB (2MB) bucket-16KB (2MB) bucket-32KB (2MB) ● JVM will NOT sweep the cache and compacting them (old generation) ● Less mixed GC(s) and shorter STW time

designated according to environment variable -e PORT Customized JVM related parameters can be set according to environment variable JVM_OPTS 5. Use Client to connect to ShardingSphere‐Proxy Please refer ShardingSphere‐ DataSource uses an independent thread pool，and different data sources on the same JVM do not share thread pools. i n f i n i t e F a l s e ma x‐co nnec tion s‐si ze‐p er‐q uery ( props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # Jaeger: # host: "localhost" # port: 5775 #