Advertisement
Guest User

conf

a guest
Feb 23rd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.53 KB | None | 0 0
  1. #
  2. # These groups are read by MariaDB server.
  3. # Use it for options that only the server (but not clients) should see
  4. #
  5. # See the examples of server my.cnf files in /usr/share/mysql/
  6. #
  7.  
  8. # this is read by the standalone daemon and embedded servers
  9. [server]
  10.  
  11. # this is only for the mysqld standalone daemon
  12. [mysqld]
  13.  
  14. #
  15. # * Basic Settings
  16. #
  17. user = mysql
  18. pid-file = /var/run/mysqld/mysqld.pid
  19. socket = /var/run/mysqld/mysqld.sock
  20. port = 3306
  21. basedir = /usr
  22. datadir = /var/lib/mysql
  23. tmpdir = /tmp
  24. lc-messages-dir = /usr/share/mysql
  25. skip-external-locking
  26.  
  27. # Instead of skip-networking the default is now to listen only on
  28. # localhost which is more compatible and is not less secure.
  29. bind-address = 0.0.0.0
  30.  
  31. #
  32. # * Fine Tuning
  33. #
  34. key_buffer_size = 16M
  35. max_allowed_packet = 16M
  36. thread_stack = 192K
  37. thread_cache_size = 8
  38. # This replaces the startup script and checks MyISAM tables if needed
  39. # the first time they are touched
  40. myisam-recover = BACKUP
  41. #max_connections = 100
  42. #table_cache = 64
  43. #thread_concurrency = 10
  44.  
  45. #
  46. # * Query Cache Configuration
  47. #
  48. query_cache_limit = 1M
  49. query_cache_size = 16M
  50.  
  51. #
  52. # * Logging and Replication
  53. #
  54. # Both location gets rotated by the cronjob.
  55. # Be aware that this log type is a performance killer.
  56. # As of 5.1 you can enable the log at runtime!
  57. #general_log_file = /var/log/mysql/mysql.log
  58. #general_log = 1
  59. #
  60. # Error log - should be very few entries.
  61. #
  62. log_error = /var/log/mysql/error.log
  63. #
  64. # Enable the slow query log to see queries with especially long duration
  65. #slow_query_log_file = /var/log/mysql/mariadb-slow.log
  66. #long_query_time = 10
  67. #log_slow_rate_limit = 1000
  68. #log_slow_verbosity = query_plan
  69. #log-queries-not-using-indexes
  70. #
  71. # The following can be used as easy to replay backup logs or for replication.
  72. # note: if you are setting up a replication slave, see README.Debian about
  73. # other settings you may need to change.
  74. #server-id = 1
  75. log_bin = /var/log/mysql/mysql-bin.log
  76. expire_logs_days = 10
  77. max_binlog_size = 100M
  78. #binlog_do_db = include_database_name
  79. #binlog_ignore_db = include_database_name
  80.  
  81. #
  82. # * InnoDB
  83. #
  84. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  85. # Read the manual for more InnoDB related options. There are many!
  86.  
  87. #
  88. # * Security Features
  89. #
  90. # Read the manual, too, if you want chroot!
  91. # chroot = /var/lib/mysql/
  92. #
  93. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  94. #
  95. # ssl-ca=/etc/mysql/cacert.pem
  96. # ssl-cert=/etc/mysql/server-cert.pem
  97. # ssl-key=/etc/mysql/server-key.pem
  98.  
  99. #
  100. # * Character sets
  101. #
  102. # MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
  103. # utf8 4-byte character set. See also client.cnf
  104. #
  105. character-set-server = utf8mb4
  106. collation-server = utf8mb4_general_ci
  107.  
  108. #
  109. # * Unix socket authentication plugin is built-in since 10.0.22-6
  110. #
  111. # Needed so the root database user can authenticate without a password but
  112. # only when running as the unix root user.
  113. #
  114. # Also available for other users if required.
  115. # See https://mariadb.com/kb/en/unix_socket-authentication-plugin/
  116.  
  117. # this is only for embedded server
  118. [embedded]
  119.  
  120. # This group is only read by MariaDB servers, not by MySQL.
  121. # If you use the same .cnf file for MySQL and MariaDB,
  122. # you can put MariaDB-only options here
  123. [mariadb]
  124.  
  125. # This group is only read by MariaDB-10.0 servers.
  126. # If you use the same .cnf file for MariaDB of different versions,
  127. # use this group for options that older servers don't understand
  128. [mariadb-10.0]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement