Bug #111538 MySQL 8.0.33 is slower than MySQL 8.0.28 with queries using JOINS
Submitted: 23 Jun 2023 0:17 Modified: 23 Jun 2023 11:44
Reporter: Marcos Albe (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S5 (Performance)
Version:8.0.33 OS:Any
Assigned to: CPU Architecture:Any
Tags: performance degradation

File: Maximum allowed size is 50MB.

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:

[23 Jun 2023 0:53] Marcos Albe
Run on employees database

Attachment: repro.sql (application/octet-stream, text), 1.74 KiB.

[23 Jun 2023 1:05] Marcos Albe
Flamegraph for 8.0.28

Attachment: 8.0.28.markus.svg (image/svg+xml, text), 59.48 KiB.

[23 Jun 2023 1:05] Marcos Albe
Flamegraph for 8.0.33

Attachment: 8.0.33.markus.svg (image/svg+xml, text), 65.53 KiB.

[24 Nov 2023 21:25] Zongzhi Chen

Attachment: baotiao.diff (application/octet-stream, text), 21.02 KiB.

[5 Jun 14:43] ANIL JOSHI
MySQL 8 performance test in different versions

Attachment: MySQL Benchmark test (application/octet-stream, text), 7.75 KiB.