Everyone a great god, consult a mysql problem: we have a data statistics, the amount of data about 8 million + every day, we built the table partitioning by day, but to clean up the history table partition (drop partition) affects the insert of the new data, we also optimize the index, during eased, but still happens, like a drop table partition will lock the entire table, could you tell me this. What should I do?

CodePudding user response:

Suggest using mycat table depots