Mysql解压版安装重要信息.doc

《Mysql解压版安装重要信息.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Mysql解压版安装重要信息 1、my.ini配置信息 [client]port      =3358socket     =E:MySQLmysql-5.6.17-winx64mysql.sock  [mysqld]port      =3358socket     =E:MySQLmysql-5.6.17-winx64mysql.sockbasedir    =E:MySQLmysql-5.6.17-winx64datadir    =E:MySQLmysql-5.6.17-winx64dat

2、a  #---GLOBAL---#character-set-server  =utf8lower_case_table_names =1log-output       =FILElong_query_time    =0.1#sync_binlog      =1max_connections=20000##################### #--------------# thread_concurrency   =16thread_cache_size   =512table_open_cache    

3、=16384table_definition_cache =16384sort_buffer_size    =2Mjoin_buffer_size    =2Mread_buffer_size    =4Mread_rnd_buffer_size  =4Mkey_buffer_size    =64Mmyisam_sort_buffer_size=64Mtmp_table_size     =256Mmax_heap_table_size  =256Mopen_files_limit    =1024#query_c

4、ache_size   =2G  #---NETWORK---#back_log        =1024max_allowed_packet   =16Minteractive_timeout  =wait_timeout      =skip-external-lockingmax-connections    =500skip-name-resolve #---REPL---#server-id       =20644log-bin        =mysql-binbinlog_format     =mix

5、edexpire_logs_days    =7relay-log       =relay-logreplicate-ignore-db  =testlog_slave_updatesskip-slave-start  #---INNODB---#default-storage-engine     =INNODBinnodb_data_home_dir      =E:MySQLmysql-5.6.17-winx64datainnodb_data_file_path     =ibdata1:12M:auto

6、extendinnodb_autoextend_increment  =500innodb_log_group_home_dir   =E:MySQLmysql-5.6.17-winx64datainnodb_autoextend_increment  =500innodb_log_group_home_dir   =E:MySQLmysql-5.6.17-winx64datainnodb_buffer_pool_size    =20Minnodb_additional_mem_pool_size=10M

7、innodb_log_files_in_group   =3innodb_log_file_size      =512Minnodb_log_buffer_size     =8Minnodb_flush_log_at_trx_commit =1innodb_lock_wait_timeout    =120innodb_max_dirty_pages_pct   =75innodb_io_capacity       =100innodb_thread_concurrency   =32innodb_open_fi

8、les       =1024innodb_file_per_table     =1 [mysqldump]quickmax_allowed_packet=16M [mysql]auto-rehash#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL#safe-upd