文章摘要
这篇文章主要介绍了MySQL服务的配置文件内容，涵盖了MySQL服务的连接、字符集、存储引擎、性能优化等关键设置。文章提到MySQL使用了InnoDB存储引擎，并详细列出了配置参数，如默认字符集（utf8mb4）、最大连接数（5295）、日志文件存储位置（mysql-bin）、性能优化选项（innodb_strict_mode=0）等。此外，文章还提到了一些其他配置项，如安全模式（sql_mode）、硬件资源分配（max_heap_table_size=8M）、日志大小限制（binlog_log_size=32M）等。这些设置旨在优化MySQL的性能和稳定性，适合用于Linux环境下的MySQL服务配置。
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8mb4
?
[mysql]
prompt=”MySQL [\d]> ”
no-auto-rehash
?
[mysqld]
port=3306
socket=/var/lib/mysql/mysql.sock
default_authentication_plugin=mysql_native_password
?
datadir=/var/lib/mysql
pid-file=/var/lib/mysql/mysql.pid
user=mysql
bind-address=0.0.0.0
server-id=1
?
init-connect=’SET NAMES utf8mb4′
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci
?
skip-name-resolve
#skip-networking
back_log=300
?
max_connections=5295
max_connect_errors=6000
open_files_limit=65535
table_open_cache=1024
max_allowed_packet=500M
binlog_cache_size=1M
max_heap_table_size=8M
tmp_table_size=128M
?
read_buffer_size=2M
read_rnd_buffer_size=8M
sort_buffer_size=8M
join_buffer_size=8M
key_buffer_size=256M
?
thread_cache_size=64
?
ft_min_word_len=4
?
log_bin=mysql-bin
binlog_format=row
binlog_expire_logs_seconds=604800
?
log_error=/var/lib/mysql/mysql-error.log
slow_query_log=1
long_query_time=1
slow_query_log_file=/var/lib/mysql/mysql-slow.log
?
performance_schema=0
explicit_defaults_for_timestamp
?
lower_case_table_names=1
?
skip-external-locking
?
default_storage_engine=InnoDB
#default-storage-engine=MyISAM
innodb_file_per_table=1
innodb_open_files=500
innodb_buffer_pool_size=1024M
innodb_write_io_threads=4
innodb_read_io_threads=4
innodb_thread_concurrency=0
innodb_purge_threads=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=2M
innodb_log_file_size=32M
innodb_log_files_in_group=3
innodb_max_dirty_pages_pct=90
innodb_lock_wait_timeout=120
?
bulk_insert_buffer_size=8M
myisam_sort_buffer_size=64M
myisam_max_sort_file_size=10G
?
interactive_timeout=28800
wait_timeout=28800
?
binlog_rows_query_log_events=1
log_bin_trust_function_creators=1
log_timestamps=SYSTEM
?
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
#sql_mode=NO_AUTO_VALUE_ON_ZERO
innodb_strict_mode=0
plugin-load=mysql_clone.so
?
[mysqldump]
quick
max_allowed_packet=500M
?
[myisamchk]
key_buffer_size=256M
sort_buffer_size=8M
read_buffer=4M
write_buffer=4M