欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

innodb启动-windows 以 zip 安装 mysql 5.7.9 innodb 一直无法启用

程序员文章站 2022-05-12 11:34:39
...
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