Guest User

Untitled

a guest
Mar 22nd, 2015
294
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_buffer_pool_size = 1G
  41. innodb_buffer_pool_instances = 3
  42. innodb_log_file_size = 16M
  43. innodb_flush_log_at_trx_commit = 2
  44. innodb_log_buffer_size = 8M
  45. innodb_log_files_in_group = 2
  46. innodb_flush_method = O_DIRECT
  47. innodb_thread_concurrency = 8
  48.  
  49. # Buffer settings
  50. join_buffer_size = 2M
  51. sort_buffer_size = 2M
  52. read_buffer_size = 128K
  53. read_rnd_buffer_size = 256K
  54. bulk_insert_buffer_size = 16M
  55.  
  56. # TMP & memory settings
  57. tmp_table_size = 64M
  58. max_heap_table_size = 64M
  59.  
  60. # Cache settings
  61. query_cache_type = 1
  62. thread_cache_size = 128
  63. query_cache_limit = 128K
  64. query_cache_size = 128M
  65. table_open_cache = 2048
  66. table_definition_cache = 2048
  67. table_open_cache_instances = 2
  68. query_cache_strip_comments = On
  69.  
  70. # Slowlog settings
  71. slow_query_log = 1
  72. long_query_time = 10
  73. slow_query_log_file = /var/log/mysql/mysql-slow.log
  74. log_slow_verbosity = microtime,query_plan,innodb
  75.  
  76. [mysqldump]
  77. # Do not buffer the whole result set in memory before writing it to
  78. # file. Required for dumping very large tables
  79. quick
  80.  
  81. max_allowed_packet = 32M
  82. default-character-set = utf8
  83.  
  84. [mysql]
  85. no-auto-rehash
  86. default-character-set = utf8
  87.  
  88. [isamchk]
  89. key_buffer_size = 8M
  90. sort_buffer_size = 8M
  91. read_buffer = 8M
  92. write_buffer = 8M
  93. default-character-set = utf8
RAW Paste Data