原创

mongodb重命名和创建索引

重命名集合，需要再主库上执行

db.adminCommand({
  renameCollection: "dfs-tm-obs.AgentMeasurementV2",
  to: "dfs-tm-obs.AgentMeasurementV2_backup20250905",
  dropTarget: true
})

给新生成的集合加索引

db.getCollection("AgentMeasurementV2").createIndex({"grnty":1,"tags.taskId":1,"tags.type":1,"tags.taskIdRecordId":1,"tags.table":1}, {"name":"grnty_1_tags.taskId_1_tags.type_1_tags.taskIdRecordId_1_tags.table_1"})
db.getCollection("AgentMeasurementV2").createIndex({"grnty":1,"tags.taskId":1,"tags.type":1,"tags.taskIdRecordId":1,"tags.nodeId":1}, {"name":"grnty_1_tags.taskId_1_tags.type_1_tags.taskIdRecordId_1_tags.nodeId_1"})
db.getCollection("AgentMeasurementV2").createIndex({"grnty":1,"tags.engineId":1,"tags.type":1}, {"name":"grnty_1_tags.engineId_1_tags.type_1"})
db.getCollection("AgentMeasurementV2").createIndex({"date":-1}, {"name":"date_-1","expireAfterSeconds":{"low":604800,"high":0,"unsigned":false}})
db.getCollection("AgentMeasurementV2").createIndex({"tags.taskId":1,"grnty":1,"tags.type":1}, {"name":"tags.taskId_1_grnty_1_tags.type_1"})
db.getCollection("AgentMeasurementV2").createIndex({"date":-1,"tags.taskRecordId":1,"tags.type":1,"tags.nodeType":1,"tags.nodeId":1,"tags.taskId":1,"grnty":1}, {"name":"date_-1_tags.taskRecordId_1_tags.type_1_tags.nodeType_1_tags.nodeId_1_tags.taskId_1_grnty_1"})
db.getCollection("AgentMeasurementV2").createIndex({"tags.taskId":1,"grnty":1,"tags.type":1,"tags.taskRecordId":1}, {"name":"tags.taskId_1_grnty_1_tags.type_1_tags.taskRecordId_1"})
db.getCollection("AgentMeasurementV2").createIndex({"tags.taskId":1}, {"name":"tags.taskId_1"})
db.getCollection("AgentMeasurementV2").createIndex({"tags.taskId":1,"grnty":1,"tags.type":1,"tags.taskRecordId":1,"_id":1}, {"name":"tags.taskId_1_grnty_1_tags.type_1_tags.taskRecordId_1__id_1"})
db.getCollection("AgentMeasurementV2").createIndex({"tags.taskId":1,"grnty":1,"tags.type":1,"date":1}, {"name":"tags.taskId_1_grnty_1_tags.type_1_date_1"})

正文到此结束