mysql 配置innodb 设置mysql-bin目录
# 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