1.默认基本配置

[mysqld]#character_set_server=utf8datadir=D:/Program Files/MariaDB 10.0/dataport=3306sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"default_storage_engine=innodbinnodb_buffer_pool_size=505Minnodb_log_file_size=50M[client]port=3306#----------------------------------------------------------[mysqld]datadir=D:/Program Files/MariaDB 10.0/dataport=3306sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"default_storage_engine=innodbinnodb_buffer_pool_size=505Minnodb_log_file_size=50Mcharacter_set_server=utf8server-id=3log_bin= mysql-bininnodb_flush_log_at_trx_commit=1sync_binlog=1

2.有一定优化的配置

[mysqld]character_set_server=utf8datadir=D:/Program Files/MariaDB 10.0/dataport=3306explicit_defaults_for_timestamp=truesql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"default_storage_engine=innodb#######################################################innodb_buffer_pool_size=505Minnodb_log_file_size=50Minnodb_log_buffer_size = 8Minnodb_log_file_size = 500Minnodb_log_files_in_group = 3innodb_additional_mem_pool_size = 16Minnodb_autoinc_lock_mode = 1   #1基于表 2.基于行innodb_buffer_pool_size = 2Ginnodb_flush_log_at_trx_commit = 2innodb_file_per_table=1innodb_file_io_threads=4innodb_io_capacity=2000innodb_io_capacity_max=6000innodb_lru_scan_depth=2000innodb_thread_concurrency = 16innodb_max_dirty_pages_pct = 90#innodb_flush_method=O_DSYNCinnodb_flush_method=O_DIRECTinnodb_lock_wait_timeout = 120########################################################log-bin=mysql-binbinlog_format=mixed#binlog_format=ROWsync_binlog=1sync_relay_log=1expire_logs_days=7thread_stack = 240Ktransaction_isolation = REPEATABLE-READtmp_table_size = 128Mwait_timeout=30slow_query_loglong_query_time = 2back_log=1024#skip-networkingmax_connections = 1000max_connect_errors = 10000000table_open_cache = 2048#external-lockingmax_allowed_packet = 16Mbinlog_cache_size = 2Mmax_heap_table_size = 128Mread_buffer_size = 8Mread_rnd_buffer_size = 16Msort_buffer_size = 8Mjoin_buffer_size = 64Mthread_cache_size = 1024thread_concurrency = 8query_cache_size = 128Mquery_cache_limit = 64M[client]port=3306