Bug #83434 Select statement with partition selection against MyISAM table opens all partiti
| Submitted: | 19 Oct 2016 0:35 | Modified: | 19 Oct 2016 7:20 |
|---|---|---|---|
| Reporter: | Geoff Montee | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
| Version: | 5.6.30 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[19 Oct 2016 0:35]
Geoff Montee
[19 Oct 2016 7:20]
MySQL Verification Team
Hello Geoff Montee, Thank you for the report. Imho this expected behavior and is duplicate of your earlier Bug #75753 which was later marked as duplicate of Bug #64498. Let me re-quote which was explained nicely by Mattias Jonsson in Bug #64498 "This is a design limitation, MyISAM have one file handle open for the .MYI file shared by all instances of one table, and one file handle open for each table instance for the .MYD file. And the ha_partition generic partitioning engine always open all partitions when opening a table/handler".. more details in #64498 As part of Bug#64498, documentation has been updated now in http://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations.html Thanks, Umesh
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.