These two days the new server MySQL always automatically stop, check the log
9:13:57 [note] Mysql:normal shutdown
9:13:57 [note] Event scheduler:purging the queue. 0 Events
9:13:57 innodb:starting shutdown ...
9:13:58 Innodb:shutdown completed; Log sequence number 0 44273
9:13:58 [note] Mysql:shutdown complete
Reboot discovery
9:13:59 [note] Plugin ' federated ' is disabled.
9:13:59 innodb:initializing buffer pool, size = 8.0M
9:13:59 innodb:completed initialization of buffer pool
9:13:59 innodb:started; Log sequence number 0 44273
9:13:59 [note] Event scheduler:loaded 0 Events
9:13:59 [note] Mysql:ready for connections.
Version: ' 5.1.61-community ' socket: ' port:3306 MySQL Community Server (GPL)
9:14:24 [note] Mysql:normal shutdown
Methods found on the Internet
Add a row to [mysqld] in the My.ini file tmpdir= "D:/mysql/data/tmp"
Delete the IB_LOGFILE0 and ib_logfile1 in the MySQL directory
No use after the test
MySQL automatic restart was later set up in the service
At last
[Mysqld]
Federated
Solve
Start Normal
10:28:01 innodb:initializing buffer pool, size = 8.0M
10:28:01 innodb:completed initialization of buffer pool
10:28:01 innodb:started; Log sequence number 0 44556
10:28:01 [note] Event scheduler:loaded 0 Events
10:28:01 [note] Mysql:ready for connections.
Version: ' 5.1.61-community ' socket: ' port:3306 MySQL Community Server (GPL)
Conveniently add
Skip-external-locking
Skip-name-resolve
Solve