Features Removed in MySQL 8.0 ER_OBSOLETE_CANNOT_LOAD_FROM_TABLE ER_OBSOLETE_COL_COUNT_DOESNT_MATCH_CORRUPTED ER_ORDER_WITH_PROC ER_PARTITION_SUBPARTITION_ERROR ER_PARTITION_SUBPART_MIX_ERROR ER_PART_STATE_ERROR ER_PASSWD_LENGTH ER_QUERY_ON_MASTER ER_RBR_NOT_AVAILABLE ER_SKIPPING_LOGGED_TRANSACTION ER_SLAVE_CHANNEL_DELETE ER_SLAVE_MULTIPLE_CHANNELS_HOST_PORT ER_SLAVE_MUST_STOP ER_SLAVE_WAS_NOT_RUNNING ER_SLAVE_WAS_RUNNING ER_SP_GOTO_IN_HNDLR ER_SP_PROC_TABLE_CORRUPT ER_SQL_MODE_NO_EFFECT ER_SR_INVALID_CREATION_CTX ER_TABLE_NEEDS_UPG_PART ER_TOO_MUCH_AUTO_TIMESTAMP_COLS ER_UNEXPECTED_EOF ER_UNION_TABLES_IN_DIFFERENT_DIR ER_UNSUPPORTED_BY_REPLICATION_THREAD ER_UNUSED1 ER_UNUSED2 ER_UNUSED3 ER_UNUSED4 ER_UNUSED5 ER_UNUSED6 ER_VIEW_SELECT_DERIVED_UNUSED ER_WRONG_MAGIC ER_WSAS_FAILED •The deprecated  INFORMATION_SCHEMA INNODB_LOCKS  and  INNODB_LOCK_WAITS  tables are removed. Use the Performance Schema  data_locks  and  data_lock_waits  tables instead. Note In MySQL 5.7, the  LOCK_TABLE  column in the  INNODB_LOCKS  table and the locked_table  column in the  sys  schema  innodb_lock_waits  and  x $innodb_lock_waits  views contain combined schema/table name values. In MySQL 8.0, the  data_locks  table and the  sys  schema views contain separate schema name and table name columns. See Section 28.4.3.9, “The innodb_lock_waits and x$innodb_lock_waits Views” . • InnoDB  no longer supports compressed temporary tables. When  innodb_strict_mode  is enabled (the default),  CREATE TEMPORARY TABLE  returns an error if  ROW_FORMAT=COMPRESSED  or KEY_BLOCK_SIZE  is specified. If  innodb_strict_mode  is disabled, warnings are issued and the temporary table is created using a non-compressed row format. • InnoDB  no longer creates  .isl  files ( InnoDB  Symbolic Link files) when creating tablespace data files outside of the MySQL data directory. The  innodb_directories  option now supports locating tablespace files created outside of the data directory. With this change, moving a remote tablespace while the server is offline by manually modifying an  .isl  file is no longer supported. Moving remote tablespace files is now supported by the innodb_directories  option. See Section 15.6.3.6, “Moving Tablespace Files While the Server is Offline” . 49