Mysql解压版安装重要信息(共4页)

1、精选优质文档-倾情为你奉上Mysql解压版安装重要信息 1、my.ini配置信息 clientport            = 3358socket          = E:MySQLmysql-5.6.17-winx64mysql.sock  mysqldport            = 3358socket          =

2、 E:MySQLmysql-5.6.17-winx64mysql.sockbasedir         = E:MySQLmysql-5.6.17-winx64datadir         = E:MySQLmysql-5.6.17-winx64data  #- GLOBAL -#character-set-server    = utf8lower_case_table_names  = 1log-output      

3、60;      = FILElong_query_time         = 0.1#sync_binlog             = 1max_connections=20000# #-# thread_concurrency      = 16thread_cache_size       = 512table_open_cache       &

4、#160;= 16384table_definition_cache  = 16384sort_buffer_size        = 2Mjoin_buffer_size        = 2Mread_buffer_size        = 4Mread_rnd_buffer_size    = 4Mkey_buffer_size         = 64Mmyisam_sort_buffer_si

5、ze = 64Mtmp_table_size          = 256Mmax_heap_table_size     = 256Mopen_files_limit        = 1024#query_cache_size       = 2G  #- NETWORK -#back_log                = 1024max_allow

6、ed_packet      = 16Minteractive_timeout     = wait_timeout            = skip-external-lockingmax-connections         = 500skip-name-resolve #- REPL -#server-id               = 20644log-

7、bin                 = mysql-binbinlog_format           = mixedexpire_logs_days        = 7relay-log               = relay-logreplicate-ignore-db     = testlog_slave_update

8、sskip-slave-start  #- INNODB -#default-storage-engine          = INNODBinnodb_data_home_dir            = E:MySQLmysql-5.6.17-winx64datainnodb_data_file_path           = ibdata1:12M:autoextendinnodb_autoextend_i

9、ncrement     = 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_add

10、itional_mem_pool_size = 10Minnodb_log_files_in_group       = 3innodb_log_file_size            = 512Minnodb_log_buffer_size          = 8Minnodb_flush_log_at_trx_commit  = 1innodb_lock_wait_timeout        =

11、120innodb_max_dirty_pages_pct      = 75innodb_io_capacity              = 100innodb_thread_concurrency       = 32innodb_open_files               = 1024innodb_file_per_table           = 1 mysqldumpquickmax_allowed_packet = 16M mysqlauto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates#prompt=(u:R:m:s)d>default-character-set=utf8 myisamchkkey_buffer_size = 128Msort_buffer_size = 128Mread_