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