A MySQL table partition management method, device and medium

Abstract

The application discloses a MySQL table partition management method and device and medium, and belongs to the technical field of database optimization, and is used for solving the technical problem that the existing MySQL table static configuration does not match dynamic data, which easily leads to increased operation and maintenance cost and poor resource utilization. The method comprises the following steps: performing multi-modal calculation on the real-time data characteristics in the MySQL table to obtain multi-modal characteristics; performing time series prediction processing on the multi-modal characteristics to output expansion demand data; processing the dynamic partition strategy gene related to the decision space of the expansion demand data through an intelligent decision engine to generate a new partition key; and performing rolling migration of cold and hot data in the MySQL table according to the new partition corresponding to the new partition key to obtain a partition management result of the MySQL table.

Images