MySQL::Partition::Type::Range - subclass of MySQL::Partition for range partition
Subclass of MySQL::Partition for manipulating range partitions.
This class has extra constructor options and methods in other than base class.
catch_all_partition_name
Catch-all partition name for the statement like PARTITION pmax VALUES LESS THAN MAXVALUE. pmax is catch-all partition name in the above case.
PARTITION pmax VALUES LESS THAN MAXVALUE
pmax
$range_partition->add_catch_all_partition
Add catch all partition.
prepare_add_catch_all_partition method is also available.
prepare_add_catch_all_partition
$range_partition->reorganize_catch_all_partition
The MySQL table which have catch-all partition can't be added new partition. In this case, we can use ALTER TABLE REORGANIZE PARTITION ... and this method issuance and execute the SQL statements.
ALTER TABLE REORGANIZE PARTITION ...
prepare_reorganize_catch_all_partition method is also available.
prepare_reorganize_catch_all_partition
Copyright (C) Songmu.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Songmu <y.songmu@gmail.com>
To install MySQL::Partition, copy and paste the appropriate command in to your terminal.
cpanm
cpanm MySQL::Partition
CPAN shell
perl -MCPAN -e shell install MySQL::Partition
For more information on module installation, please visit the detailed CPAN module installation guide.