安装后如何在mysql中启用联合引擎? [英] How can I enable the federated engine in mysql after installation?

问题描述

我有 mysql 5.1.44:

<前>mysql> 显示引擎；+------------+------------+|发动机 |支持 |+------------+------------+|ndbcluster |否 ||MRG_MYISAM |是 ||黑洞 |是 ||CSV |是 ||内存 |是 ||联合 |否 ||存档 |是 ||InnoDB |是 ||我的ISAM |默认 |

我需要在 mysql 中启用联合引擎.我该怎么做?

解决方案

编辑 /etc/my.cnf 并在 [mysqld] 部分添加以下行:

联合

相当于在命令行指定--federated

I have mysql 5.1.44:

mysql> show engines;
+------------+---------+
| Engine     | Support | 
+------------+---------+
| ndbcluster | NO      | 
| MRG_MYISAM | YES     | 
| BLACKHOLE  | YES     | 
| CSV        | YES     | 
| MEMORY     | YES     | 
| FEDERATED  | NO      | 
| ARCHIVE    | YES     | 
| InnoDB     | YES     | 
| MyISAM     | DEFAULT |

I need to enable federated engine in mysql. How can I do it?

解决方案

Edit /etc/my.cnf and in the [mysqld] section, add the line:

federated

It's equivalent to specifying --federated on the command line

这篇关于安装后如何在mysql中启用联合引擎?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！