Guest User

Untitled

a guest
May 9th, 2013
417
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> show engines;
  2. +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  3. | Engine | Support | Comment | Transactions | XA | Savepoints |
  4. +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  5. | MyISAM | YES | MyISAM storage engine | NO | NO | NO |
  6. | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
  7. | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
  8. | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
  9. | CSV | YES | CSV storage engine | NO | NO | NO |
  10. | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
  11. | ARCHIVE | YES | Archive storage engine | NO | NO | NO |
  12. | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
  13. | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
  14. +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
RAW Paste Data