innodb启动-windows 以 zip 安装 mysql 5.7.9 innodb 一直无法启用
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 see
http://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 data
cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 128M
Remove leading # to turn on a very important data integrity option: logging
changes to the binary log between backups.
log_bin
These 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 = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
socket="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