mysql 参数模板

[mysqld]user = mysqlbasedir = /usr/local/mysqldatadir = /usr/local/mysql/dataport = 3306socket = /usr/local/mysql/data/mysql.sock#--skip-lockingback_log = 500key_buffer_size = 256Mmax_allowed_packet = 64Mtable_open_cache = 512sort_buffer_size = 8Mread_buffer_size = 4Mjoin_buffer_size = 8M#query_cache_size = 512Mmax_connections = 1000max_connect_errors = 10000000#wait_timeout = 60interactive_timeout = 1000tmp_table_size = 256Mthread_concurrency = 16default_storage_engine=InnoDBskip_external_lockinglong_query_time = 1log-bin=/usr/local/mysql/datamax_binlog_cache_size = 512Mmax_binlog_size=1024Mlog_slow_queries = ONlog_slow_queries = /var/log/slow-queries.loglong_query_time=5log_queries_not_using_indexeslog-slow-admin-statementsexpire_logs_days = 30##  InnoDB optionsinnodb_additional_mem_pool_size = 16Minnodb_buffer_pool_size = 8G#innodb_buffer_pool_instances = 4#innodb_file_per_table = 1#innodb_file_io_threads = 8#innodb_force_recovery=1#innodb_thread_concurrency = 8#innodb_flush_log_at_trx_commit = 2innodb_log_buffer_size = 1024Minnodb_log_file_size = 512M#innodb_log_files_in_group = 3#innodb_max_dirty_pages_pct = 90innodb_flush_method=O_DSYNC