Want more features on Pastebin? Sign Up, it's FREE!
Guest

my.cnf

By: a guest on Jun 1st, 2012  |  syntax: Bash  |  size: 1.53 KB  |  views: 973  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. [root@server httpdocs]# cat /etc/my.cnf
  2. [mysqld]
  3. local-infile=0
  4. datadir=/var/lib/mysql
  5. skip-locking
  6. #skip-innodb
  7. #skip-networking
  8. skip-name-resolve
  9. skip-host-cache
  10. safe-show-database
  11. innodb_buffer_pool_size = 512M
  12. #innodb_flush_method= O_DIRECT
  13. innodb_additional_mem_pool_size= 64M
  14. #innodb_log_file_size= 1024M
  15. innodb_thread_concurrency= 8
  16. innodb_flush_log_at_trx_commit= 0
  17. innodb_log_buffer_size= 8M
  18. innodb_file_per_table =1
  19. query_cache_limit=1M
  20. query_cache_size=192M ## 32MB for every 1GB of RAM
  21. query_cache_type=1
  22. max_user_connections=1000
  23. max_connections=1000
  24. interactive_timeout=360
  25. wait_timeout=360
  26. connect_timeout=360
  27. thread_cache_size=128
  28. table_cache=1000
  29. key_buffer=1024M ## 128MB for every 1GB of RAM
  30. join_buffer=1M
  31. max_connect_errors=360
  32. max_allowed_packet=4M
  33. table_cache=1024
  34. record_buffer=4M
  35. sort_buffer_size=4M ## 1MB for every 1GB of RAM
  36. read_buffer_size=4M ## 1MB for every 1GB of RAM
  37. read_rnd_buffer_size=8M  ## 1MB for every 1GB of RAM
  38. thread_concurrency=8 ## Number of CPUs x 2
  39. myisam_sort_buffer_size=64M
  40. server-id=1
  41. collation-server=latin1_general_ci
  42. socket=/var/lib/mysql/mysql.sock
  43. [mysql.server]
  44. user=mysql
  45.  
  46. [safe_mysqld]
  47. err-log=/var/log/mysqld.log
  48. pid-file=/var/lib/mysql/mysql.pid
  49. open_files_limit=8192
  50.  
  51. [mysqldump]
  52. quick
  53. max_allowed_packet=16M
  54.  
  55. [mysql]
  56. no-auto-rehash
  57. #safe-updates
  58.  
  59. [isamchk]
  60. key_buffer=64M
  61. sort_buffer=64M
  62. read_buffer=16M
  63. write_buffer=16M
  64.  
  65. [myisamchk]
  66. key_buffer=64M
  67. sort_buffer=64M
  68. read_buffer=16M
  69. write_buffer=16M
  70.  
  71. [mysqlhotcopy]
  72. interactive-timeout
clone this paste RAW Paste Data