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