Bug #115122 Unneeded full table scan, although there is an index and condition
Submitted: 25 May 2024 11:17 Modified: 16 Jun 2024 9:10
Reporter: Ahmed Wahba Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:8.4 (Latest), 8.0.37 OS:Ubuntu (22.04 LTS)
Assigned to: CPU Architecture:ARM
Tags: nested query, performance, regression

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:

[25 May 2024 11:22] Ahmed Wahba
SQL script to create schema

Attachment: 01.schema.sql (application/octet-stream, text), 1.45 KiB.

[25 May 2024 11:24] Ahmed Wahba
Python script to fill the tables with 5M rows (takes time)

Attachment: generator.py (text/x-python), 3.02 KiB.

[25 May 2024 11:48] Ahmed Wahba
test_db part 1

Attachment: backup.sql.zstaa (application/octet-stream, text), 47.68 MiB.

[25 May 2024 11:51] Ahmed Wahba
test_db part 2

Attachment: backup.sql.zstab (application/octet-stream, text), 43.52 MiB.