| Bug #96311 | ST_Intersects() is very slow on MySQL 8.0 | ||
|---|---|---|---|
| Submitted: | 24 Jul 2019 9:02 | Modified: | 19 Feb 2020 17:38 |
| Reporter: | Yoshiaki Yamasaki | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: GIS | Severity: | S5 (Performance) |
| Version: | 8.0.17 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | gis | ||
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:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix> - On windows use WinZip or a similar utility to split the large file
[24 Jul 2019 9:42]
Yoshiaki Yamasaki
[24 Jul 2019 9:43]
Yoshiaki Yamasaki
dump file (2/4)
Attachment: dump.ab (application/octet-stream, text), 2.86 MiB.
[24 Jul 2019 9:43]
Yoshiaki Yamasaki
dump file (3/4)
Attachment: dump.ac (application/octet-stream, text), 2.86 MiB.
[24 Jul 2019 9:44]
Yoshiaki Yamasaki
dump file (4/4)
Attachment: dump.ad (application/octet-stream, text), 1.03 MiB.
[24 Jul 2019 10:38]
Yoshiaki Yamasaki
Test result on MySQL 8.0.17
Attachment: test_result_8.0.txt (text/plain), 12.00 KiB.
[24 Jul 2019 10:38]
Yoshiaki Yamasaki
Test result on MySQL 5.7.27
Attachment: test_result_5.7.txt (text/plain), 12.09 KiB.
[25 Jul 2019 6:27]
Umesh Shastry
Test results - 8.0.17
Attachment: 96311_8.0.17.results (application/octet-stream, text), 19.66 KiB.
[25 Jul 2019 9:58]
Umesh Shastry
Test results - 5.7.27
Attachment: 96311_5.7.27.results (application/octet-stream, text), 18.03 KiB.
