Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 02 Aug 2020 05:48:28 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 248422] mysql 5.7.31 non-working default config
Message-ID:  <bug-248422-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D248422

            Bug ID: 248422
           Summary: mysql 5.7.31 non-working default config
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: Z462vasa@mail.lviv.ua

non-working default config=3D  my.cnf.sample=20

 $FreeBSD: head/databases/mysql57-server/files/my.cnf.sample.in 414707
2016-05-06 14:39:59Z riggs $

[client]
port                            =3D 3306
socket                          =3D /tmp/mysql.sock

[mysql]
prompt                          =3D \u@\h [\d]>\_
no_auto_rehash

[mysqld]
user                            =3D mysql
port                            =3D 3306
socket                          =3D /tmp/mysql.sock
bind-address                    =3D 127.0.0.1
basedir                         =3D /usr/local
datadir                         =3D /var/db/mysql
tmpdir                          =3D /var/db/mysql_tmpdir
slave-load-tmpdir               =3D /var/db/mysql_tmpdir
secure-file-priv                =3D /var/db/mysql_secure
log-bin                         =3D mysql-bin
log-output                      =3D TABLE
master-info-repository          =3D TABLE
relay-log-info-repository       =3D TABLE
relay-log-recovery              =3D 1
slow-query-log                  =3D 1
server-id                       =3D 1
sync_binlog                     =3D 1
sync_relay_log                  =3D 1
binlog_cache_size               =3D 16M
expire_logs_days                =3D 30
default_password_lifetime       =3D 0
enforce-gtid-consistency        =3D 1
gtid-mode                       =3D ON
safe-user-create                =3D 1
lower_case_table_names          =3D 1
explicit-defaults-for-timestamp =3D 1
myisam-recover-options          =3D BACKUP,FORCE
open_files_limit                =3D 32768
table_open_cache                =3D 16384
table_definition_cache          =3D 8192
net_retry_count                 =3D 16384
key_buffer_size                 =3D 256M
max_allowed_packet              =3D 64M
query_cache_type                =3D 0
query_cache_size                =3D 0
long_query_time                 =3D 0.5
innodb_buffer_pool_size         =3D 1G
innodb_data_home_dir            =3D /var/db/mysql
innodb_log_group_home_dir       =3D /var/db/mysql
innodb_data_file_path           =3D ibdata1:128M:autoextend
innodb_temp_data_file_path      =3D ibtmp1:128M:autoextend
innodb_flush_method             =3D O_DIRECT
innodb_log_file_size            =3D 256M
innodb_log_buffer_size          =3D 16M
innodb_write_io_threads         =3D 8
innodb_read_io_threads          =3D 8
innodb_autoinc_lock_mode        =3D 2
skip-symbolic-links

[mysqldump]
max_allowed_packet              =3D 256M
quote_names
quick



mysql 5.7.31

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-248422-7788>