The perfect solution for mysql to automatically stop Plugin FEDERATED is disabled, pluginfederated
Mysql, the new server purchased in the past two days, is always stopped automatically and logs are checked.
9:13:57 [Note] MySQL: Normal shutdown
9:13:57 [Note] Event schedents: 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.0 M
9:13:59 InnoDB: Completed initialization of buffer pool
9:13:59 InnoDB: Started; log sequence number 0 44273
9:13:59 [Note] Event schedents: Loaded 0 events
9:13:59 [Note] MySQL: ready for connections.
Version: '5. 1.61-communit' socket: ''port: 3306 MySQL community Server (GPL)
9:14:24 [Note] MySQL: Normal shutdown
Methods found online
Add a line in [mysqld] In the MY. ini file tmpdir = "D:/MySQL/data/tmp"
Delete ib_logfile0 and ib_logfile1 under the MySQL directory
No use after testing
Later, mysql was automatically restarted in the service.
Last
[Mysqld]
Federated
Solution
Normal startup
10:28:01 InnoDB: Initializing buffer pool, size = 8.0 M
10:28:01 InnoDB: Completed initialization of buffer pool
10:28:01 InnoDB: Started; log sequence number 0 44556
10:28:01 [Note] Event schedents: Loaded 0 events
10:28:01 [Note] MySQL: ready for connections.
Version: '5. 1.61-communit' socket: ''port: 3306 MySQL community Server (GPL)
Add easily
Skip-external-locking
Skip-name-resolve
Solution