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 = 16M
  14. max_allowed_packet = 1M
  15. table_open_cache = 64
  16. sort_buffer_size = 512K
  17. net_buffer_length = 8K
  18. read_buffer_size = 256K
  19. read_rnd_buffer_size = 512K
  20. myisam_sort_buffer_size = 8M
  21.  
  22.  
  23. log-bin=mysql-bin
  24.  
  25. server-id = 1
  26.  
  27. init_connect='SET collation_connection = utf8_unicode_ci'
  28. character-set-server = utf8
  29. collation-server = utf8_unicode_ci
  30.  
  31. bind-address=127.0.0.1
  32.  
  33. innodb_flush_log_at_trx_commit=2
  34.  
  35. binlog_format=mixed
  36.  
  37.  
  38.  
  39. [mysqldump]
  40. quick
  41. max_allowed_packet = 16M
  42.  
  43.  
  44.  
  45. [mysql]
  46. no-auto-rehash
  47. character-sets-dir="/usr/share/mysql/charsets"
  48. default-character-set=cp866
  49.  
  50.  
  51.  
  52. [myisamchk]
  53. key_buffer_size = 20M
  54. sort_buffer_size = 20M
  55. read_buffer = 2M
  56. write_buffer = 2M
  57.  
  58.  
  59.  
  60. [mysqlhotcopy]
  61. interactive-timeout
  62.  
  63.  
  64.  
  65. [mysqld_safe]
  66. log-error=/var/log/mariadb/mariadb.log
  67. pid-file=/var/run/mariadb/mariadb.pid
  68.  
  69. #
  70. # include all files from the config directory
  71. #
  72. !includedir /etc/my.cnf.d
Add Comment
Please, Sign In to add comment