Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The row count is not updated in time during adding index #43102

Closed
tangenta opened this issue Apr 17, 2023 · 0 comments · Fixed by #43103
Closed

The row count is not updated in time during adding index #43102

tangenta opened this issue Apr 17, 2023 · 0 comments · Fixed by #43103

Comments

@tangenta
Copy link
Contributor

Enhancement

#42769 sets the flush interval to 10 minutes, which makes the ROW_COUNT field from admin show ddl jobs zero.

mysql> admin show ddl jobs 1;
+--------+---------+------------+------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+---------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE               | SCHEMA_STATE         | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME         | START_TIME          | END_TIME            | STATE   |
+--------+---------+------------+------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+---------+
|    138 | sbtest  | sbtest1    | add index /* ingest */ | write reorganization |        88 |       90 |         0 | 2023-04-17 20:08:17 | 2023-04-17 20:08:17 | NULL                | running |
+--------+---------+------------+------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+---------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant