mysql federated 腾讯_MySQL FEDERATED 提示
在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了。
本文转自茄子_2008博客园博客，原文链接：http://www.cnblogs.com/xd502djj/archive/2013/05/13/3075383.html，如需转载请自行联系原作者。
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！