Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- #skip-innodb
- #skip-federated
- #skip-pbxt
- #skip-pbxt_statistics
- #skip-archive
- #skip-name-resolve
- #old_passwords
- back_log = 75
- max_connections = 300
- key_buffer_size = 32M
- myisam_sort_buffer_size = 32M
- myisam_max_sort_file_size = 2048M
- join_buffer_size = 64K
- read_buffer_size = 64K
- sort_buffer_size = 128K
- table_definition_cache = 4096
- table_open_cache = 2048
- thread_cache_size = 64
- wait_timeout = 120
- connect_timeout = 10
- tmp_table_size = 32M
- max_heap_table_size = 32M
- max_allowed_packet = 32M
- max_seeks_for_key = 1000
- group_concat_max_len = 1024
- max_length_for_sort_data = 1024
- net_buffer_length = 16384
- max_connect_errors = 100000
- concurrent_insert = 2
- read_rnd_buffer_size = 256K
- bulk_insert_buffer_size = 8M
- query_cache_limit = 512K
- query_cache_size = 16M
- query_cache_type = 1
- query_cache_min_res_unit = 2K
- query_prealloc_size = 262144
- query_alloc_block_size = 65536
- transaction_alloc_block_size = 8192
- transaction_prealloc_size = 4096
- default-storage-engine = InnoDB
- log_warnings=1
- slow_query_log=0
- long_query_time=2
- slow_query_log_file=/var/log/mariadb/mariadb-slow.log
- # innodb settings
- #innodb_extra_rsegments = 4
- innodb_purge_threads=1
- innodb_doublewrite = 1
- innodb_file_per_table = 1
- innodb_open_files = 1000
- innodb_data_file_path= ibdata1:10M:autoextend
- innodb_buffer_pool_size = 4G
- innodb_log_files_in_group = 2
- innodb_log_file_size = 512M
- innodb_log_buffer_size = 64M
- innodb_flush_log_at_trx_commit = 2
- innodb_thread_concurrency = 0
- innodb_lock_wait_timeout=50
- #innodb_flush_method = O_DIRECT
- # 200 * # DISKS
- innodb_io_capacity = 100
- innodb_read_io_threads = 2
- innodb_write_io_threads = 2
- #timeouts
- interactive_timeout = 86400
- wait_timeout = 86400
- # mariadb settings
- [mariadb]
- #thread-handling = pool-of-threads
- #thread-pool-size= 20
- #mysql --port=3307 --protocol=tcp
- #extra-port=3307
- #extra-max-connections=1
- userstat = 0
- key_cache_segments = 1
- aria_group_commit = none
- aria_group_commit_interval = 0
- aria_log_file_size = 32M
- aria_log_purge_type = immediate
- aria_pagecache_buffer_size = 8M
- aria_sort_buffer_size = 8M
- [mariadb-5.5]
- #ignore_db_dirs=
- query_cache_strip_comments=0
- innodb_read_ahead = linear
- innodb_adaptive_flushing_method = estimate
- innodb_flush_neighbor_pages = 1
- innodb_stats_update_need_lock = 0
- innodb_log_block_size = 512
- log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
- [mysqld_safe]
- #log-error=/var/log/mysqld.log
- #nice = -5
- open-files-limit = 8192
- [mysqldump]
- quick
- max_allowed_packet = 32M
- [myisamchk]
- key_buffer = 32M
- sort_buffer = 16M
- read_buffer = 16M
- write_buffer = 16M
- [mysqlhotcopy]
- interactive-timeout
- [mariadb-10.0]
- performance_schema=OFF
- innodb_stats_on_metadata=OFF
- innodb_sort_buffer_size=2M
- innodb_online_alter_log_max_size=128M
- query_cache_strip_comments=0
- log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
- [mariadb-10.1]
- innodb_file_format = Barracuda
- innodb_file_per_table = 1
- innodb_buffer_pool_dump_at_shutdown=1
- innodb_buffer_pool_load_at_startup=1
- innodb_buffer_pool_populate=0
- innodb_defragment=1
- innodb_defragment_n_pages=7
- innodb_defragment_stats_accuracy=0
- innodb_defragment_fill_factor_n_recs=20
- innodb_defragment_fill_factor=0.9
- innodb_defragment_frequency=40
- query_cache_size=0
- query_cache_type=0
- join_buffer_size=256K
- tmp_table_size=16M
- max_heap_table_size=16M
- thread_cache_size=4
- innodb_buffer_pool_size=4G
- innodb_log_file_size=2G
- innodb_buffer_pool_instances=16
- back_log = 150
- innodb-flush-neighbors = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement