设为首页收藏本站
开启辅助访问

ZMX - IT技术交流论坛 - 无限Perfect，追求梦想 - itzmx.com

 找回密码
 注册论坛

QQ登录

只需一步，快速开始

新浪微博账号登陆

只需一步，快速开始

用百度帐号登录

只需两步，快速登录

搜索
ZMX - IT技术交流论坛 - 无限Perfect，追求梦想 - itzmx.com»论坛 › 资源分享 › 各类教程 › upupw的mysql主机配置文件优化my.ini
返回列表 发新帖
查看: 3492|回复: 0

upupw的mysql主机配置文件优化my.ini

[复制链接]
小樱
 成长值: 255

签到天数: 4710 天

[LV.Master]伴坛终老
发表于 2017/3/2 17:56 | 显示全部楼层 |阅读模式 |Google Chrome 56.0.2924.87|Windows 8.1
天涯海角搜一下： 百度 谷歌 360 搜狗 有道 雅虎 必应 即刻
1.jpg
0级别
  1. [client]
  2. port=3306

  4. [mysql]
  5. default-character-set=utf8

  7. [mysqld]
  8. port=3306
  9. server_id=1
  10. character-set-server=utf8
  11. default-storage-engine=MYISAM
  12. sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  13. slow_query_log=0
  14. long_query_time=2
  15. local-infile=0
  16. skip-external-locking
  17. #skip-innodb
  18. #log-bin=mysql-bin
  19. #binlog_format=mixed

  21. max_connections=500
  22. key_buffer_size=32M
  23. sort_buffer_size=128kb
  24. read_buffer_size=256kb
  25. join_buffer_size=1M
  26. read_rnd_buffer_size=1M
  27. max_allowed_packet=16M
  28. table_open_cache=128
  29. tmp_table_size=32M
  30. max_heap_table_size=32M
  31. thread_cache_size=16

  33. myisam_max_sort_file_size=64G
  34. myisam_sort_buffer_size=8M

  36. innodb_buffer_pool_size=32M
  37. innodb_log_file_size=8M
  38. innodb_log_buffer_size=1M
  39. innodb_file_per_table=1
  40. innodb_flush_log_at_trx_commit=1
  41. innodb_thread_concurrency=0
  42. innodb_lock_wait_timeout=50

  44. [mysqldump]
  45. quick
  46. max_allowed_packet=16M

  48. [mysql]
  49. no-auto-rehash

  51. [myisamchk]
  52. key_buffer_size=10M
  53. sort_buffer_size=10M
  54. read_buffer=1M
  55. write_buffer=1M

  57. [mysqlhotcopy]
  58. interactive-timeout

  60. [mysqld_safe]
  61. open-files-limit=8192
复制代码



1级别
  1. [client]
  2. port=3306

  4. [mysql]
  5. default-character-set=utf8

  7. [mysqld]
  8. port=3306
  9. server_id=1
  10. character-set-server=utf8
  11. default-storage-engine=MYISAM
  12. sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  13. slow_query_log=0
  14. long_query_time=2
  15. local-infile=0
  16. skip-external-locking
  17. #skip-innodb
  18. #log-bin=mysql-bin
  19. #binlog_format=mixed

  21. max_connections=1000
  22. key_buffer_size=64M
  23. sort_buffer_size=256kb
  24. read_buffer_size=512kb
  25. join_buffer_size=2M
  26. read_rnd_buffer_size=2M
  27. max_allowed_packet=16M
  28. table_open_cache=256
  29. tmp_table_size=64M
  30. max_heap_table_size=64M
  31. thread_cache_size=16

  33. myisam_max_sort_file_size=64G
  34. myisam_sort_buffer_size=32M

  36. innodb_buffer_pool_size=64M
  37. innodb_log_file_size=16M
  38. innodb_log_buffer_size=2M
  39. innodb_file_per_table=1
  40. innodb_flush_log_at_trx_commit=1
  41. innodb_thread_concurrency=0
  42. innodb_lock_wait_timeout=50

  44. [mysqldump]
  45. quick
  46. max_allowed_packet=16M

  48. [mysql]
  49. no-auto-rehash

  51. [myisamchk]
  52. key_buffer_size=20M
  53. sort_buffer_size=20M
  54. read_buffer=2M
  55. write_buffer=2M

  57. [mysqlhotcopy]
  58. interactive-timeout

  60. [mysqld_safe]
  61. open-files-limit=8192
