my.conf
配置文件生成工具参考链接:https://imysql.com/my_cnf_generator
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
| [client]
port=3306 socket=/tmp/mysql.sock default-character-set=utf8mb4
[mysql] no-auto-rehash prompt="\\\r:\\\m:\\\s(\\\u@\\\h) [\\\d]>\\\_"
[mysqld] port=3306 socket=/tmp/mysql.sock basedir=${install_dir} datadir=${data_dir} pid-file=${data_dir}/mysql.pid user=${user} bind-address=0.0.0.0 server-id=1
init-connect='SET NAMES utf8mb4' character-set-server=utf8mb4
skip-name-resolve
back_log=300
max_connections=1000 max_connect_errors=6000 open_files_limit=65535 table_open_cache=128 max_allowed_packet=500M binlog_cache_size=1M max_heap_table_size=8M tmp_table_size=16M
read_buffer_size=2M read_rnd_buffer_size=8M sort_buffer_size=8M net_buffer_length=8K join_buffer_size=8M key_buffer_size=4M performance_schema_max_table_instances=500
thread_cache_size=8
ft_min_word_len=4
log_bin=mysql-bin binlog_format=mixed expire_logs_days=7
log_error=${data_dir}/mysql-error.log slow_query_log=1 long_query_time=1 slow_query_log_file=${data_dir}/mysql-slow.log
performance_schema=0 explicit_defaults_for_timestamp
skip-external-locking
default_storage_engine=InnoDB
innodb_file_per_table=1 innodb_data_home_dir=${data_dir} innodb_data_file_path=ibdata1:12M:autoextend innodb_log_group_home_dir=${data_dir} innodb_open_files=500 innodb_buffer_pool_size=64M 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=8M myisam_max_sort_file_size=10G myisam_repair_threads=1
interactive_timeout=28800 wait_timeout=28800
[mysqldump] quick max_allowed_packet=500M
[myisamchk] key_buffer_size=8M sort_buffer_size=8M read_buffer=4M write_buffer=4M
|