Guest User

Untitled

a guest
Mar 28th, 2015
377
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [client]
  2. port = 3306
  3. socket = /var/run/mysqld/mysqld.sock
  4. default-character-set = utf8
  5.  
  6. [mysqld_safe]
  7. socket = /var/run/mysqld/mysqld.sock
  8. nice = 0
  9. malloc-lib = /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
  10.  
  11. [mysqld]
  12. user = mysql
  13. pid-file = /var/run/mysqld/mysqld.pid
  14. socket = /var/run/mysqld/mysqld.sock
  15. port = 3306
  16. basedir = /usr
  17. datadir = /var/lib/mysql
  18. tmpdir = /var/mysql_tmpfs
  19. open_files_limit = 16384
  20.  
  21. # Other
  22. default-storage-engine = INNODB
  23. character-set-server = utf8
  24. #explicit_defaults_for_timestamp = TRUE
  25. max_connections = 200
  26. wait_timeout = 7200
  27. max_allowed_packet = 16M
  28. low_priority_updates = 1
  29. concurrent_insert = 2
  30. #expand_fast_index_creation = On
  31. #bind-address = 127.0.0.1
  32. skip-external-locking
  33.  
  34. # MyISAM settings
  35. key_buffer_size = 128M
  36. myisam_sort_buffer_size = 512M
  37. myisam_repair_threads = 1
  38.  
  39. # InnoDB settings
  40. innodb_data_file_path = ibdata1:32M:autoextend:max:32G
  41. innodb_file_per_table = 1
  42. innodb_buffer_pool_size = 4G
  43. innodb_buffer_pool_instances = 4
  44. innodb_additional_mem_pool_size = 2G
  45. innodb_log_file_size = 256M
  46. innodb_flush_log_at_trx_commit = 2
  47. innodb_log_buffer_size = 8M
  48. innodb_log_files_in_group = 2
  49. innodb_flush_method = O_DIRECT
  50. innodb_thread_concurrency = 8
  51.  
  52. # Buffer settings
  53. join_buffer_size = 2M
  54. sort_buffer_size = 2M
  55. read_buffer_size = 128K
  56. read_rnd_buffer_size = 256K
  57. bulk_insert_buffer_size = 16M
  58.  
  59. # TMP & memory settings
  60. tmp_table_size = 64M
  61. max_heap_table_size = 64M
  62.  
  63. # Cache settings
  64. query_cache_type = 1
  65. thread_cache_size = 128
  66. query_cache_limit = 1M
  67. query_cache_size = 128M
  68. table_open_cache = 2048
  69. table_definition_cache = 2048
  70. #table_open_cache_instances = 2
  71. query_cache_strip_comments = On
  72.  
  73. # Slowlog settings
  74. slow_query_log = 1
  75. long_query_time = 2
  76. slow_query_log_file = /var/log/mysql/mysql-slow.log
  77. #log_slow_verbosity = microtime,query_plan,innodb
  78. log-error=/var/log/mysql-errors.log
  79.  
  80. [mysqldump]
  81. # Do not buffer the whole result set in memory before writing it to
  82. # file. Required for dumping very large tables
  83. quick
  84.  
  85. max_allowed_packet = 32M
  86. default-character-set = utf8
  87.  
  88. [mysql]
  89. no-auto-rehash
  90. default-character-set = utf8
  91.  
  92. [isamchk]
  93. key_buffer_size = 8M
  94. sort_buffer_size = 8M
  95. read_buffer = 8M
  96. write_buffer =
RAW Paste Data