Aug
14
MySQL Plugin 'FEDERATED' is disabled 错误
140814 12:44:59 mysqld_safe Starting mysqld daemon with databases from /home/mysql2015/data
2014-08-14 12:45:00 7642 [Note] Plugin 'FEDERATED' is disabled.
2014-08-14 12:45:00 7642 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-14 12:45:00 7642 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-14 12:45:00 7642 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-14 12:45:00 7642 [Note] InnoDB: Memory barrier is not used
2014-08-14 12:45:00 7642 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-14 12:45:00 7642 [Note] InnoDB: Using Linux native AIO
2014-08-14 12:45:00 7642 [Note] InnoDB: Using CPU crc32 instructions
2014-08-14 12:45:00 7642 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2014-08-14 12:45:00 7642 [Note] InnoDB: Completed initialization of buffer pool
2014-08-14 12:45:00 7642 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-14 12:45:00 7642 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-14 12:45:00 7642 [Note] InnoDB: Waiting for purge to start
2014-08-14 12:45:00 7642 [Note] InnoDB: 5.6.20 started; log sequence number 1626018
2014-08-14 12:45:00 7642 [Note] RSA private key file not found: /home/mysql2015/data//private_key.pem. Some authentication plugins will not work.
2014-08-14 12:45:00 7642 [Note] RSA public key file not found: /home/mysql2015/data//public_key.pem. Some authentication plugins will not work.
2014-08-14 12:45:00 7642 [Note] Server hostname (bind-address): '0.0.0.0'; port: 2015
2014-08-14 12:45:00 7642 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2014-08-14 12:45:00 7642 [Note] Server socket created on IP: '0.0.0.0'.
2014-08-14 12:45:00 7642 [Note] Event Scheduler: Loaded 0 events
2014-08-14 12:45:00 7642 [Note] /usr/local/webserver/mysql2015/bin/mysqld: ready for connections.
Version: '5.6.20-log' socket: '/tmp/mysql2015.sock' port: 2015 Source distribution
解决办法:
vi my.cnf
在[mysqld]下面加一行
federated
再次启动就可以看见FEDERATED引擎已经正常加载了。
注意:请确认你cmake编译的时候把-DWITH_FEDERATED_STORAGE_ENGINE=1加进去了。
2014-08-14 12:45:00 7642 [Note] Plugin 'FEDERATED' is disabled.
2014-08-14 12:45:00 7642 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-14 12:45:00 7642 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-14 12:45:00 7642 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-14 12:45:00 7642 [Note] InnoDB: Memory barrier is not used
2014-08-14 12:45:00 7642 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-14 12:45:00 7642 [Note] InnoDB: Using Linux native AIO
2014-08-14 12:45:00 7642 [Note] InnoDB: Using CPU crc32 instructions
2014-08-14 12:45:00 7642 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2014-08-14 12:45:00 7642 [Note] InnoDB: Completed initialization of buffer pool
2014-08-14 12:45:00 7642 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-14 12:45:00 7642 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-14 12:45:00 7642 [Note] InnoDB: Waiting for purge to start
2014-08-14 12:45:00 7642 [Note] InnoDB: 5.6.20 started; log sequence number 1626018
2014-08-14 12:45:00 7642 [Note] RSA private key file not found: /home/mysql2015/data//private_key.pem. Some authentication plugins will not work.
2014-08-14 12:45:00 7642 [Note] RSA public key file not found: /home/mysql2015/data//public_key.pem. Some authentication plugins will not work.
2014-08-14 12:45:00 7642 [Note] Server hostname (bind-address): '0.0.0.0'; port: 2015
2014-08-14 12:45:00 7642 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2014-08-14 12:45:00 7642 [Note] Server socket created on IP: '0.0.0.0'.
2014-08-14 12:45:00 7642 [Note] Event Scheduler: Loaded 0 events
2014-08-14 12:45:00 7642 [Note] /usr/local/webserver/mysql2015/bin/mysqld: ready for connections.
Version: '5.6.20-log' socket: '/tmp/mysql2015.sock' port: 2015 Source distribution
解决办法:
vi my.cnf
在[mysqld]下面加一行
federated
再次启动就可以看见FEDERATED引擎已经正常加载了。
注意:请确认你cmake编译的时候把-DWITH_FEDERATED_STORAGE_ENGINE=1加进去了。