차이
문서의 선택한 두 판 사이의 차이를 보여줍니다.
mysql_8_암호_복잡성_설정 [2020/02/18 03:50] – 만듦 koov | mysql_8_암호_복잡성_설정 [2020/02/18 03:50] (현재) – [정책 변경] koov | ||
---|---|---|---|
줄 61: | 줄 61: | ||
<code vim / | <code vim / | ||
[mysqld] | [mysqld] | ||
- | # | ||
- | # Remove leading # and set to the amount of RAM for the most important data | ||
- | # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. | ||
- | # innodb_buffer_pool_size = 128M | ||
- | # | ||
- | # Remove the leading "# " to disable binary logging | ||
- | # Binary logging captures changes between backups and is enabled by | ||
- | # default. It's default setting is log_bin=binlog | ||
- | # disable_log_bin | ||
- | # | ||
- | # Remove leading # to set options mainly useful for reporting servers. | ||
- | # The server defaults are faster for transactions and fast SELECTs. | ||
- | # Adjust sizes as needed, experiment to find the optimal values. | ||
- | # join_buffer_size = 128M | ||
- | # sort_buffer_size = 2M | ||
- | # read_rnd_buffer_size = 2M | ||
- | # | ||
- | # Remove leading # to revert to previous value for default_authentication_plugin, | ||
- | # this will increase compatibility with older clients. For background, see: | ||
- | # https:// | ||
- | # default-authentication-plugin=mysql_native_password | ||
- | default-authentication-plugin=mysql_native_password | ||
- | |||
datadir=/ | datadir=/ | ||
socket=/ | socket=/ |