my.cnf 1.3 KB

12345678910111213141516171819202122232425262728293031323334
  1. # from docker mysql/mysql-server:8.0.18
  2. #
  3. # For advice on how to change settings please see
  4. # http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
  5. [mysqld]
  6. #
  7. # Remove leading # and set to the amount of RAM for the most important data
  8. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
  9. # innodb_buffer_pool_size = 128M
  10. #
  11. # Remove leading # to turn on a very important data integrity option: logging
  12. # changes to the binary log between backups.
  13. # log_bin
  14. #
  15. # Remove leading # to set options mainly useful for reporting servers.
  16. # The server defaults are faster for transactions and fast SELECTs.
  17. # Adjust sizes as needed, experiment to find the optimal values.
  18. # join_buffer_size = 128M
  19. # sort_buffer_size = 2M
  20. # read_rnd_buffer_size = 2M
  21. # Remove leading # to revert to previous value for default_authentication_plugin,
  22. # this will increase compatibility with older clients. For background, see:
  23. # https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
  24. # default-authentication-plugin=mysql_native_password
  25. skip-host-cache
  26. skip-name-resolve
  27. datadir=/var/lib/mysql
  28. socket=/var/lib/mysql/mysql.sock
  29. secure-file-priv=/var/lib/mysql-files
  30. user=mysql
  31. pid-file=/var/run/mysqld/mysqld.pid