FEDERATED engine – small notes

allow it by adding into /etc/mysql/my.cnf: [mysqld] federated restart mysql 🙂 using “sudo service mysql restart” about federated tables: if you want to create only one or two tables per remote server use just CREATE TABLE with login credentials in...

Memory

very similar to MyISAM engine creates tables only in memory, no I/O operations are done usefull for: masivelly used config data, list of values etc. caching results from periodical queries intermediate results from data analysis has HASH indexes table locking only...

MyISAM

default in 5.1 or older main features: full-text indexing compression GIS spacial functions does NOT have transactions or row-level locking typically stores data in 2 files – data file, index file tables can have rows both with fixed or dynamic length size of...

InnoDB

default engine, designed for many short-lived transactions which are usually completed can store data in: tablespace (one or more files with special format for all data – as in Oracle) separate files – every table and every index in separate file uses MCVV...