当前位置:Gxlcms > mysql > innodb启动-windows以zip安装mysql5.7.9innodb一直无法启用

innodb启动-windows以zip安装mysql5.7.9innodb一直无法启用

时间:2021-07-01 10:21:17 帮助过:5人阅读

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 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

人气教程排行