MariaDB

  1. Bug #998130
  2. Comment #1

Comment 1 for bug 998130

Revision history for this message
Mclyn (mclyn-dimaculangan) wrote :

ALTER TABLE table_name
 REORGANIZE PARTITION current_partition INTO
 (PARTITION current_partition VALUES LESS THAN (18000000),
 PARTITION new_partition VALUES LESS THAN MAXVALUE);

Executing this query took us 2-3 minutes and INSERT or UPDATE on the table cannot be performed during the partitioning operation. Fixing this bug as soon as possible would help us decrease our application's downtime. Thanks!