github.com/bartle-stripe/trillian@v1.2.1/storage/mysql/kubernetes/image/my.cnf (about)

     1  [client]
     2  port=3306
     3  socket=/var/run/mysqld/mysqld.sock
     4  
     5  [mysqld_safe]
     6  socket=/var/run/mysqld/mysqld.sock
     7  nice=0
     8  
     9  [mysqld]
    10  user=mysql
    11  pid-file=/var/run/mysqld/mysqld.pid
    12  socket=/var/run/mysqld/mysqld.sock
    13  port=3306
    14  basedir=/usr
    15  datadir=/var/lib/mysql
    16  tmpdir=/tmp
    17  lc-messages-dir=/usr/share/mysql
    18  skip-external-locking
    19  
    20  max_allowed_packet=16M
    21  thread_stack=192K
    22  thread_cache_size=8
    23  
    24  #max_connections=100
    25  query_cache_limit=1M
    26  query_cache_size=16M
    27  slow_query_log=1
    28  slow_query_log_file=/var/log/mysql/mysql-slow.log
    29  long_query_time=2
    30  log-queries-not-using-indexes
    31  
    32  server-id=12345
    33  log_bin=/var/log/mysql/mysql-bin.log
    34  expire_logs_days=4
    35  max_binlog_size=100M
    36  
    37  default_storage_engine=InnoDB
    38  innodb_file_per_table
    39  innodb_log_file_size=100M
    40  innodb_log_buffer_size=10M
    41  innodb_log_files_in_group=2
    42  innodb_buffer_pool_instances=4
    43  innodb_buffer_pool_size=100M
    44  
    45  # Tuning tweaks
    46  wsrep_slave_threads=8
    47  join_buffer_size=1M
    48  innodb_buffer_pool_size=2G
    49  innodb_buffer_pool_instances=4
    50  innodb_io_capacity=15000
    51  innodb_log_files_in_group=2
    52  innodb_log_file_size=512M
    53  innodb_log_buffer_size=32M
    54  innodb_change_buffer_max_size=40
    55  thread_cache_size=512
    56  sort_buffer_size=512M
    57  read_rnd_buffer_size=512M
    58  
    59  [mysqldump]
    60  quick
    61  quote-names
    62  max_allowed_packet=16M
    63  
    64  !includedir /etc/mysql/conf.d/