Bug #89551 Spatial index query time performance scales linearly
| Submitted: | 6 Feb 2018 9:27 | Modified: | 6 Feb 2018 13:05 |
|---|---|---|---|
| Reporter: | Sveta Smirnova (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.7.21, 8.0.4 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[6 Feb 2018 9:27]
Sveta Smirnova
[6 Feb 2018 9:28]
Sveta Smirnova
Test queries
Attachment: sp_queries.sql (application/sql, text), 22.59 KiB.
[6 Feb 2018 9:28]
Sveta Smirnova
Results on my machine
Attachment: sp_queries_result_upstream_5721.txt (text/plain), 26.70 KiB.
[6 Feb 2018 10:42]
MySQL Verification Team
Hello Sveta, Thank you for the report. I see you have uploaded 2 files sp_bug.sql.gz(this is corrupted as extract fails) and mysql-bug-89551.sql.gz(download in progress as it is in GBs). Could you please confirm which is the correct dump file? Thank you! Regards, Umesh
[6 Feb 2018 10:44]
Sveta Smirnova
mysql-bug-89551.sql.gz is the correct one.
[6 Feb 2018 13:05]
MySQL Verification Team
Thank you, Sveta. Thanks, Umesh
[6 Feb 2018 13:06]
MySQL Verification Team
test results - 5.7.21
Attachment: 89551_5.7.21.results (application/octet-stream, text), 28.43 KiB.
[12 Feb 2020 14:10]
Patrick van Dijk
How can this have severity S3 (non-critical). Any app trying to render and use MBRIntersects is useless. This should be treated S1
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.