## 64G ## 20 core / E5-2690 v4 @ 2.60GHz # [client] port = 3310 socket = /engn001/masvc01/mysql/mysqld.sock default-character-set = utf8 [mysqld_safe] socket = /engn001/masvc01/mysql/mysqld.sock nice = 0 #core-file-size = 20000000 [mariadb] plugin-load-add = ha_connect.so [mysqld] #core-file plugin-load = server_audit pid-file = /engn001/masvc01/mysql/mysqld.pid socket = /engn001/masvc01/mysql/mysqld.sock port = 3310 basedir = /engn001/masvc01/mysql datadir = /data001/masvc01 tmpdir = /logs001/masvc01/data autocommit = 0 init_connect = SET collation_connection = utf8_bin init_connect = SET NAMES utf8 character_set_server = utf8 collation-server = 'utf8_bin' sync_binlog = 1 # 20160728 rpl_semi_sync_master_enabled = 1 # 20160728 rpl_semi_sync_slave_enabled = 1 # 20160728 # # * Common # skip-name-resolve max-allowed-packet = 1024M #20160709_modify #max-allowed-packet = 512M #20160829_modify open-files-limit = 65535 max-connect-errors = 100000 max-connections = 500 thread-cache-size = 2000 back-log = 1024 max-heap-table-size = 1G #20160709_modify sql-mode = STRICT_TRANS_TABLES,PIPES_AS_CONCAT lower_case_table_names = 1 log_bin_trust_function_creators = 1 table-definition-cache = 10240 table-open-cache = 10240 transaction-isolation = READ-COMMITTED performance_schema event_scheduler = 1 #read_rnd_buffer_size = 48M read_rnd_buffer_size = 12M #20160709_modify #sort_buffer_size = 48M sort_buffer_size = 12M #20160709_modify #read_buffer_size = 48M read_buffer_size = 12M #20160709_modify tmp-table-size = 1G #join-buffer-space-limit = 48M #20160709_modify #join-cache-level = 6 #20160709_modify join-buffer-size = 12M #20160709_modify #join-buffer-size = 1M # Query Cache query-cache-size = 0 query-cache-type = 0 #Replication server-id = 2 slave_parallel_threads = 8 gtid_domain_id = 1 relay-log = /logs001/masvc01/relay/mysqld-relay-bin # Security symbolic-links = 0 local-infile = 1 # Logging log-warnings = 2 log-error = /logs001/masvc01/error/mysqld.err general_log = 0 general_log_file = /logs001/masvc01/general/mariadb-general.log sql_error_log_filename = /logs001/masvc01/error/sql_errors.log sql_error_log_rate = 1 sql_error_log_rotate = 1 sql_error_log_rotations = 9 sql_error_log_size_limit = 104857600 slow-query-log = 1 long-query-time = 0.5 #long-query-time = 3 log-slow-verbosity = 'query_plan,explain' slow_query_log_file = /logs001/masvc01/slow/mariadb-slow.log # Binlog File binlog-annotate-row-events = OFF log_bin = /logs001/masvc01/binary/mariadb-bin log_bin_index = /logs001/masvc01/binary/mariadb-bin.index binlog-format = MIXED expire-logs-days = 7 max-binlog-size = 1024M # InnoDB default-storage-engine = 'InnoDB' innodb_data_home_dir = /data001/masvc01 innodb_data_file_path = ibdata1:2048M;ibdata2:2048M;ibdata3:2048M;ibdata4:2048M:autoextend innodb-stats-on-metadata = 0 #innodb-stats-sample-pages = 32 #20160709_modify # To be set to 0 if not multi transactional storage engine innodb-support-xa = ON innodb_large_prefix = 1 innodb-buffer-pool-instances = 4 #innodb-buffer-pool-size = 40G ##20160709_modify innodb-buffer-pool-size = 28G innodb-max-dirty-pages-pct = 50 innodb-file-per-table = 1 innodb-file-format = Barracuda innodb-flush-log-at-trx-commit = 1 innodb_flush_method = O_DIRECT innodb-log-buffer-size = 32M #innodb-log-buffer-size = 1024M innodb-log-files-in-group = 3 innodb-log-file-size = 1024M innodb-open-files = 8192 innodb-read-io-threads = 12 innodb-write-io-threads = 12 innodb_print_all_deadlocks = 1 innodb_show_verbose_locks = 1 innodb_lock_wait_timeout = 100 #innodb buffer dump innodb_buffer_pool_dump_at_shutdown = 1 innodb_buffer_pool_load_at_startup = 1 innodb_buffer_pool_load_now = 1 innodb_buffer_pool_dump_now = 1 #innodb_force_recovery = 1 # MyISAM #key-buffer-size = 24M #20160709_modify key-buffer-size = 24M flush = OFF myisam-recover-options = BACKUP,FORCE #myisam-sort-buffer-size = 24M #20160709_modify myisam-sort-buffer-size = 24M # Other # -- Enable INFORMATION_SCHEMA.%_STATISTICS tables userstat = ON [mysql] default-character-set = 'utf8' auto-rehash = FALSE local-infile = 1 #max-allowed-packet = 512M #20160829_modify max-allowed-packet = 1024M #20160709_modify secure-auth = TRUE [mysqldump] max-allowed-packet = 1024M #max-allowed-packet = 1024M #20160829_modify default-character-set = 'utf8' [myisamchk] key-buffer-size = 32M sort-buffer-size = 32M read-buffer-size = 12M write-buffer-size = 12M