• 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 and all isolation levels
  • optimizations:
    • predictive read-ahead for prefetching data from disk
    • adaptive hash index for in memory lookups
    • insert buffer to speed inserts