Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql]
- prompt='mysql [\h] {\u} (\d) > '
- #
- [client]
- user = skysql
- password = skyvodka
- port = 5054
- socket = /tmp/mysql_sandbox5054.sock
- [mysqld]
- #read_only=on
- sync_binlog = 1
- #thread_handling=pool-of-threads
- extra-port=5154
- extra-max-connections=10
- # semisync
- plugin-load="semisync_master.so;semisync_slave.so;spider=ha_spider.so;spider_alloc_mem=ha_spider.so"
- rpl_semi_sync_master=ON
- rpl_semi_sync_slave=ON
- loose_rpl_semi_sync_master_enabled=ON
- loose_rpl_semi_sync_slave_enabled=ON
- slave-parallel-threads = 6
- slave-parallel-mode=optimistic
- log_slave_updates
- skip-slave-start
- log_bin
- binlog_format=ROW
- collation-server = utf8_general_ci
- init_connect='SET NAMES utf8'
- character-set-server = utf8
- user = root
- port = 5054
- socket = /tmp/mysql_sandbox5054.sock
- basedir = /usr/local/skysql/mariadb
- datadir = /var/lib/skysql/db-78b9ef7a/data
- tmpdir = /var/lib/skysql/db-78b9ef7a/tmp
- pid-file = /var/lib/skysql/db-78b9ef7a/data/mysql_sandbox5054.pid
- #log-slow-queries = /var/lib/skysql/db-78b9ef7a/data/msandbox-slow.log
- #log = /var/lib/skysql/db-78b9ef7a/data/msandbox.log
- #
- # additional options passed through 'my_clause'
- #
- server-id=5054
- #
- # additional options from /usr/local/skysql/ncc/etc/maria.template
- #
- #performance_schema =1
- #thread_handling=pool-of-threads
- #spider_dry_access=1
- #loose_spider_conn_recycle_mode=2
- skip_name_resolv
- local-infile=1
- skip_name_resolv
- back_log=128
- max_connections = 1024
- table_open_cache = 2048
- table_definition_cache = 2048
- max_allowed_packet = 16M
- # binlog_cache_size = 1M
- max_heap_table_size = 64M
- thread_cache_size = 128
- query_cache_size = 0
- query_cache_limit = 2M
- ft_min_word_len = 4
- #default_table_type = InnoDB
- thread_stack = 192K
- #transaction_isolation = READ-COMMITTED
- tmp_table_size = 64M
- expire_logs_days=7
- sort_buffer_size = 512K
- join_buffer_size = 1M
- innodb_autoinc_lock_mode = 2
- innodb_stats_on_metadata = 0
- innodb_buffer_pool_instances = 1
- innodb_flush_method = O_DIRECT
- innodb_log_file_size = 256M
- innodb_log_files_in_group=8
- innodb_buffer_pool_size = 1G
- innodb_additional_mem_pool_size = 16M
- innodb_log_buffer_size = 512M
- innodb_max_dirty_pages_pct = 30
- innodb_file_per_table
- innodb_doublewrite = 1
- innodb_flush_log_at_trx_commit = 1
- innodb_adaptive_hash_index = 0
- innodb_write_io_threads = 16
- innodb_flush_neighbors = 0
- innodb_thread_concurrency = 0
- innodb_defragment = 1
- innodb_open_files = 16384
- innodb_purge_threads = 8
- innodb_buffer_pool_populate=0
- innodb_change_buffering=none
- innodb_concurrency_tickets =5000
- innodb_io_capacity=20000
- innodb_io_capacity_max=40000
- innodb_old_blocks_time=2
- innodb_file_per_table
- #plugin-load=handlersocket=handlersocket.so
- #handlersocket_address=127.0.0.1
- #handlersocket_port=20500
- #handlersocket_port_wr=20501
- #key_cache_segments=
- key_buffer_size = 16M
- key_cache_block_size=4K
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement