1.轻量配置
[client] port=3306 default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] port=3306 server_id=1 basedir="{up-path}Modules/MySQL/" datadir="{up-path}Database/data_mysql/" tmpdir="{up-path}Temp/mysql/" log-error="{up-path}Logs/mysql.log" slow-query-log-file="{up-path}Logs/mysql_slow_query.log" secure-file-priv="{up-path}Modules/MySQL/uploads" character-set-client-handshake=FALSE character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' default-storage-engine=MYISAM sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" explicit_defaults_for_timestamp=true interactive_timeout=120 wait_timeout=120 log_error_verbosity=1 slow_query_log=0 long_query_time=2 local-infile=0 skip-external-locking skip-ssl #skip-name-resolve #skip-networking #enable-named-pipe #bind-address=127.0.0.1 #log-bin=mysql-bin #binlog_format=mixed max_connections=100 query_cache_size=0 performance_schema_max_table_instances=600 table_definition_cache=400 key_buffer_size=32M sort_buffer_size=256kb read_buffer_size=512kb join_buffer_size=1M read_rnd_buffer_size=2M max_allowed_packet=16M table_open_cache=128 tmp_table_size=32M max_heap_table_size=32M thread_cache_size=8 myisam_max_sort_file_size=64G myisam_sort_buffer_size=8M innodb_buffer_pool_size=64M innodb_log_file_size=256M innodb_log_buffer_size=4M innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_flush_method=normal innodb_thread_concurrency=0 innodb_lock_wait_timeout=120 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] key_buffer_size=10M sort_buffer_size=10M read_buffer_size=1M write_buffer_size=1M tmpdir="{up-path}Temp/mysql/" [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit=8192
2.均衡配置
[client] port=3306 default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] port=3306 server_id=1 basedir="{up-path}Modules/MySQL/" datadir="{up-path}Database/data_mysql/" tmpdir="{up-path}Temp/mysql/" log-error="{up-path}Logs/mysql.log" slow-query-log-file="{up-path}Logs/mysql_slow_query.log" secure-file-priv="{up-path}Modules/MySQL/uploads" character-set-client-handshake=FALSE character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' default-storage-engine=MYISAM sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" explicit_defaults_for_timestamp=true interactive_timeout=120 wait_timeout=120 log_error_verbosity=1 slow_query_log=0 long_query_time=2 local-infile=0 skip-external-locking skip-ssl #skip-name-resolve #skip-networking #enable-named-pipe #bind-address=127.0.0.1 #log-bin=mysql-bin #binlog_format=mixed max_connections=300 query_cache_size=0 performance_schema_max_table_instances=600 table_definition_cache=400 key_buffer_size=64M sort_buffer_size=512kb read_buffer_size=1M join_buffer_size=2M read_rnd_buffer_size=4M max_allowed_packet=16M table_open_cache=256 tmp_table_size=64M max_heap_table_size=64M thread_cache_size=16 myisam_max_sort_file_size=64G myisam_sort_buffer_size=32M innodb_buffer_pool_size=128M innodb_log_file_size=256M innodb_log_buffer_size=8M innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_flush_method=normal innodb_thread_concurrency=0 innodb_lock_wait_timeout=120 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] key_buffer_size=20M sort_buffer_size=20M read_buffer_size=2M write_buffer_size=2M tmpdir="{up-path}Temp/mysql/" [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit=8192
3.高端配置
[client] port=3306 default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] port=3306 server_id=1 basedir="{up-path}Modules/MySQL/" datadir="{up-path}Database/data_mysql/" tmpdir="{up-path}Temp/mysql/" log-error="{up-path}Logs/mysql.log" slow-query-log-file="{up-path}Logs/mysql_slow_query.log" secure-file-priv="{up-path}Modules/MySQL/uploads" character-set-client-handshake=FALSE character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' default-storage-engine=MYISAM sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" explicit_defaults_for_timestamp=true interactive_timeout=120 wait_timeout=120 log_error_verbosity=1 slow_query_log=0 long_query_time=2 local-infile=0 skip-external-locking skip-ssl #skip-name-resolve #skip-networking #enable-named-pipe #bind-address=127.0.0.1 #log-bin=mysql-bin #binlog_format=mixed max_connections=600 query_cache_size=0 performance_schema_max_table_instances=600 table_definition_cache=400 key_buffer_size=256M sort_buffer_size=1M read_buffer_size=2M join_buffer_size=4M read_rnd_buffer_size=4M max_allowed_packet=16M table_open_cache=512 tmp_table_size=128M max_heap_table_size=128M thread_cache_size=32 myisam_max_sort_file_size=64G myisam_sort_buffer_size=64M innodb_buffer_pool_size=256M innodb_log_file_size=256M innodb_log_buffer_size=16M innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_flush_method=normal innodb_thread_concurrency=0 innodb_lock_wait_timeout=120 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] key_buffer_size=40M sort_buffer_size=40M read_buffer_size=4M write_buffer_size=4M tmpdir="{up-path}Temp/mysql/" [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit=8192
4.极限配置
[client] port=3306 default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] port=3306 server_id=1 basedir="{up-path}Modules/MySQL/" datadir="{up-path}Database/data_mysql/" tmpdir="{up-path}Temp/mysql/" log-error="{up-path}Logs/mysql.log" slow-query-log-file="{up-path}Logs/mysql_slow_query.log" secure-file-priv="{up-path}Modules/MySQL/uploads" character-set-client-handshake=FALSE character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' default-storage-engine=MYISAM sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" explicit_defaults_for_timestamp=true interactive_timeout=120 wait_timeout=120 log_error_verbosity=1 slow_query_log=0 long_query_time=2 local-infile=0 skip-external-locking skip-ssl #skip-name-resolve #skip-networking #enable-named-pipe #bind-address=127.0.0.1 #log-bin=mysql-bin #binlog_format=mixed max_connections=1000 query_cache_size=0 performance_schema_max_table_instances=600 table_definition_cache=400 key_buffer_size=512M sort_buffer_size=1M read_buffer_size=4M join_buffer_size=8M read_rnd_buffer_size=8M max_allowed_packet=16M table_open_cache=1024 tmp_table_size=256M max_heap_table_size=256M thread_cache_size=64 myisam_max_sort_file_size=64G myisam_sort_buffer_size=128M innodb_buffer_pool_size=512M innodb_log_file_size=256M innodb_log_buffer_size=16M innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_flush_method=normal innodb_thread_concurrency=0 innodb_lock_wait_timeout=120 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] key_buffer_size=80M sort_buffer_size=80M read_buffer_size=8M write_buffer_size=8M tmpdir="{up-path}Temp/mysql/" [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit=8192