Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [client]
- #password = your_password
- port = 3306
- socket = /tmp/mysql.sock
- [mysqld]
- binlog_cache_size = 984K
- thread_stack = 998K
- join_buffer_size = 58192K
- query_cache_type = 1
- max_heap_table_size = 8192M
- port = 3306
- socket = /tmp/mysql.sock
- datadir = /www/server/data
- default_storage_engine = InnoDB
- performance_schema_max_table_instances = 7000
- table_definition_cache = 7000
- skip-external-locking
- key_buffer_size = 1342177280
- max_allowed_packet = 8192M
- table_open_cache = 4294967295
- sort_buffer_size = 8192K
- net_buffer_length = 16K
- read_buffer_size = 8192K
- read_rnd_buffer_size = 8192K
- myisam_sort_buffer_size = 4096M
- thread_cache_size = 900000
- #query_cache_size =
- tmp_table_size=4294967295
- sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
- #skip-name-resolve
- max_connections = 100000
- max_connect_errors = 10000
- open_files_limit = 6553555
- log-bin=mysql-bin
- binlog_format=mixed
- server-id = 1
- expire_logs_days = 10
- slow_query_log=1
- slow-query-log-file=/www/server/data/mysql-slow.log
- long_query_time=3
- #log_queries_not_using_indexes=on
- innodb_data_home_dir = /www/server/data
- innodb_data_file_path = ibdata1:10M:autoextend
- innodb_log_group_home_dir = /www/server/data
- innodb_buffer_pool_size = 128G
- innodb_log_file_size = 8192M
- innodb_log_buffer_size = 8192M
- innodb_flush_log_at_trx_commit = 1
- innodb_lock_wait_timeout = 120
- innodb_max_dirty_pages_pct = 90
- innodb_read_io_threads = 100000
- innodb_write_io_threads = 100000
- [mysqldump]
- quick
- max_allowed_packet = 16G
- [mysql]
- no-auto-rehash
- [myisamchk]
- key_buffer_size = 1342177280
- sort_buffer_size = 16g
- read_buffer = 16G
- write_buffer = 16G
- [mysqlhotcopy]
- interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement