mysql 配置文件样例


[client]port=3306socket=/data/mysqldata/mysql.sock
[mysql]socket=/data/mysqldata/mysql.sockport=3306no-auto-rehashdefault-character-set=utf8mb4prompt=u@dR:m>

[mysqld]port=3306server_id=88888socket=/data/mysqldata/mysql开发云主机域名.sockdatadir=/data/mysqldatabasedir=/usr/local/mysqltransaction_isolation=REPEATABLE-READback_log=500event_scheduler=OFFslow_query_log_file=/data/mysqllog/slow-query.loglog_error=/data/mysqllog/errlog.errgeneral_log_file=/data/mysqllog/mysql-general.logrelay-log=/data/mysqllog/relay-log/relay-log.binrelay_log_recovery=oninnodb_data_home_dir=/data/mysqldatainnodb_undo_directory=/data/mysqldatainnodb_log_group_home_dir=/data/mysqldatalog_bin=/data/mysqllog/binlog/binlog.binskip-character-set-client-handshake=1character_set_server=utf8mb4collation_server=utf8mb4_general_ci

##INNODBinnodb_undo_tablespaces=3innodb_undo_logs=128group_concat_max_len=8388608innodb_additional_mem_pool_size=20Minnodb_file_per_table=1innodb_page_size=16384innodb_buffer_pool_size=62Ginnodb_data_file_path=ibdata1:1G:autoextendinnodb_lock_wait_timeout=120innodb_rollback_on_timeout=1innodb_print_all_deadlocks=oninnodb_read_io_threads=8innodb_write_io_threads=8innodb_adaptive_hash_index=1innodb_adaptive_flushing=1innodb_adaptive_flushing_lwm=30innodb_thread_concurrency=16innodb_flush_method=O_DIRECTinnodb_max_dirty_pages_pct=50innodb_io_capacity=500innodb_support_xa=1innodb_buffer_pool_instances=8innodb_sort_buffer_size=16Minnodb_file_format=Barracudainnodb_file_format_max=Barracudainnodb_file_format_check=1innodb_fast_shutdown=1innodb_purge_threads=2innodb_flush_log_at_trx_commit=2innodb_log_buffer_size=64Minnodb_log_file_size=512Minnodb_log_files_in_group=3innodb_autoextend_increment=128

##MyISAMkey_buffer_size=64Mmyisam_sort_buffer_size=128Mmyisam_max_sort_file_size=10Gconcurrent_insert=2
##OTHERsync_binlog=1binlog_format=rowbinlog_cache_size=256Kbinlog_checksum=CRC32max_binlog_size=512Mlog_bin_trust_function_creators=1expire_logs_days=10slow_query_log=onbinlog_rows_query_log_events=1long_query_time=1read_buffer_size=4Mread_rnd_buffer_size=4Mbulk_insert_buffer_size=64Msort_buffer_size=6Mjoin_buffer_size=4Mquery_cache_type=0query_cache_size=0query_cache_limit=2Mtmp_table_size=64Mtable_open_cache=5120thread_cache_size=128open_files_limit=65535master-info-repository=TABLErelay-log-info-repository=TABLEskip_external_locking=1net_buffer_length=8Kskip_name_resolve=1secure_file_priv=”log_slave_updates=1
##MAXLIMITmax_connections=1000max_length_for_sort_data=8096max_heap_table_size=64Mmax_allowed_packet=1Gmax_connect_errors=99999999max_heap_table_size=512Mmax_length_for_sort_data=16kmax_slowlog_files =3max_slowlog_size =1073741824

##TIMEOUTwait_timeout=28800interactive_timeout=28800

[mysqldump]max_allowed_packet=512Mdefault-character-set=utf8mb4

相关推荐: 基于逻辑卷LVM的MySQL、mariadb数据库备份还原详细实现

创建分区:创建PV,vg,lv:提供数据目录,挂载:提供数据:刷新日志,记录二开发云主机域名进制日志的位置:使用lv创建数据库快照:相关推荐: 第二章 身份验证——跟我学习springmvc shiro mybatis身份验证,即在应用中谁能证明他就是他本人。…

免责声明:本站发布的图片视频文字,以转载和分享为主,文章观点不代表本站立场,本站不承担相关法律责任;如果涉及侵权请联系邮箱:360163164@qq.com举报,并提供相关证据,经查实将立刻删除涉嫌侵权内容。

(0)
打赏 微信扫一扫 微信扫一扫
上一篇 06/04 18:56
下一篇 06/04 18:56

相关推荐