Chapter 7 Review

In this chapter, we have learned:

• The different types of storage engines
• How to specify a storage engine
• The characteristics of MyISAM tables.
• The different MyISAM table storage formats
• About InnoDB including:
  • Typical MyISAM table problems
  • How to configure InnoDB
  • InnoDB system variables
  • How to create an InnoDB table
  • How to use AUTO_INCREMENT with InnoDB
  • FOREIGN_KEY constraints
  • How to move an InnoDB database
  • Performance tuning tips
  • Table and index structure
  • How to defragment a table
  • Error handling
  • Restrictions on InnoDB tables
  • Troubleshooting

Let us go to chapter 8.

---

---

© 2007 John Michael Pierobon

Notes