MySQL FEDERATED 提示
在mysql的日志文件中有以下提示信息，该信息与federated引擎有关，就是在编译的时候加入了该选项，但是并没有在配置文件中加以启用，关于federated引擎，请参考mysql的官方参考文档。http://dev.mysql.com/doc/refman/5.1/zh/storage-engines.html#federated-storage-engine
# grep -i fed /home/mysql/data/10_ccs.err
[*]120814 13:50:42 Plugin 'FEDERATED' is disabled.
[*]120814 13:53:49 Plugin 'FEDERATED' is disabled.
[*]120814 14:42:52 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的启动配置文件中添加选项：
# vim /usr/local/mysql5/etc/innodb.cnf
[*]
[*]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了。
页:
[1]