Linux technical support - support@alexlinux.com


mysql features

General features

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/

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>