Bug #72348 | Please allow rebuild partition to work on multiple partitions at once | ||
---|---|---|---|
Submitted: | 15 Apr 2014 6:13 | Modified: | 19 Apr 2014 7:46 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S4 (Feature request) |
Version: | 5.6.15 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[15 Apr 2014 6:13]
Simon Mudd
[16 Apr 2014 9:11]
MySQL Verification Team
Hello Simon, Thank you for the feature request! Thanks, Umesh
[16 Apr 2014 9:15]
MySQL Verification Team
btw, rebuilding of >1 partitions can also be done using: ALTER TABLE `mytable` REBUILD PARTITION p0,p1,p2; https://dev.mysql.com/doc/refman/5.6/en/partitioning-maintenance.html
[19 Apr 2014 7:46]
Simon Mudd
Thanks for the pointer, but given it does not say otherwise I would expect that to work sequentially. My feature request is to allow this process to happen in parallel which enables I/O to be used better. Another thing with such partition commands is that it is not clear to me how this process may be buffered, as it may not be convenient to fetch data into the InnoDB buffer pool thus purging out other valuable data prior to writing back out to disk again. Some buffering is no doubt needed but I probably need to see if this process has this potentially undesirable affect of purging out a lot of existing data, or only buffers what is strictly necessary to allow "streaming" of data in from the old partition prior to streaming out to the new one.