mysql安装，my.ini配置

admin

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

参看E-54-F范例：

新增的部分：

1. skip-name-resolve
   
2. 
   
3. 
   
4. log_output='TABLE'
   
5. 
   
6. slow_launch_time=1
   
7. long_query_time=1
   
8. 
   
9. log_slow_queries=1
   
10. slow_query_log=1
    
11. 
    
12. log_output='TABLE'
    
13. slow_launch_time=1
    
14. slow_query_log=1
    
15. long_query_time=1
    
16. skip-name-resolve
    
17. 
    
18. log-bin=E:\mysql-bin
    
19. binlog_format=mixed
    
20. server-id=107
    
21. slave-skip-errors=1

复制代码