차이
문서의 선택한 두 판 사이의 차이를 보여줍니다.
| 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=/ | ||