Page History
...
Oracle supports an unbounded number of (sub)-partitions and allows for automatic allocation of new partitions as required. It has more partition types than MySQL and is more generous with the possible combinations of partitions and sub-partitions.
Partitioning Strategy - MySQL:
Because of the limit of 1024 partitions, we settled on partitioning by Time (2 weeks, per) and then by Event Class (1, 2, 3.) This will allow for 15 years of operation. Only the first 2 years of partitions (156 total) were initially created for testing.
Partitioning Strategy - Oracle:
Data is partitioned by Time (1 week, per) and then by HTMID in 32 sub-partitions (1024 HTM regions per partition.) A single partition is intially allocated with a template for Oracle to create future partitions.
The HTMID partitions represent contiguous areas of the sky so that spatial queries can potentially be satisfied by a few partitions. Seth Digel was kind enough to generate the following plot: 