# Example MySQL config file for large systems. # # This is for a large system with memory = 512M where the system runs mainly # MySQL. # # MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You can copy this option file to one of those # locations. For information about these locations, see: # http://dev.mysql.com/doc/mysql/en/option-files.html # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the "--help" option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 13310 socket = /usr/local/mysql57/data13310/mysqld.sock # Here follows entries for some specific programs # The MySQL server [mysqld] sync_binlog = 1 port = 13310 basedir = /usr/local/mysql57 datadir = /usr/local/mysql57/data13310 socket = /usr/local/mysql57/data13310/mysqld.sock server_id = 13310 skip-slave-start skip-name-resolve wait_timeout = 31536000 #####non innodb options (fixed) #table_cache = 2400 sort_buffer_size = 32K join_buffer_size = 32K query_cache_size = 0 query_cache_type = 0 #####MyISAM Specific options key_buffer_size = 8M read_buffer_size = 256K read_rnd_buffer_size = 256K #####fixed innodb options innodb_file_per_table = true innodb_file_format = Barracuda innodb_data_file_path = ibdata1:200M:autoextend innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_log_file_size = 512M innodb_log_files_in_group = 4 #innodb_log_block_size=4096 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_buffer_pool_instances=1 innodb_buffer_pool_size = 1GB innodb_doublewrite=1 innodb_support_xa=1 innodb_sync_spin_loops=64 innodb_thread_concurrency=20 #####I/O Tuning for SSD innodb_io_capacity = 1000 #innodb_flush_neighbors = 0 ##innodb_flush_neighbor_pages = none #innodb_adaptive_flushing=off #innodb_change_buffering=none ##innodb_adaptive_flushing_method = keep_average #innodb_read_ahead = 0 log-bin=s247-bin log-slave-updates binlog-format=mixed lower-case-table-names=1 gtid-mode=on enforce-gtid-consistency max_connections = 5000 # change innodb_flush_log_at_trx_commit [mysqldump] quick max_allowed_packet = 16M socket = /usr/local/mysql57/data13310/mysqld.sock [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates