Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- # *** configuration options
- port=3306
- datadir=/var/lib/mysql
- tmpdir=mysqltmp
- pid-file=mysqld.pid
- log-error=mysqld_error.log
- socket=mysql.sock
- skip-name-resolve
- ndbcluster
- ndb-connectstring=172.16.101.252:1186
- ndb_use_exact_count=0
- ndb_index_stat_enable=0
- ndb_force_send=1
- engine_condition_pushdown=1
- log_warnings
- wait_timeout=600
- # *** Replication related settings
- server-id=1
- skip-slave-start
- log-slave-updates
- slave-skip-errors=1062,1060,1141,1146,1206,1592
- log-bin=/var/lib/mysql/mysql-bin
- relay-log = /var/log/mysql/relay-bin
- binlog_format=mixed
- # *** Generic performance options
- group_concat_max_len = 1000000
- max_allowed_packet = 1G
- back_log = 50
- max_connections = 450
- max_connect_errors = 10
- table_cache = 1024
- table_open_cache = 64
- binlog_cache_size = 1M
- max_heap_table_size = 64M
- sort_buffer_size = 8M
- join_buffer_size = 8M
- thread_cache_size = 10
- query_cache_size = 1G
- query_cache_limit = 20M
- thread_stack = 192K
- tmp_table_size = 962M
- #*** MyISAM Specific options
- key_buffer_size = 16M
- read_buffer_size = 256K
- read_rnd_buffer_size = 512K
- bulk_insert_buffer_size = 64M
- myisam_sort_buffer_size = 512K
- myisam_max_sort_file_size = 10G
- myisam_repair_threads = 1
- net_buffer_length = 8K
- # *** INNODB Specific options ***
- innodb_file_per_table
- innodb_additional_mem_pool_size = 2M
- innodb_buffer_pool_size = 16M
- innodb_read_io_threads = 4
- innodb_thread_concurrency = 16
- innodb_flush_log_at_trx_commit = 1
- innodb_log_buffer_size = 8M
- innodb_log_file_size = 256M
- innodb_log_files_in_group = 3
- innodb_log_group_home_dir=/var/lib/mysql/innodb
- innodb_max_dirty_pages_pct = 90
- innodb_table_locks = 1
- innodb_lock_wait_timeout = 120
- innodb_data_home_dir = /var/lib/mysql/innodb
- [mysqldump]
- quick
- max_allowed_packet = 16M
- [mysql]
- no-auto-rehash
- [mysql_cluster]
- ndb-connectstring=172.16.101.252:1186
- [myisamchk]
- key_buffer = 20M
- sort_buffer_size = 20M
- read_buffer = 2M
- write_buffer = 2M
- [mysqlhotcopy]
- interactive-timeout
- [mysql.server]
- user=mysql
- [mysqld_safe]
- open-files-limit = 8192
- err-log=/var/log/mysql/mysqld_error.log
- pid-file=mysqld.pid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement