SHARE
TWEET

my.cnf

a guest Jun 1st, 2012 1,930 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top