Melvin's digital garden

MySQL training by Iris

** storage

  • memory engine
  • archive engine ** explain ** indices
  • fulltext
  • hash ** filtering
  • order by null ** partitioning
  • column must be in primary key
  • explain partitions ** PG -> MySQL
  • PG replication take care of by master. If replication broke, can’t write to master
  • better docs/support ** RDS
  • use archiver does not work for load data from file

Links to this note