General features
- hot backups
- replication
- indexes
- partitioning
- binary log – for replication and recovery
- procedures
- functions
- query profiling
MySQL versions:
- MySQL Oracle
- Percona – out of the box MySQL, you don’t need to tune my.cnf file
- MariaDB – default package in Linux distros
- WebScale – facebook version of MySQL for Big Data
Engines:
InnoDB
- Rollback
- Row-level locking
- Foreing keys
- Simple performans tuning
- Pool
- for OLTP
XtraDB
– All InnoDB funtions
– Out-of-box performance
– Most powerfull performance tuning
– Easy trouble shooting
MyISAM
– Non-Rollback
– Table-level locking
– Full-text search indexes
– Fast read
– Low-concurrency
– Without pool, cache of OS instead
– for OLAP apps
Maria
Memory
– RAM environment
– Non-trasactional
– Table-level locking
– No BLOB/TEXT data types
NDB
– Fast
– Transactional
– Row-level locking
– Well scale
CSV
Archive
– gzip
Blackhole
sources:
http://www.speedemy.com/