See Also FULLTEXT index, search index.  A component of the MySQL database that performs the low-level work of storing, updating, and querying data. In MySQL 5.5 and higher,  InnoDB  is the default storage engine for new tables, superceding  MyISAM . Different storage engines are designed with different tradeoffs between factors such as memory usage versus disk usage, read speed versus write speed, and speed versus robustness. Each storage engine manages specific tables, so we refer to  InnoDB  tables,  MyISAM  tables, and so on.  A column whose values are computed from an expression included in the column definition. Column values are evaluated and stored when rows are inserted or updated. A stored generated column requires storage space and can be indexed.  A stored program or view.  A stored routine (procedure or function), trigger, or Event Scheduler event.  A stored procedure or function.  The general name for the setting controlled by the  innodb_strict_mode  option. Turning on this setting causes certain conditions that are normally treated as warnings, to be considered errors. For example, certain invalid combinations of options related to  file format  and  row format , that normally produce a warning and continue with default values, now cause the  CREATE TABLE  operation to fail.  innodb_strict_mode  is enabled by default in MySQL 5.7. MySQL also has something called strict mode. See Section 5.1.11, “Server SQL Modes” . See Also file format, innodb_strict_mode, row format.  Within the list structure that represents the  buffer pool , pages that are relatively old and relatively new are represented by different portions of the  list . A set of parameters control the size of these portions and the dividing point between the new and old pages. See Also buffer pool, eviction, list, LRU.  A  pseudo-record  in an index, representing the  gap  above the largest value in that index. If a transaction has a statement such as  SELECT ... FROM ... WHERE col > 10 FOR UPDATE; , and the largest value in the column is 20, it is a lock on the supremum record that prevents other transactions from inserting even larger values such as 50, 100, and so on. See Also gap, infimum record, pseudo-record. See Also synthetic key.  Synonym name for  synthetic key . Contrast with  virtual generated column . See Also base column, generated column, virtual generated column. The  MySQL Enterprise Backup  product is optimized for backing up  InnoDB  tables. It can also back up tables handled by  MyISAM  and other storage engines. See Also InnoDB, MySQL Enterprise Backup, table type. storage engine stored generated column stored object stored program stored routine strict mode sublist supremum record surrogate key 6190