作者：不言不语都可以温柔_631 | 来源：互联网 | 2018-04-25 15:54
2015-12-08T04:29:25.523685Z0[Warning]Insecureconfigurationfor--secure-file-priv:Currentvaluedoesnotrestrictlocationofgeneratedfiles.Considersettingittoavalid,non-emptypath.2015-12-08T04:29:25.524685Z0[Note]mysqld(mysq...
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
京公网安备 11010802041100号