MySQL导入导出以及性能测试

在mysql的日志文件中有以下提示信息，该信息与federated引擎有关，就是在编译的时候加入了该选项，但是并没有在配置文件中加以启用，关于federated引擎，请参考mysql的官方参考文档。http://dev.mysql.com/doc/refman/5.1/zh/storage-engines.html#federated-storage-engine

[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了。MySQL从 5.1.26-rc 升级到 5.5.15详解MySQL的tee功能并利用其记录相关操作相关资讯 MySQL导入导出本文评论查看全部评论（0）