Advertisement
Guest User

Untitled

a guest
Jul 19th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. [client]
  2. #password = your_password
  3. port = 3306
  4. socket = /var/lib/mysql/mysql.sock
  5. default-character-set = utf8
  6.  
  7.  
  8.  
  9. [mysqld]
  10. port = 3306
  11. socket = /var/lib/mysql/mysql.sock
  12. skip-external-locking
  13. key_buffer_size = 32M
  14. max_allowed_packet = 2M
  15. table_open_cache = 128
  16. sort_buffer_size = 1M
  17. net_buffer_length = 16K
  18. read_buffer_size = 512K
  19. read_rnd_buffer_size = 1M
  20. myisam_sort_buffer_size = 16M
  21.  
  22.  
  23. log-bin=mysql-bin
  24.  
  25. server-id = 1
  26.  
  27.  
  28. init_connect='SET collation_connection = utf8_unicode_ci'
  29. character-set-server = utf8
  30. collation-server = utf8_unicode_ci
  31.  
  32.  
  33. bind-address=127.0.0.1
  34.  
  35. innodb_flush_log_at_trx_commit=2
  36.  
  37. binlog_format=mixed
  38.  
  39.  
  40.  
  41. [mysqldump]
  42. quick
  43. max_allowed_packet = 32M
  44.  
  45.  
  46.  
  47. [mysql]
  48. no-auto-rehash
  49. character-sets-dir="/usr/share/mysql/charsets"
  50. default-character-set=cp866
  51.  
  52.  
  53.  
  54. [myisamchk]
  55. key_buffer_size = 40M
  56. sort_buffer_size = 40M
  57. read_buffer = 2M
  58. write_buffer = 2M
  59.  
  60.  
  61.  
  62. [mysqlhotcopy]
  63. interactive-timeout
  64.  
  65.  
  66.  
  67. [mysqld_safe]
  68. log-error=/var/log/mariadb/mariadb.log
  69. pid-file=/var/run/mariadb/mariadb.pid
  70.  
  71. #
  72. # include all files from the config directory
  73. #
  74. !includedir /etc/my.cnf.d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement