【MySQL】my.cnf 配置檔案

zlingyi發表於2016-10-13
MySql
記錄一份 my.cnf 作為自己生產的標配, 僅供參考。

  1. [client]
  2. default-character-set         = utf8mb4
  3. port                          = PORT
  4. socket                        = /srv/myPORT/run/mysql.sock

  6. [mysqld]
  7. user                          = mysql
  8. port                          = PORT
  9. extra-port                    = 1PORT
  10. character_set_server          = utf8mb4
  11. server_id                     = SERVER_ID
  12. socket                        = /srv/myPORT/run/mysql.sock
  13. basedir                       = /opt/percona-server
  14. datadir                       = /srv/myPORT/data
  15. log-error                     = /srv/myPORT/log/alert.log
  16. pid-file                      = /srv/myPORT/run/mysql.pid
  17. log_slave_updates             = 1
  18. log-bin                       = /srv/myPORT/log/mysql-bin
  19. binlog_format                 = row
  20. binlog_cache_size             = 2M
  21. max_binlog_cache_size         = 4G
  22. max_binlog_size               = 1G
  23. expire_logs_days              = 7
  24. relay-log                     = /srv/myPORT/log/relay-bin
  25. relay-log-info-file           = /srv/myPORT/log/relay-log.info
  26. relay-log-index               = /srv/myPORT/log/relay-log.index
  27. master-info-file              = /srv/myPORT/log/master.info
  28. relay-log-recovery            = true
  29. sync-relay-log-info           = 1
  30. explicit_defaults_for_timestamp
  31. key_buffer_size               = 2M
  32. sort_buffer_size              = 2M
  33. read_buffer_size              = 2M
  34. read_rnd_buffer_size          = 16M
  35. join_buffer_size              = 2M
  36. thread_cache_size             = 1024
  37. query_cache_size              = 1M
  38. query_cache_limit             = 1M
  39. query_cache_min_res_unit      = 2k
  40. table_open_cache              = 2048
  41. open_files_limit              = 65535
  42. back_log                      = 3000
  43. max_connections               = 4000
  44. max_user_connections          = 2500
  45. max_connect_errors            = 100
  46. max_allowed_packet            = 512M
  47. thread_stack                  = 192k
  48. default-storage-engine        = INNODB
  49. transaction_isolation         = READ-COMMITTED
  50. tmp_table_size                = 16M
  51. max_heap_table_size           = 64M
  52. bulk_insert_buffer_size       = 64M
  53. long_query_time               = 0.5
  54. slow_query_log                = on
  55. slow_query_log_file           = /srv/myPORT/log/slow.log
  56. skip-name-resolve
  57. innodb_buffer_pool_size       = 10G
  58. innodb_data_file_path         = ibdata1:2G:autoextend
  59. innodb_file_io_threads        = 24
  60. innodb_purge_threads          = 12
  61. innodb_read_io_threads        = 24
  62. innodb_write_io_threads       = 24
  63. innodb_thread_concurrency     = 24
  64. innodb_buffer_pool_instances  = 8
  65. innodb_flush_log_at_trx_commit= 1
  66. innodb_log_buffer_size        = 16M
  67. innodb_log_file_size          = 2G
  68. innodb_log_files_in_group     = 2
  69. innodb_max_dirty_pages_pct    = 75
  70. innodb_lock_wait_timeout      = 50
  71. innodb_file_per_table         = 1
  72. thread_handling               = pool-of-threads
  73. thread_pool_idle_timeout      = 180
  74. thread_pool_max_threads       = 5000
  75. thread_pool_size              = 24
  76. thread_pool_oversubscribe     = 10
  77. thread_pool_stall_limit       = 500
  78. [mysqldump]
  79. quick
  80. max_allow_packet              = 64M
  81. [mysql]
  82. no-auto-rehash
  83. [mysqlhotcopy]
  84. interactive-timeout


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28686045/viewspace-2126254/，如需轉載，請註明出處，否則將追究法律責任。

相關文章