在MySQL的日志文件中有以下提示信息,该信息与federated引擎有关,就是在编译的时候加入了该选项,但是并没有在配置文件中加以启用,关于federated引擎,请参考mysql的官方参考文档。
[root@170_DDB ~]# grep -i fed /home/mysql/data/10_ccs.err
120814 13:50:42 [Note] Plugin 'FEDERATED' is disabled.
120814 13:53:49 [Note] Plugin 'FEDERATED' is disabled.
120814 14:42:52 [Note] Plugin 'FEDERATED' is disabled.
同时mysql中运行show engines显示信息如下:
mysql>show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.01 sec)
在mysql的启动配置文件中添加选项:
[root@170_DDB ~]# vim /usr/local/mysql5/etc/innodb.cnf
[mysqld]
federated
重启mysql,再次查看日志,该提示信息不再出现
再次运行show engines显示信息如下:
mysql>show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| FEDERATED | YES | Federated MySQL storage engine | NO | NO | NO |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.00 sec)
从上面的信息中可以看出:已经可以支持FEDERATED了。