在mysql中实现消息队列表的最佳方法是什么

CREATE TABLE `message_queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `status` enum('Pending','Processing','Completed') NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

DELIMITER //
CREATE TRIGGER `insert_message` AFTER INSERT ON `message_queue`
FOR EACH ROW
BEGIN
  UPDATE `message_queue` SET `status` = 'Pending' WHERE `id` = NEW.id;
END;
//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `process_message`(IN `message_id` INT)
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE msg_id INT;
  
  DECLARE cur CURSOR FOR SELECT id FROM `message_queue` WHERE status = 'Pending' FOR UPDATE;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

  START TRANSACTION;

  OPEN cur;

  read_loop: LOOP
    FETCH cur INTO msg_id;
    IF done THEN
      LEAVE read_loop;
    END IF;

    UPDATE `message_queue` SET `status` = 'Processing' WHERE `id` = msg_id;
    -- 在这里处理消息，例如调用其他函数或存储过程
    UPDATE `message_queue` SET `status` = 'Completed' WHERE `id` = msg_id;

  END LOOP;

  CLOSE cur;

  COMMIT;
END;
//
DELIMITER ;

DELIMITER //
CREATE EVENT `process_message_event`
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
  CALL `process_message`(1);
END;
//
DELIMITER ;