Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

webcrawler my.cnf

By: a guest on Jan 10th, 2013  |  syntax: Bash  |  size: 3.28 KB  |  views: 28  |  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. [client]
  2. port            = 3306
  3. socket          = /var/run/mysqld/mysqld.sock
  4.  
  5.  
  6. [mysqld_safe]
  7. socket          = /var/run/mysqld/mysqld.sock
  8. nice            = 0
  9.  
  10. [mysqld]
  11. #
  12. # * Basic Settings
  13. #
  14. user            = mysql
  15. pid-file        = /var/run/mysqld/mysqld.pid
  16. socket          = /var/run/mysqld/mysqld.sock
  17. port            = 3306
  18. basedir         = /usr
  19. datadir         = /var/lib/mysql
  20. tmpdir          = /tmp
  21. lc-messages-dir = /usr/share/mysql
  22. skip-external-locking
  23. bind-address            = 0.0.0.0
  24. #
  25. # * Fine Tuning
  26. #
  27. key_buffer              = 2G
  28.  
  29. thread_stack = 400K
  30. thread_cache_size       = 8
  31. # This replaces the startup script and checks MyISAM tables if needed
  32. # the first time they are touched
  33. myisam-recover         = BACKUP
  34. #max_connections        = 100
  35. #table_cache            = 64
  36. #thread_concurrency     = 10
  37. #
  38. # * Query Cache Configuration
  39. #
  40. query_cache_limit = 200M
  41. query_cache_size        = 500M
  42. #
  43. # * Logging and Replication
  44. #
  45. # Both location gets rotated by the cronjob.
  46. # Be aware that this log type is a performance killer.
  47. # As of 5.1 you can enable the log at runtime!
  48. #general_log_file        = /var/log/mysql/mysql.log
  49. #general_log             = 1
  50. #
  51. # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
  52. #
  53. # Here you can see queries with especially long duration
  54. #log_slow_queries       = /var/log/mysql/mysql-slow.log
  55. #long_query_time = 2
  56. #log-queries-not-using-indexes
  57. #
  58. # The following can be used as easy to replay backup logs or for replication.
  59. # note: if you are setting up a replication slave, see README.Debian about
  60. #       other settings you may need to change.
  61. #server-id              = 1
  62. #log_bin                        = /var/log/mysql/mysql-bin.log
  63. expire_logs_days        = 10
  64. max_binlog_size         = 100M
  65. #binlog_do_db           = include_database_name
  66. #binlog_ignore_db       = include_database_name
  67. #
  68. # * InnoDB
  69. #
  70. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  71. # Read the manual for more InnoDB related options. There are many!
  72. #
  73. # * Security Features
  74. #
  75. # Read the manual, too, if you want chroot!
  76. # chroot = /var/lib/mysql/
  77. #
  78. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  79. #
  80. # ssl-ca=/etc/mysql/cacert.pem
  81. # ssl-cert=/etc/mysql/server-cert.pem
  82. # ssl-key=/etc/mysql/server-key.pem
  83.  
  84. max_delayed_threads = 100
  85. delayed_queue_size = 10000
  86. sort_buffer_size = 1G
  87. delayed_insert_timeout = 600
  88. thread_handling = one-thread-per-connection
  89. max_connect_errors = 1000
  90. connect_timeout = 10
  91. max_connections = 1000
  92. delayed_insert_limit = 200
  93. max_allowed_packet = 100M
  94. thread_concurrency = 40
  95. net_buffer_length = 16384
  96. myisam_sort_buffer_size = 4G
  97. key_buffer_size = 2G
  98. innodb_flush_log_at_trx_commit = 0
  99. innodb_io_capacity = 2000
  100. innodb_purge_threads = 1
  101. innodb_log_buffer_size = 5M
  102. innodb_additional_mem_pool_size = 10M
  103. innodb_lock_wait_timeout = 200
  104. innodb_buffer_pool_size = 1G
  105. innodb_change_buffering = inserts
  106. skip-name-resolve
  107. max_heap_table_size = 4G
  108. tmp_table_size = 1G
  109. max_join_size = 42949672950
  110. join_buffer_size = 1M
  111. myisam_max_sort_file_size = 400G
  112.  
  113. [mysqldump]
  114. quick
  115. quote-names
  116. max_allowed_packet      = 160M
  117.  
  118. [mysql]
  119. #no-auto-rehash # faster start of mysql but no tab completition
  120.  
  121. [isamchk]
  122. key_buffer              = 160M
  123.  
  124. #
  125. # * IMPORTANT: Additional settings that can override those from this file!
  126. #   The files must end with '.cnf', otherwise they'll be ignored.
  127. #
  128. !includedir /etc/mysql/conf.d/