CREATE PROCEDURE drop_old_partition ()
BEGIN
SELECT CONCAT('ALTER TABLE zabbix.history DROP PARTITION ',
                         GROUP_CONCAT(PARTITION_NAME))
    INTO @sql
    FROM INFORMATION_SCHEMA.PARTITIONS
    WHERE TABLE_SCHEMA = 'zabbix'
      AND TABLE_NAME = 'history'
      AND (условие проверки диапазона дат партиции по её PARTITION_NAME или PARTITION_EXPRESSION);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DROP PREPARE stmt;
END