Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL)
Description
is_file_on_ssd() on Windows uses a cache to avoid repeated checks whether a given volume is on SSD.
However, it still uses GetVolumePathName() to retrieve volume for any given file.
GetVolumePathName() appears to be expensive, procmon shows that internally it opens every directory in the hierarchy, probably to check whether directory is a symlink.
This can be improved by using volume serial ID as cache key instead, it is cheap to retrieve it for an open file.
Attachments
Issue Links
- relates to
-
MDEV-32027 Opening all .ibd files on InnoDB startup can be slow
- Closed