首页 > MySQL > mysql 配置innodb 设置mysql-bin目录

mysql 配置innodb 设置mysql-bin目录

2007年5月16日 小 恒 发表评论 阅读评论

# Uncomment the following if you are using InnoDB tables
innodb_data_file_path = ibdata1:50M
innodb_data_home_dir = E:\EasyPHP2\mysql\ibdata
innodb_log_group_home_dir = E:\EasyPHP2\mysql\iblogs

innodb_log_arch_dir = E:\EasyPHP2\mysql\iblogs
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=64M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=256M
set-variable = innodb_additional_mem_pool_size=128M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=500

找到log-bin=mysql-bin

改为

log-bin={目录路径}mysql-bin

示例:log-bin=E:\EasyPHP2\mysql\logbin\mysql-bin

分类: MySQL 标签:
  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.