分类: Mysql/postgreSQL
2011-04-07 12:39:59
mysql> show variables like 'plugin_dir';
+---------------+-----------------------------------+
|
Variable_name |
Value
|
+---------------+-----------------------------------+
| plugin_dir | /usr/local/mysql/lib/mysql/plugin |
+---------------+-----------------------------------+
1 row in set (0.01 sec)
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 |
|
MEMORY | YES | Hash
based, stored in memory, useful for temporary tables |
NO |
NO | NO |
|
MyISAM | DEFAULT | Default engine as of MySQL
3.23 with great performance |
NO |
NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
4 rows in set (0.00 sec)
mysql>
mysql> INSTALL PLUGIN InnoDB SONAME 'ha_innodb.so';
Query OK, 0 rows affected (3.58 sec)
mysql> show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
|
Engine | Support |
Comment
| Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
|
InnoDB | YES | Supports
transactions, row-level locking, and foreign keys |
YES | YES |
YES |
|
CSV |
YES | CSV storage
engine
| NO |
NO | NO |
|
MRG_MYISAM | YES | Collection of identical
MyISAM
tables
| NO |
NO | NO |
|
MyISAM | DEFAULT | Default engine as of MySQL
3.23 with great performance |
NO |
NO | NO |
|
MEMORY | YES | Hash
based, stored in memory, useful for temporary tables |
NO |
NO | NO |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
5 rows in set (0.00 sec)