复制代码


2级别
  1. [client]
  2. port=3306

  4. [mysql]
  5. default-character-set=utf8

  7. [mysqld]
  8. port=3306
  9. server_id=1
  10. character-set-server=utf8
  11. default-storage-engine=INNODB
  12. sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  13. slow_query_log=0
  14. long_query_time=2
  15. local-infile=0
  16. skip-external-locking
  17. #log-bin=mysql-bin
  18. #binlog_format=mixed

  20. max_connections=2000
  21. key_buffer_size=256M
  22. sort_buffer_size=1M
  23. read_buffer_size=2M
  24. join_buffer_size=4M
  25. read_rnd_buffer_size=4M
  26. max_allowed_packet=32M
  27. table_open_cache=512
  28. tmp_table_size=128M
  29. max_heap_table_size=128M
  30. thread_cache_size=16

  32. myisam_max_sort_file_size=64G
  33. myisam_sort_buffer_size=64M

  35. innodb_buffer_pool_size=256M
  36. innodb_log_file_size=64M
  37. innodb_log_buffer_size=8M
  38. innodb_file_per_table=1
  39. innodb_flush_log_at_trx_commit=1
  40. innodb_thread_concurrency=0
  41. innodb_lock_wait_timeout=50

  43. [mysqldump]
  44. quick
  45. max_allowed_packet=16M

  47. [mysql]
  48. no-auto-rehash

  50. [myisamchk]
  51. key_buffer_size=40M
  52. sort_buffer_size=40M
  53. read_buffer=4M
  54. write_buffer=4M

  56. [mysqlhotcopy]
  57. interactive-timeout

  59. [mysqld_safe]
  60. open-files-limit=8192
复制代码


3级别
  1. [client]
  2. port=3306

  4. [mysql]
  5. default-character-set=utf8

  7. [mysqld]
  8. port=3306
  9. server_id=1
  10. character-set-server=utf8
  11. default-storage-engine=INNODB
  12. sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  13. slow_query_log=0
  14. long_query_time=2
  15. local-infile=0
  16. skip-external-locking
  17. #log-bin=mysql-bin
  18. #binlog_format=mixed

  20. max_connections=3000
  21. key_buffer_size=512M
  22. sort_buffer_size=1M
  23. read_buffer_size=4M
  24. join_buffer_size=8M
  25. read_rnd_buffer_size=8M
  26. max_allowed_packet=64M
  27. table_open_cache=1024
  28. tmp_table_size=256M
  29. max_heap_table_size=256M
  30. thread_cache_size=16

  32. myisam_max_sort_file_size=64G
  33. myisam_sort_buffer_size=128M

  35. innodb_buffer_pool_size=512M
  36. innodb_log_file_size=128M
  37. innodb_log_buffer_size=16M
  38. innodb_file_per_table=1
  39. innodb_flush_log_at_trx_commit=1
  40. innodb_thread_concurrency=0
  41. innodb_lock_wait_timeout=50

  43. [mysqldump]
  44. quick
  45. max_allowed_packet=16M

  47. [mysql]
  48. no-auto-rehash

  50. [myisamchk]
  51. key_buffer_size=80M
  52. sort_buffer_size=80M
  53. read_buffer=8M
  54. write_buffer=8M

  56. [mysqlhotcopy]
  57. interactive-timeout

  59. [mysqld_safe]
  60. open-files-limit=8192
复制代码



一般来说table_open_cache 是最终影响CPU性能的，可以适当调大，比如说2048，值越大时内存使用量越高

配置文件, mysql, 主机

相关帖子

欢迎光临IT技术交流论坛：http://bbs.itzmx.com/
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册论坛 新浪微博账号登陆用百度帐号登录

本版积分规则

手机版|Archiver|Mail me|网站地图|IT技术交流论坛 ( 闽ICP备13013206号-7 )

GMT+8, 2024/11/26 16:30 , Processed in 0.169618 second(s), 25 queries , MemCache On.

Powered by itzmx! X3.4

© 2011- sakura

快速回复 返回顶部 返回列表