mysql5.1新特性--编译源码安装的变化

mysql5.1不像之前的版本,缺省情况下是不支持innodb的,

 --with-plugins=PLUGIN[,PLUGIN..]
                          Plugins to include in mysqld. (default is: none)
                          Must be a configuration name or a comma separated
                          list of plugins.
                          Available configurations are: none max max-no-ndb
                          all.
                          Available plugins are: partition daemon_example
                          ftexample archive blackhole csv example federated
                          heap innobase myisam myisammrg ndbcluster.

 

必须用--with-plugins选项指定将哪些插件链接进mysqld

并且,测试中发现--with-plugins=all不会将ndbcluster链接进来,需要用max或者明确将ndbcluster包含进来.

 

指定为all

mysql> show variables like '%have%';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| have_community_features | NO    |
| have_compress           | YES   |
| have_crypt              | YES   |
| have_csv                | YES   |
| have_dynamic_loading    | NO    |
| have_geometry           | YES   |
| have_innodb             | YES   |
| have_ndbcluster         | NO    |
| have_openssl            | NO    |
| have_partitioning       | YES   |
| have_query_cache        | YES   |
| have_rtree_keys         | YES   |
| have_ssl                | NO    |
| have_symlink            | YES   |
+-------------------------+-------+