[Practice OK] Plugin FEDERATED is disabled, don't pay attention to this, it's okay.

Little scum · Posted on 1/30/2016 4:15:16 PM

In the err file of the mysql database, you can see the following information:

Plugin 'FEDERATED' is disabled

InnoDB: The InnoDB memory heap is disabled

Workaround: vi /etc/my.cnf

tmpdir = /tmp

innodb_use_sys_malloc =0

Reboot problem solving?

Is this parameter new and outdated?

InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator.

InnoDB: Warning: Setting innodb_use_sys_malloc fake is outdated. This option may be removed in a future release, along with InnoDB's memory allocator.

[Note] Plugin 'FEDERATED' is disabled.

Don't pay attention to this, it's okay.

__________________________________________

Find solutions online:

1. After adding a line of tmpdir="D:/MySQL/data/" to [mysqld] in the MY.INI file, it still can't start or can start but the same problem occurs after shutting down, and then I did the second step to restart normally.

2. Delete other files in the DATA directory except the database folder, restart mysql, and the problem is solved.

I did the above method but it didn't work, and I found a solution that was similar to the above

Step 1: Just delete the ib_logfile0 and ib_logfile1 files in the MySQL directory.

Step 2: Find out the reason why it cannot be started, MySQL will not automatically initiate tmpdir and temporary file directory when installing, so add the tmpdir path to the configuration file my.ini.

Finally add in the my.ini:

[mysqld]

#自己指定的临时文件目录

tmpdir="E:/Program Files/MySQL/MySQL Server 5.1/Temp/" //phpfensi.com

From: http://www.phpfensi.com/mysql/20140927/6253.html

[root@jackxiang mysql]# ls ib_logfile

ib_logfile0 ib_logfile1 ib_logfile2

[Source] [Practice OK] Plugin FEDERATED is disabled, don't pay attention to this, it's okay.

Related Posts

Sections viewed