no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| — | percona_xtradb [2012/05/05 17:28] (current) – created - external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Percona XtraDB ====== | ||
| + | * [[Percona]] | ||
| + | |||
| + | * [[https:// | ||
| + | * [[http:// | ||
| + | |||
| + | Percona XtraDB is an enhanced version of InnoDB database engine. | ||
| + | |||
| + | InnoDB features: | ||
| + | |||
| + | * Default storage engine in MySQL 5.5 | ||
| + | * InnoDB recovers from a crash or other unexpected shutdown by replaying its logs | ||
| + | * InnoDB automatically groups together multiple concurrent inserts and flushes them to disk at the same time | ||
| + | * ACID compliant | ||
| + | * Transactional support: data integrity is guaranteed in the entire query process | ||
| + | * InnoDB uses row-level locking, as opposed to table locking in MyISAM. | ||
| + | * Full text search (same as MyISAM) | ||
| + | * Foreign key constraints | ||
| + | * Designed for high performance | ||
| + | * Hot backup: do a full backup while reads/ | ||
| + | * Updates are written to the log first, and then the changes are made to the database | ||
| + | |||
| + | XtraDB features: | ||
| + | |||
| + | * Backwards compatible with InnoDB | ||
| + | * Faster performance | ||
| + | * Better scalability | ||
| + | * Better tunability | ||
| + | * More statistics | ||
| + | * Improvements in handing multiple concurrent queries | ||
| + | * NoSQL support (experimental): | ||
| + | * Increased shutdown times | ||
| + | * Corrupted tables are disabled, instead of bringing down the database server | ||
| + | * Can export single tables (n/a in InnoDB) | ||
| + | * Buffer is saved during restarts | ||
| + | * Slow query logs in microseconds instead of in seconds | ||
| + | * Improved SHOW INNODB STATUS | ||
| + | * Improved SHOW PROCESSLIST | ||
