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

my.cnf

By: Juc1 on Jun 28th, 2013  |  syntax: None  |  size: 3.13 KB  |  views: 41  |  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. $ cat /etc/mysql/my.cnf
  2. [client]
  3. port                    = 3306
  4. socket                  = /var/run/mysqld/mysqld.sock
  5. default-character-set   = utf8
  6.  
  7. [mysqld]
  8. user                    = mysql
  9. pid-file                = /var/run/mysqld/mysqld.pid
  10. socket                  = /var/run/mysqld/mysqld.sock
  11. port                    = 3306
  12. basedir                 = /usr
  13. datadir                 = /var/lib/mysql
  14. tmpdir                  = /tmp
  15. default_storage_engine  = InnoDB
  16. lc_messages_dir         = /usr/share/mysql
  17. lc_messages             = en_US
  18. character_set_server    = utf8
  19. collation_server        = utf8_general_ci
  20. skip-external-locking
  21. skip-name-resolve
  22. connect_timeout         = 120
  23. join_buffer_size        = 1M
  24. key_buffer              = 2M
  25. key_buffer_size         = 61M
  26. log_warnings            = 2
  27. max_allowed_packet      = 32M
  28. max_connect_errors      = 30
  29. max_connections         = 30
  30. max_user_connections    = 30
  31. myisam_sort_buffer_size = 1024K
  32. query_cache_limit       = 128K
  33. query_cache_size        = 64M
  34. query_cache_type        = 1
  35. read_buffer_size        = 8M
  36. read_rnd_buffer_size    = 4M
  37. sort_buffer_size        = 128K
  38. bulk_insert_buffer_size = 128K
  39. table_open_cache        = 64
  40. table_definition_cache  = 512
  41. table_cache             = 128
  42. thread_stack            = 256K
  43. thread_cache_size       = 128
  44. thread_concurrency      = 8
  45. wait_timeout            = 3600
  46. tmp_table_size          = 64M
  47. max_heap_table_size     = 128M
  48. low_priority_updates    = 1
  49. concurrent_insert       = 2
  50. max_tmp_tables          = 16384
  51. server-id               = 8
  52. myisam-recover          = BACKUP
  53. #log_bin                 = /var/log/mysql/mariadb-bin
  54. #log_bin_index           = /var/log/mysql/mariadb-bin.index
  55. #expire_logs_days        = 1
  56. #max_binlog_size         = 100M
  57. open_files_limit        = 196608
  58. #slow_query_log          = 1
  59. #long_query_time         = 10
  60. #slow_query_log_file     = /var/log/mysql/sql-slow-query.log
  61. #log_queries_not_using_indexes
  62.  
  63.  
  64. # * InnoDB
  65. #
  66. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  67. # Read the manual for more InnoDB related options. There are many!
  68. sql_mode                = NO_ENGINE_SUBSTITUTION
  69. # you can't just change log file size, requires special procedure
  70. #innodb_log_file_size   = 50M
  71. innodb_buffer_pool_size = 61M
  72. innodb_log_buffer_size  = 4M
  73. innodb_file_per_table   = 1
  74. innodb_open_files       = 256
  75. innodb_io_capacity      = 512
  76. innodb_flush_method     = O_DIRECT
  77. innodb_flush_log_at_trx_commit = 2
  78. innodb_thread_concurrency = 8
  79. #innodb_lazy_drop_table  = 1
  80. innodb_lock_wait_timeout = 120
  81.  
  82.  
  83. [mysqld_safe]
  84. socket                  = /var/run/mysqld/mysqld.sock
  85. nice                    = 0
  86. open_files_limit        = 196608
  87. syslog
  88.  
  89. [mysqldump]
  90. quick
  91. max_allowed_packet      = 32M
  92. quote-names
  93.  
  94. [mysql]
  95. no-auto-rehash
  96.  
  97. [myisamchk]
  98. key_buffer              = 1M
  99. sort_buffer_size        = 64K
  100. read_buffer             = 4M
  101. write_buffer            = 4M
  102.  
  103. [isamchk]
  104. key_buffer              = 1M
  105. sort_buffer_size        = 64K
  106. read_buffer             = 4M
  107. write_buffer            = 4M
  108.  
  109. [mysqlhotcopy]
  110. interactive-timeout
  111.  
  112. !includedir /etc/mysql/conf.d/
  113. $
clone this paste RAW Paste Data