Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2013
344
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. [client]
  2. #password = your_password
  3. port = 3306
  4. socket = /tmp/mysql.sock
  5.  
  6. # The MySQL server
  7. [mysqld]
  8. port = 3306
  9. socket = /tmp/mysql.sock
  10. skip-external-locking
  11. key_buffer_size = 256M
  12. max_allowed_packet = 512M
  13. table_open_cache = 256
  14. sort_buffer_size = 1M
  15. read_buffer_size = 1M
  16. read_rnd_buffer_size = 4M
  17. myisam_sort_buffer_size = 64M
  18. thread_cache_size = 8
  19. query_cache_size= 16M
  20.  
  21. # Try number of CPU's*2 for thread_concurrency
  22. thread_concurrency = 2
  23.  
  24. #####Purge bin logs###########
  25. expire_logs_days = 5
  26. max_binlog_size = 100M
  27.  
  28. # Replication Master Server (default)
  29. # binary logging is required for replication
  30. log-bin=mysql-bin
  31.  
  32. # binary logging format - mixed recommended
  33. binlog_format=mixed
  34.  
  35. # required unique id between 1 and 2^32 - 1
  36. # defaults to 1 if master-host is not set
  37. # but will not function as a master if omitted
  38. server-id = 1
  39.  
  40. # Uncomment the following if you are using InnoDB tables
  41. #innodb_data_home_dir = /var/db/mysql
  42. #innodb_data_file_path = ibdata1:10M:autoextend
  43. #innodb_log_group_home_dir = /var/db/mysql
  44. # You can set .._buffer_pool_size up to 50 - 80 %
  45. # of RAM but beware of setting memory usage too high
  46. #innodb_buffer_pool_size = 256M
  47. #innodb_additional_mem_pool_size = 20M
  48. # Set .._log_file_size to 25 % of buffer pool size
  49. #innodb_log_file_size = 64M
  50. #innodb_log_buffer_size = 8M
  51. #innodb_flush_log_at_trx_commit = 1
  52. #innodb_lock_wait_timeout = 50
  53.  
  54. [mysqldump]
  55. quick
  56. max_allowed_packet = 256M
  57.  
  58. [mysql]
  59. no-auto-rehash
  60. # Remove the next comment character if you are not familiar with SQL
  61. #safe-updates
  62.  
  63. [myisamchk]
  64. key_buffer_size = 128M
  65. sort_buffer_size = 128M
  66. read_buffer = 2M
  67. write_buffer = 2M
  68.  
  69. [mysqlhotcopy]
  70. interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement