mysql配置文件模板
程序员文章站
2022-03-07 10:06:12
...
[client] port = 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] # Basic #skip-grant-tables port = 3306 user = mysql basedir = /usr/local/mysql datadir = /data/mysql/data tmpdir = /data/mysql/tmp socket = /tmp/mysql.sock log-bin = /data/mysql/logs/mysql-bin log-error = error.log slow-query-log-file = slow.log skip-external-locking skip-name-resolve log-slave-updates explicit_defaults_for_timestamp=true server-id =10001 character-set-server = utf8 slow-query-log binlog_format = mixed max_binlog_size = 128M binlog_cache_size = 1M expire-logs-days = 5 back_log = 500 long_query_time=1 #lower_case_table_name=1 max_connections=1100 max_user_connections=1000 max_connect_errors=1000 wait_timeout=14400 interactive_timeout=100 connect_timeout = 20 slave-net-timeout=30 max-relay-log-size = 256M relay-log = relay-bin transaction_isolation = READ-COMMITTED performance_schema=0 #myisam_recover key_buffer_size = 64M max_allowed_packet = 16M #table_cache = 3096 table_open_cache = 6144 table_definition_cache = 4096 sort_buffer_size = 128K read_buffer_size = 1M read_rnd_buffer_size = 1M join_buffer_size = 128K myisam_sort_buffer_size = 32M tmp_table_size = 32M max_heap_table_size = 64M query_cache_type=0 query_cache_size = 0 bulk_insert_buffer_size = 32M thread_cache_size = 64 #thread_concurrency = 32 thread_stack = 192K skip-slave-start # InnoDB innodb_data_home_dir = /data/mysql/data innodb_log_group_home_dir = /data/mysql/logs innodb_data_file_path = ibdata1:1G:autoextend innodb_buffer_pool_size = 1G innodb_buffer_pool_instances = 8 #innodb_additional_mem_pool_size = 16M innodb_log_file_size = 200M innodb_log_buffer_size = 16M innodb_log_files_in_group = 3 innodb_flush_log_at_trx_commit = 0 innodb_lock_wait_timeout = 10 innodb_sync_spin_loops = 40 innodb_max_dirty_pages_pct = 90 innodb_support_xa = 0 innodb_thread_concurrency = 0 innodb_thread_sleep_delay = 500 innodb_file_io_threads = 4 innodb_concurrency_tickets = 1000 log_bin_trust_function_creators = 1 innodb_flush_method = O_DIRECT innodb_file_per_table innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity = 2000 innodb_file_format = Barracuda innodb_purge_threads=1 innodb_purge_batch_size = 32 innodb_old_blocks_pct=75 innodb_change_buffering=all innodb_stats_on_metadata=OFF [mysqldump] quick max_allowed_packet = 128M #myisam_max_sort_file_size = 10G [mysql] no-auto-rehash max_allowed_packet = 128M prompt = '(product)\u@\h [\d]> ' default_character_set = utf8 [myisamchk] key_buffer_size = 64M sort_buffer_size = 512k read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_safe] #malloc-lib= /usr/local/mysql/lib/mysql/libjemalloc.so
推荐阅读
-
走进SpringBoot之配置文件与多环境详解
-
vue-cli3 项目优化之通过 node 自动生成组件模板 generate View、Component
-
SpringMVC和Spring的配置文件扫描包详解
-
C#微信接口之推送模板消息功能示例
-
MySQL 双向备份的实现方法
-
MYSQL使用.frm恢复数据表结构的实现方法
-
MySQL修改innodb_data_file_path参数的一些注意事项
-
Python使用自带的ConfigParser模块读写ini配置文件
-
MySQL中的LOCATE和POSITION函数使用方法
-
python安装mysql-python简明笔记(ubuntu环境)