github.com/dolthub/dolt/go@v0.40.5-0.20240520175717-68db7794bea6/performance/continuous_integration/mysqld.cnf (about)

     1  #
     2  # The MySQL database server configuration file.
     3  #
     4  # One can use all long options that the program supports.
     5  # Run program with --help to get a list of available options and with
     6  # --print-defaults to see which it would actually understand and use.
     7  #
     8  # For explanations see
     9  # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
    10  
    11  # Here is entries for some specific programs
    12  # The following values assume you have at least 32M ram
    13  
    14  [mysqld]
    15  #
    16  # * Basic Settings
    17  #
    18  user		= tester
    19  pid-file	= /home/tester/.mysql/mysqld.pid
    20  socket	    = /home/tester/.mysql/mysqld.sock
    21  # port		= 3306
    22  # datadir	= /var/lib/mysql
    23  
    24  
    25  # If MySQL is running as a replication slave, this should be
    26  # changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
    27  # tmpdir		= /tmp
    28  #
    29  # Instead of skip-networking the default is now to listen only on
    30  # localhost which is more compatible and is not less secure.
    31  bind-address		= 127.0.0.1
    32  mysqlx-bind-address	= 127.0.0.1
    33  #
    34  # * Fine Tuning
    35  #
    36  key_buffer_size		= 16M
    37  # max_allowed_packet	= 64M
    38  # thread_stack		= 256K
    39  
    40  # thread_cache_size       = -1
    41  
    42  # This replaces the startup script and checks MyISAM tables if needed
    43  # the first time they are touched
    44  myisam-recover-options  = BACKUP
    45  
    46  # max_connections        = 151
    47  
    48  # table_open_cache       = 4000
    49  
    50  #
    51  # * Logging and Replication
    52  #
    53  # Both location gets rotated by the cronjob.
    54  #
    55  # Log all queries
    56  # Be aware that this log type is a performance killer.
    57  general_log_file        = /home/tester/.mysql/log/query.log
    58  # general_log             = 1
    59  #
    60  # Error log - should be very few entries.
    61  #
    62  log_error = /home/tester/.mysql/log/error.log
    63  #
    64  # Here you can see queries with especially long duration
    65  # slow_query_log		= 1
    66  slow_query_log_file	= /home/tester/.mysql/log/mysql-slow.log
    67  # long_query_time = 2
    68  # log-queries-not-using-indexes
    69  #
    70  # The following can be used as easy to replay backup logs or for replication.
    71  # note: if you are setting up a replication slave, see README.Debian about
    72  #       other settings you may need to change.
    73  # server-id		= 1
    74  log_bin			= /home/tester/.mysql/log/mysql-bin.log
    75  # binlog_expire_logs_seconds	= 2592000
    76  max_binlog_size   = 100M
    77  # binlog_do_db		= include_database_name
    78  # binlog_ignore_db	= include_database_name