Description:
I notice on a server with a lot of tables the following logging:
2023-10-16T11:23:10.449815Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2023-10-16T11:23:10.449874Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2023-10-16T11:23:20.450087Z 1 [Note] [MY-012205] [InnoDB] Files found so far: 143517 data files and 2 undo files
2023-10-16T11:23:23.172801Z 1 [Note] [MY-012206] [InnoDB] Found 209614 '.ibd' and 2 undo files
2023-10-16T11:23:23.172931Z 1 [Note] [MY-012207] [InnoDB] Using 17 threads to scan 209614 tablespace files
...
2023-10-16T11:28:03.651495Z 0 [Note] [MY-012200] [InnoDB] Thread# 11 - Checked 10366/13100 files
2023-10-16T11:28:03.677146Z 0 [Note] [MY-012200] [InnoDB] Thread# 12 - Checked 8053/13100 files
2023-10-16T11:28:03.719000Z 0 [Note] [MY-012200] [InnoDB] Thread# 14 - Checked 8060/13100 files
2023-10-16T11:28:03.752935Z 0 [Note] [MY-012200] [InnoDB] Thread# 15 - Checked 7884/13100 files
2023-10-16T11:28:09.859840Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:13.519235Z 0 [Note] [MY-012200] [InnoDB] Thread# 5 - Checked 12810/13100 files
2023-10-16T11:28:13.530642Z 0 [Note] [MY-012200] [InnoDB] Thread# 1 - Checked 13019/13100 files
2023-10-16T11:28:13.530862Z 0 [Note] [MY-012200] [InnoDB] Thread# 4 - Checked 12759/13100 files
2023-10-16T11:28:13.542559Z 0 [Note] [MY-012200] [InnoDB] Thread# 3 - Checked 12475/13100 files
2023-10-16T11:28:13.554173Z 0 [Note] [MY-012200] [InnoDB] Thread# 6 - Checked 12741/13100 files
2023-10-16T11:28:13.576451Z 0 [Note] [MY-012200] [InnoDB] Thread# 10 - Checked 12728/13100 files
2023-10-16T11:28:13.604528Z 0 [Note] [MY-012200] [InnoDB] Thread# 2 - Checked 12367/13100 files
2023-10-16T11:28:13.604584Z 0 [Note] [MY-012200] [InnoDB] Thread# 0 - Checked 12792/13100 files
2023-10-16T11:28:13.619150Z 0 [Note] [MY-012200] [InnoDB] Thread# 7 - Checked 12539/13100 files
2023-10-16T11:28:13.639663Z 0 [Note] [MY-012200] [InnoDB] Thread# 13 - Checked 8241/13100 files
2023-10-16T11:28:13.663871Z 0 [Note] [MY-012200] [InnoDB] Thread# 11 - Checked 10815/13100 files
2023-10-16T11:28:13.700102Z 0 [Note] [MY-012200] [InnoDB] Thread# 12 - Checked 8387/13100 files
2023-10-16T11:28:13.734901Z 0 [Note] [MY-012200] [InnoDB] Thread# 14 - Checked 8388/13100 files
2023-10-16T11:28:13.789292Z 0 [Note] [MY-012200] [InnoDB] Thread# 15 - Checked 8223/13100 files
2023-10-16T11:28:14.894744Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:19.257158Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:19.537247Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:20.048859Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:20.615618Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:20.961484Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:21.781667Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:22.618680Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:23.607299Z 0 [Note] [MY-012200] [InnoDB] Thread# 2 - Checked 13086/13100 files
2023-10-16T11:28:23.649186Z 0 [Note] [MY-012200] [InnoDB] Thread# 13 - Checked 8717/13100 files
2023-10-16T11:28:23.669689Z 0 [Note] [MY-012200] [InnoDB] Thread# 11 - Checked 11563/13100 files
2023-10-16T11:28:23.695421Z 0 [Note] [MY-012201] [InnoDB] Checked 13100 files
2023-10-16T11:28:23.700375Z 0 [Note] [MY-012200] [InnoDB] Thread# 12 - Checked 8879/13100 files
2023-10-16T11:28:23.738427Z 0 [Note] [MY-012200] [InnoDB] Thread# 14 - Checked 8863/13100 files
...
2023-10-16T11:28:54.172426Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 209616 files.
How to repeat:
This system had 200k tables. So create a similar one with data and rerun the start up and see the message.
Suggested fix:
I think the Thread# XX - should also be included in the lines when each thread has completed checking all its files. Otherwise the logging looks confusing and is inconsistent.
