Guest User

my.cnf

a guest
Dec 16th, 2011
372
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.38 KB | None | 0 0
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. user=mysql
  5. # Disabling symbolic-links is recommended to prevent assorted security risks
  6. symbolic-links=0
  7.  
  8. # LBU TUNE
  9.  
  10. query_cache_limit=2M
  11. query_cache_size=48M
  12. query_cache_type=1
  13. max_connections=1800
  14. interactive_timeout=600
  15. wait_timeout=600
  16. connect_timeout=20
  17. thread_cache_size=128
  18. key_buffer=256M
  19. join_buffer=2M
  20. max_allowed_packet=16M
  21. table_cache=2048
  22. sort_buffer_size=4M
  23. read_buffer_size=4M
  24. max_connect_errors=30
  25. # Try number of CPU's*2 for thread_concurrency
  26. thread_concurrency=4
  27. myisam_sort_buffer_size=64M
  28. server-id=1
  29. slow_query_log=/var/log/mysqld.slow.log
  30. long_query_time=2
  31. innodb_buffer_pool_size = 1024M
  32. innodb_log_file_size = 250M
  33. #innodb_flush_log_at_trx_commit = 0
  34. innodb_flush_log_at_trx_commit = 0
  35. innodb_flush_method=O_DIRECT
  36.  
  37. expire_logs_days = 3
  38. max_binlog_size = 512M
  39. innodb_file_per_table = 1
  40. innodb_file_per_table
  41. innodb_data_home_dir =
  42. innodb_data_file_path=/mysql/mysql/ibdata1:250M;/mysql/mysql/ibdata2:250M:autoextend
  43. datadir=/mysql/mysql/
  44.  
  45. [mysqld_safe]
  46. log-error=/var/log/mysqld.log
  47. pid-file=/var/run/mysqld/mysqld.pid
  48.  
  49.  
  50. [mysqldump]
  51. quick
  52. max_allowed_packet=32M
  53.  
  54.  
  55. [isamchk]
  56. key_buffer=64M
  57. sort_buffer=64M
  58. read_buffer=16M
  59. write_buffer=16M
  60.  
  61. [myisamchk]
  62. key_buffer=64M
  63. sort_buffer=64M
  64. read_buffer=16M
  65. write_buffer=16M
  66.  
  67. [mysqlhotcopy]
  68. interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment