[client] port = 3306 socket = /tmp/mysql.sock [mysqld] ### User and Connection Related Parameters ### user = mysql bind-address = 0.0.0.0 port = 3306 socket = /tmp/mysql.sock max_connections = 500 max_user_connections = 500 interactive_timeout = 100 wait_timeout = 100 net_read_timeout = 60 skip-name-resolve event_scheduler = 1 #optimizer_search_depth = 3 #transaction-isolation=READ-COMMITTED #skip-networking ### Cache/Buffer Related Parameters ### ### Cache/Buffer Related Parameters ### large-pages table_open_cache = 5000 query_cache_type = 1 query_cache_size = 64M query_cache_limit = 64M key_buffer = 128M max_allowed_packet = 64M # Thread Specific Values sort_buffer_size = 16M read_buffer_size = 16M read_rnd_buffer_size = 16M join_buffer_size = 16M thread_cache_size = 64 ### Mysql Directory & Tables ### datadir = /data/mysql-5.6 tmp_table_size = 1024M max_heap_table_size = 256M open_files_limit = 16535 ### Innodb Related Parameters ### innodb_file_format = barracuda innodb_data_home_dir = /data/mysql-5.6 innodb_file_per_table = 1 #innodb_data_file_path = ibdata1:500M:autoextend innodb_log_group_home_dir = /data/mysql-5.6 innodb_log_files_in_group = 2 innodb_log_file_size = 256M innodb_buffer_pool_size = 8G #innodb_thread_concurrency = 8 #innodb_flush_method = O_DIRECT ### Log Related Parameteres ### log-error = /opt/mysql/log/mysqld.log log-warnings = 0 #long_query_time = 1 #slow_query_log = 1 #slow_query_log_file = /opt/mysql/log/slow_queries.log #log-queries-not-using-indexes ### Replication Related Parameters For Master ### server_id = 1 log-bin = /data/binlog/mysql-bin #expire_logs_days = 1 [mysql] #dont read table information for mysql hash no-auto-rehash