Chinaunix首页 | 论坛 | 博客

Linux/MYSQL/PHP SakuraGaaramic0601.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

mic0601

  • 博客访问： 815556
  • 博文数量： 127
  • 博客积分： 3662
  • 博客等级： 中校
  • 技术积分： 1371
  • 用 户 组： 普通用户
  • 注册时间： 2010-08-02 12:36
个人简介

Linux&MySQL&PHP&Nginx&Apache&MSSQL&Shell

文章分类

全部博文（127）

文章存档

2016年（1）

2015年（8）

2014年（14）

2013年（26）

2012年（17）

2011年（28）

2010年（33）

我的朋友
最近访客
推荐博文
相关博文
MYSQL之三(32G 配置文件MY.CNF)

分类： Mysql/postgreSQL

2015-08-25 14:18:36


点击(此处)折叠或打开

  1. ------------------------------------------ 主库 DB01 MY.CNF -----------------------------------------------------------

  3. [mysqld]
  4. datadir=/data/mysql
  5. socket=/data/mysql/mysql.sock
  6. user=mysql

  8. #old_passwords=1

  10. # default
  11. character-set-server=utf8
  12. default-storage-engine=INNODB

  14. skip-slave-start
  15. skip-name-resolve

  17. # buffer cache
  18. max_connections = 10000
  19. key_buffer_size = 256M
  20. myisam_sort_buffer_size = 64M
  21. join_buffer_size = 8M
  22. read_buffer_size = 4M
  23. sort_buffer_size = 8M
  24. table_cache = 2048
  25. interactive_timeout = 1000
  26. innodb_buffer_pool_size = 8G

  28. tmp_table_size = 256M

  30. # max
  31. max_allowed_packet = 60M
  32. max_connect_errors = 10
  33. max_heap_table_size = 256M

  35. # query
  36. query_cache_limit = 1M
  37. query_cache_size = 64M
  38. query_cache_type = 1

  40. # thread
  41. #thread_cache = 24
  42. thread_cache_size = 196
  43. thread_concurrency = 16
  44. group_concat_max_len = 10240
  45. back_log = 50
  46. wait_timeout = 600

  48. # log
  49. slow-query-log=ON
  50. slow-query-log-file=/var/log/slow-queries.log
  51. long_query_time=5
  52. log-slow-admin-statements
  53. log-queries-not-using-indexes
  54. #log_queries_not_using_indexes
  55. #log-slow-admin-statements

  57. #log=/var/log/queries_log.log
  58. log-error=/var/log/mysqld.log
  59. #log-queries-not-using-indexes=1
  60. #long_query_time = 5

  62. ft_min_word_len = 2

  64. expire_logs_days = 5

  66. log-bin=mysql-bin
  67. log_bin = /data/mysql/mysql-bin.log
  68. log_bin_index = /data/mysql/mysql-bin.log.index
  69. log-bin-trust-function-creators=1

  71. max_binlog_size=1024M
  72. #binlog_format=mixed
  73. server-id = 1
  74. #binlog-ignore-db=forums_games_la

  76. #innodb_log_file_size = 256M
  77. #innodb_log_buffer_size = 4M
  78. #innodb_flush_method = O_DIRECT
  79. #innodb_flush_log_at_trx_commit = 1

  81. [client]
  82. default-character-set=utf8

  84. [mysqld_safe]
  85. open_files_limit = 8192
  86. log-error=/var/log/mysqld.log
  87. #pid-file=/var/run/mysqld/mysqld.pid


点击(此处)折叠或打开

  1. ------------------------------------------ 从库 DB02 MY.CNF -----------------------------------------------------------

  3. [mysqld]
  4. datadir=/data/mysql
  5. socket=/data/mysql/mysql.sock
  6. user=mysql

  8. #old_passwords=1

  10. # default
  11. character-set-server=utf8
  12. default-storage-engine=INNODB

  14. skip-name-resolve
  15. skip-slave-start
  16. #slave-skip-errors=all
  17. #slave-skip-errors=1062
  18. #slave-skip-errors=1062 126 144
  19. #slave-skip-errors=126

  21. # buffer cache
  22. max_connections = 10000
  23. key_buffer = 256M
  24. myisam_sort_buffer_size = 64M
  25. join_buffer_size = 8M
  26. read_buffer_size = 4M
  27. sort_buffer_size = 8M
  28. table_cache = 2048
  29. interactive_timeout = 1000
  30. innodb_buffer_pool_size = 8G

  32. # myisam
  33. myisam_sort_buffer_size = 128M
  34. myisam_max_sort_file_size = 30G
  35. myisam_repair_threads = 1
  36. myisam_recover

  38. tmp_table_size = 256M

  40. # max
  41. max_allowed_packet = 100M
  42. max_connect_errors = 10
  43. max_heap_table_size = 256M

  45. # query
  46. query_cache_limit = 1M
  47. query_cache_size = 64M
  48. query_cache_type = 1

  50. # thread
  51. thread_cache = 24
  52. thread_cache_size = 196
  53. thread_concurrency = 16

  55. back_log = 50
  56. wait_timeout = 600

  58. # log
  59. log_error=/var/log/mysqld.log

  61. slow-query-log=ON
  62. slow-query-log-file=/var/log/slow-queries.log
  63. long_query_time=5
  64. log-slow-admin-statements
  65. log-queries-not-using-indexes


  68. ft_min_word_len = 2

  70. expire_logs_days = 5

  72. log-bin=mysql-bin
  73. log_bin = /data/mysql/mysql-bin.log
  74. log_bin_index = /data/mysql/mysql-bin.log.index
  75. log-bin-trust-function-creators=1
  76. max_binlog_size=1024M
  77. server-id = 3838
  78. relay-log=/data/mysql/replicate
  79. relay-log-index=/data/mysql/replicate.index
  80. read-only=1
  81. #master-host = 10.68.38.42
  82. #master-user = slave
  83. #master-pass = wo2s8w2sWSk
  84. #master-port = 3306
  85. #master-connect-retry=60
  86. replicate-ignore-db=mysql
  87. log-slave-updates

  89. [client]
  90. default-character-set=utf8
  91. [mysqld_safe]
  92. open_files_limit = 8192
  93. log-error=/var/log/mysqld.log
  94. pid-file=/var/run/mysqld/mysqld.pid


阅读(833) | 评论(0) | 转发(0) |
0

上一篇：Nginx 实例站配置

下一篇：mysql高可用探究(二)Lvs+Keepalived+Mysql单点写入主主同步高可用方案

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6