14.2.3.12. InnoDB Temporary Table Undo Logs

MySQL 5.7.2 introduces a new type of undo log for both normal and compressed temporary tables and related objects. This new type of undo log resides in the temporary tablespace. The default temporary tablespace, ibtmp1, is located in the data directory. The new type of undo log is not a redo log, as temporary tables are not recovered during crash recovery and do not require redo logs. Temporary table undo logs are, however, required for rollback, MVCC, and purging while the server is running. This special type of non-redo undo log benefits performance by avoiding redo logging I/O for temporary tables and related objects.

With this change, 32 rollback segments are now reserved reserved for temporary table undo logs for transactions that modify temporary tables and related objects. This reduces the maximum number of rollback segments available for data-modifying transactions that generate undo records from 128 to 96, which reduces the limit on concurrent data-modifying transactions from 128K to 96K. For more information see Section 14.2.3.11, "InnoDB Multi-Versioning" and Section 14.2.7, "Limits on InnoDB Tables".