系统运维

用MySQL实现类似于Oracle dblink的功能

时间:2010-12-5 17:23:32  作者:IT科技类资讯   来源:域名  查看:  评论:0
内容摘要:复制mysql>showengines; +--------------------+---------+---------------------------------

用MySQL实现类似于Oracle dblink的功能
复制mysql> show engines;   +--------------------+---------+------------------------------------------------------------+--------------+-----+------------+ | Engine             | Support | Comment                                                    | Transactions | XA  | Savepoints |  +--------------------+---------+------------------------------------------------------------+--------------+-----+------------+ | InnoDB             | DEFAULT | Supports transactions,用M于 row-level locking, andforeign keys | YES          | YES | YES        |  | PERFORMANCE_SCHEMA | YES     | Performance Schema                                         | NO           | NO  | NO         |  | CSV                | YES     | CSV storage engine                                         | NO           | NO  | NO         |  | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                      | NO           | NO  | NO         |  | MyISAM             | YES     | MyISAM storage engine                                      | NO           | NO  | NO         |  | MEMORY             | YES     | Hash based, stored in memory, useful fortemporary tables  | NO           | NO  | NO         |  +--------------------+---------+------------------------------------------------------------+--------------+-----+------------+ 6 rowsinset  1.2.3.4.5.6.7.8.9.10.11.12.
最近更新
热门排行
copyright © 2025 powered by 编程之道  滇ICP备2023006006号-34sitemap