G2A Many GEOs
SHARE
TWEET

my.cnf

Juc1 Jun 28th, 2013 54 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. $
RAW Paste Data
Ledger Nano X - The secure hardware wallet
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top