Bug #96340 Slow startup for mysql 8.0 with many tables due to the tablespace files scan
Submitted: 26 Jul 2019 12:13 Modified: 27 Nov 2019 19:25
Reporter: lalit Choudhary Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.17 OS:Any
Assigned to: CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[26 Jul 2019 12:14] lalit Choudhary
mysql8 startup log

Attachment: mysql8_slow_startup.log (text/x-log), 11.54 KiB.

[29 Jul 2019 11:25] Umesh Shastry
Debian10 VM results

Attachment: 96340_8.0.17_vm.results (application/octet-stream, text), 9.16 KiB.

[13 Aug 2019 18:28] Sergiu Hlihor
Actual production log

Attachment: Production.log (text/x-log), 22.58 KiB.

[20 Aug 2019 17:03] Sunny Bains
Proposed patch

Attachment: scan.diff (application/octet-stream, text), 5.63 KiB.