github.com/drud/ddev@v1.21.5-alpha1.0.20230226034409-94fcc4b94453/containers/ddev-dbserver/files/etc/my.cnf (about)

     1  [client]
     2  # CLIENT #
     3  port                           = 3306
     4  socket                         = /var/tmp/mysql.sock
     5  default-character-set = utf8mb4
     6  
     7  [mysqld]
     8  
     9  #
    10  # Remove leading # and set to the amount of RAM for the most important data
    11  # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    12  # innodb_buffer_pool_size = 128M
    13  #
    14  # Remove leading # to turn on a very important data integrity option: logging
    15  # changes to the binary log between backups.
    16  # log_bin
    17  #
    18  # Remove leading # to set options mainly useful for reporting servers.
    19  # The server defaults are faster for transactions and fast SELECTs.
    20  # Adjust sizes as needed, experiment to find the optimal values.
    21  # join_buffer_size = 128M
    22  # sort_buffer_size = 2M
    23  # read_rnd_buffer_size = 2M
    24  socket                         = /var/tmp/mysql.sock
    25  skip-host-cache
    26  skip-name-resolve
    27  datadir=/var/lib/mysql
    28  secure-file-priv=/var/lib/mysql-files
    29  
    30  innodb_use_native_aio=1
    31  expire-logs-days = 1
    32  
    33  # log_bin_trust_function_creators is required when log_bin is on for creating triggers
    34  log_bin_trust_function_creators=on
    35  
    36  character-set-server = utf8mb4
    37  collation-server = utf8mb4_general_ci
    38  init_connect='SET collation_connection = utf8mb4_unicode_ci'
    39  
    40  # Disabling symbolic-links is recommended to prevent assorted security risks
    41  symbolic-links=0
    42  
    43  
    44  # GENERAL #
    45  default-storage-engine         = InnoDB
    46  socket                         = /var/tmp/mysql.sock
    47  pid-file                       = /var/tmp/mysql.pid
    48  
    49  # MyISAM #
    50  key-buffer-size                = 64M
    51  
    52  # SAFETY #
    53  max-allowed-packet             = 256M
    54  max-connect-errors             = 1000000
    55  
    56  # CACHES AND LIMITS #
    57  tmp-table-size                 = 64M
    58  max-heap-table-size            = 64M
    59  ; these two are incompatible with mysql 8.0
    60  ;query-cache-type               = 0
    61  ;query-cache-size               = 0
    62  max-connections                = 100
    63  thread-cache-size              = 16
    64  open-files-limit               = 65535
    65  table-definition-cache         = 4096
    66  table-open-cache               = 4096
    67  
    68  # INNODB #
    69  # Cannot use O_DIRECT with windows mounts!!!
    70  # innodb-flush-method            = O_DIRECT
    71  innodb-log-files-in-group      = 2
    72  ; 48M is chosen here only to work around xtrabackup bug
    73  ; for mariadb 5.5, https://jira.percona.com/browse/PXB-450
    74  innodb-log-file-size           = 48M
    75  innodb-flush-log-at-trx-commit = 2
    76  innodb-file-per-table          = 1
    77  innodb-buffer-pool-size        = 1024M
    78  ; these two are incompatible with mysql 8.0
    79  ;innodb_large_prefix=true
    80  ;innodb_file_format=barracuda
    81  innodb_file_per_table=true
    82  
    83  # LOGGING #
    84  log-error                      = /var/log/mysqld.err
    85  log-queries-not-using-indexes  = 0
    86  slow-query-log                 = 1
    87  slow-query-log-file            = /var/log/mysqld.err
    88  long-query-time                = 10
    89  
    90  !includedir /etc/mysql/conf.d