Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
230
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.  
  5. [mysqld_safe]
  6. pid-file = /var/run/mysqld/mysqld.pid
  7. socket = /var/run/mysqld/mysqld.sock
  8. nice = 0
  9.  
  10. [mysqld]
  11. user = mysql
  12. pid-file = /var/run/mysqld/mysqld.pid
  13. socket = /var/run/mysqld/mysqld.sock
  14. port = 3306
  15. basedir = /usr
  16. datadir = /var/lib/mysql
  17. tmpdir = /run/shm
  18. lc-messages-dir = /usr/share/mysql
  19. explicit_defaults_for_timestamp
  20. slow_query_log = 0
  21. slow_query_log_file = /var/log/mysql/slow.log
  22. long_query_time = 10
  23. log_queries_not_using_indexes = 1
  24.  
  25.  
  26. #Mysql Master/Slave config
  27. server-id = 1
  28. binlog-format = mixed
  29. log-bin = mysql-bin
  30. innodb_flush_log_at_trx_commit = 1
  31. sync_binlog = 1
  32. expire_logs_days = 5
  33. #Slave on
  34. read-only = 1
  35.  
  36. #Custom
  37. max_connections = 3072
  38. max_user_connections = 3072
  39. key_buffer_size = 1024M
  40. thread_cache_size = 96
  41. query_cache_type = 0
  42. query_cache_limit = 2M
  43. query_cache_size = 192M
  44. tmp_table_size = 192M
  45. max_heap_table_size = 192M
  46. sort_buffer_size = 4M
  47. read_rnd_buffer_size = 2M
  48. read_buffer_size = 2M
  49. join_buffer_size = 32M
  50. innodb_buffer_pool_size = 24576M
  51. innodb_flush_method = O_DIRECT
  52. net_buffer_length = 256K
  53. thread_stack = 256K
  54. delayed_insert_timeout = 8
  55. connect_timeout = 8
  56. open_files_limit = 20480
  57. thread_concurrency = 12
  58.  
  59.  
  60. wait_timeout = 720
  61. interactive_timeout = 720
  62. innodb_log_buffer_size = 128M
  63. innodb_log_file_size = 256M
  64. innodb_lock_wait_timeout = 120
  65.  
  66. # Instead of skip-networking the default is now to listen only on
  67. # localhost which is more compatible and is not less secure.
  68. #bind-address = 127.0.0.1
  69.  
  70. log-error = /var/log/mysql/error.log
  71.  
  72. # Recommended in standard MySQL setup
  73. #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #configurazione di default di Marco
  74.  
  75. sql_mode=NO_ENGINE_SUBSTITUTION
  76.  
  77. # Disabling symbolic-links is recommended to prevent assorted security risks
  78. symbolic-links=0
Advertisement
RAW Paste Data Copied
Advertisement