/*  显示引擎信息*/mysql> show engines;+------------+---------+------------------------------------------------------------+--------------+------+------------+| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |+------------+---------+------------------------------------------------------------+--------------+------+------------+| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         || CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         || MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         || InnoDB     | YES     | 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         |+------------+---------+------------------------------------------------------------+--------------+------+------------+/*    显示插件信息*/mysql> show plugins;+------------+--------+----------------+---------+---------+| Name       | Status | Type           | Library | License |+------------+--------+----------------+---------+---------+| binlog     | ACTIVE | STORAGE ENGINE | NULL    | GPL     || partition  | ACTIVE | STORAGE ENGINE | NULL    | GPL     || CSV        | ACTIVE | STORAGE ENGINE | NULL    | GPL     || MEMORY     | ACTIVE | STORAGE ENGINE | NULL    | GPL     || InnoDB     | ACTIVE | STORAGE ENGINE | NULL    | GPL     || MyISAM     | ACTIVE | STORAGE ENGINE | NULL    | GPL     || MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL    | GPL     |+------------+--------+----------------+---------+---------+/* */mysql> show variables like "have_%";+-------------------------+----------+| Variable_name           | Value    |+-------------------------+----------+| have_community_features | YES      || have_compress           | YES      || have_crypt              | YES      || have_csv                | YES      || have_dynamic_loading    | YES      || have_geometry           | YES      || have_innodb             | YES      || have_ndbcluster         | NO       || have_openssl            | DISABLED || have_partitioning       | YES      || have_query_cache        | YES      || have_rtree_keys         | YES      || have_ssl                | DISABLED || have_symlink            | DISABLED |+-------------------------+----------+注:  主要是说明have_dynamic_loading 是否为yes, 如果是,意味着可以动态的加载插件./*   centos 上查询mysql的安装目录, 主要是想找到mysql的插件存放的目录.*/[zhang@localhost /]$ rpm -ql  mysql/usr/bin/msql2mysql/usr/bin/my_print_defaults/usr/bin/mysql/usr/bin/mysql_config/usr/bin/mysql_find_rows/usr/bin/mysql_waitpid/usr/bin/mysqlaccess/usr/bin/mysqladmin/usr/bin/mysqlbinlog/usr/bin/mysqlcheck/usr/bin/mysqldump/usr/bin/mysqlimport/usr/bin/mysqlshow/usr/bin/mysqlslap/usr/lib/mysql/mysql_config/usr/lib/mysql/mysqlbug