深圳全飞鸿

标题: mysql安装，my.ini配置 [打印本页]

作者: admin 时间: 2019-6-7 17:22
标题: mysql安装，my.ini配置
mysql安装，my.ini配置

my.ini的配置，可参见

MES系统主数据库安装介绍 - DCC-0002-0001-0001
http://www.nagomes.com/disc/foru ... ad&tid=10&fromuid=1

综述：

my.ini

[mysqld]

#Path to the database root
datadir="D:\MySQL Datafiles\data"

#*** INNODB Specific options ***
innodb_data_home_dir="D:/MySQL Datafiles/"
innodb_file_per_table=1
query_cache_type=2

# Maximum size for internal (in-memory) temporary tables.
tmp_table_size=369M
max_heap_table_size = 256M

# my.ini文档结尾
skip-name-resolve
event_scheduler=1
log-bin=D:\Mysql-binlog\mysql-bin
binlog_format=MIXED
max_binlog_size=100m

作者: zhgc 时间: 2019-9-16 10:11
参看E-54-F范例：

新增的部分：

skip-name-resolve
log_output='TABLE'
slow_launch_time=1
long_query_time=1
log_slow_queries=1
slow_query_log=1
log_output='TABLE'
slow_launch_time=1
slow_query_log=1
long_query_time=1
skip-name-resolve
log-bin=E:\mysql-bin
binlog_format=mixed
server-id=107
slave-skip-errors=1

复制代码

欢迎光临深圳全飞鸿 (http://www.nagomes.com/disc/)