Description:
order of stages on the pae '8.14.3 General Thread States' is confused.
page:https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
the stages of thread are sorted alphabetically, which is clear to read. but the 'committing alter table to storage engine' is out of order.
following are some contents of this page:
Creating tmp table
The thread is creating a temporary table in memory or on disk. If the table is created in memory but later is converted to an on-disk table, the state during that operation is Copying to tmp table on disk.
committing alter table to storage engine
The server has finished an in-place ALTER TABLE and is committing the result.
deleting from main table
The server is executing the first part of a multiple-table delete. It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables.
How to repeat:
order of stages on the pae '8.14.3 General Thread States' is confused.
page:https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
the stages of thread are sorted alphabetically, which is clear to read. but the 'committing alter table to storage engine' is out of order.
following are some contents of this page:
Creating tmp table
The thread is creating a temporary table in memory or on disk. If the table is created in memory but later is converted to an on-disk table, the state during that operation is Copying to tmp table on disk.
committing alter table to storage engine
The server has finished an in-place ALTER TABLE and is committing the result.
deleting from main table
The server is executing the first part of a multiple-table delete. It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables.
