innodb启动mysqlwindows
2015-12-08t04:29:25.523685z 0 [warning] insecure configuration for --secure-file
-priv: current value does not restrict location of generated files. consider set
ting it to a valid, non-empty path.
2015-12-08t04:29:25.524685z 0 [note] mysqld (mysqld 5.7.10) starting as process
8524 ...
2015-12-08t04:29:25.536686z 0 [note] innodb: mutexes and rw_locks use windows in
terlocked functions
2015-12-08t04:29:25.537686z 0 [note] innodb: uses event mutexes
2015-12-08t04:29:25.538686z 0 [note] innodb: _mm_lfence() and _mm_sfence() are u
sed for memory barrier
2015-12-08t04:29:25.539686z 0 [note] innodb: compressed tables use zlib 1.2.3
2015-12-08t04:29:25.540686z 0 [note] innodb: number of pools: 1
2015-12-08t04:29:25.541686z 0 [note] innodb: not using cpu crc32 instructions
2015-12-08t04:29:25.589689z 0 [note] innodb: initializing buffer pool, total siz
e = 80m, instances = 1, chunk size = 80m
2015-12-08t04:29:25.606690z 0 [note] innodb: completed initialization of buffer
pool
2015-12-08t04:29:25.640692z 0 [note] innodb: highest supported file format is ba
rracuda.
2015-12-08t04:29:25.692695z 0 [note] innodb: creating shared tablespace for temp
orary tables
2015-12-08t04:29:25.695695z 0 [note] innodb: setting file '.\ibtmp1' size to 12
mb. physically writing the file full; please wait ...
2015-12-08t04:29:25.728697z 0 [note] innodb: file '.\ibtmp1' size is now 12 mb.
下面是 my.ini
for advice on how to change settings please seehttp://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html*** do not edit this file. it's a template which will be copied to the*** default location during install, and will be replaced if you*** upgrade to a newer version of mysql.[mysqld]
remove leading # and set to the amount of ram for the most important datacache in mysql. start at 70% of total ram for dedicated server, else 10%.innodb_buffer_pool_size = 128mremove leading # to turn on a very important data integrity option: loggingchanges to the binary log between backups.log_binthese are commonly set, remove the # and set as required.basedir =e:\data\mysql-5.7.10-winx64
datadir =e:\data\mysql-5.7.10-winx64\data
tmpdir =e:\data\mysql-5.7.10-winx64\temp
port = 3306
server_id = .....remove leading # to set options mainly useful for reporting servers.the server defaults are faster for transactions and fast selects.adjust sizes as needed, experiment to find the optimal values.join_buffer_size = 128msort_buffer_size = 2mread_rnd_buffer_size = 2msocket=e:\data\mysql-5.7.10-winx64\mysql.sock
#skip_innodb
innodb_data_file_path=idbdata1:200m:autoextend
innodb_buffer_pool_size=80m
#innodb_additional_mem_pool_size=2m
innodb_log_file_size=20m
innodb_log_buffer_size=8m
innodb_flush_log_at_trx_commit=1
sql_mode=no_engine_substitution,strict_trans_tables
default_password_lifetime=0