github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/deploy/oracle-mysql/config/oracle-mysql-config.tpl (about) 1 [mysqld] 2 {{- $phy_memory := getContainerMemory ( index $.podSpec.containers 0 ) }} 3 {{- $pool_buffer_size := ( callBufferSizeByResource ( index $.podSpec.containers 0 ) ) }} 4 {{- if $pool_buffer_size }} 5 innodb_buffer_pool_size={{ $pool_buffer_size }} 6 {{- end }} 7 8 {{- $thread_stack := 262144 }} 9 {{- $binlog_cache_size := 32768 }} 10 {{- $join_buffer_size := 262144 }} 11 {{- $sort_buffer_size := 262144 }} 12 {{- $read_buffer_size := 262144 }} 13 {{- $read_rnd_buffer_size := 524288 }} 14 {{- $single_thread_memory := add $thread_stack $binlog_cache_size $join_buffer_size $sort_buffer_size $read_buffer_size $read_rnd_buffer_size }} 15 16 {{- if gt $phy_memory 0 }} 17 # Global_Buffer = innodb_buffer_pool_size = PhysicalMemory *3/4 18 # max_connections = (PhysicalMemory - Global_Buffer) / single_thread_memory 19 max_connections={{ div ( div $phy_memory 4 ) $single_thread_memory }} 20 {{- end}} 21 22 # if memory less than 8Gi, disable performance_schema 23 {{- if lt $phy_memory 8589934592 }} 24 performance_schema=OFF 25 {{- end }} 26 27 read_buffer_size={{ $read_buffer_size }} 28 read_rnd_buffer_size={{ $read_rnd_buffer_size }} 29 join_buffer_size={{ $join_buffer_size }} 30 sort_buffer_size={{ $sort_buffer_size }} 31 32 # gtid 33 gtid_mode=ON 34 enforce_gtid_consistency=ON 35 36 port=3306 37 mysqlx-port=33060 38 mysqlx=0 39 40 pid-file=/var/run/mysqld/mysqld.pid 41 socket=/var/run/mysqld/mysqld.sock 42 43 [client] 44 port=3306 45 socket=/var/run/mysqld/mysqld.sock