MongoDB集合重命名的完整指南

db.admincommand({
  renamecollection: "<source_db>.<source_collection>",
  to: "<target_db>.<target_collection>",
  droptarget: <boolean>,  // 可选
  staytemp: <boolean>     // 可选(4.4+)
})

// 基本语法
db.admincommand({
  renamecollection: "test.products_old",
  to: "test.products_new"
})

// 验证结果
use test
show collections

db.admincommand({
  renamecollection: "mytest_db.products",
  to: "mytest_db.products_new"
})

// 验证结果
show collections

// 跨数据库重命名
db.admincommand({
  renamecollection: "dev.users",
  to: "prod.customers"
})

// 强制覆盖目标集合
db.admincommand({
  renamecollection: "dev.logs",
  to: "prod.app_logs",
  droptarget: true
})

use admin
db.createrole({
  role: "collectionadmin",
  privileges: [
    {
      resource: { db: "", collection: "" },
      actions: ["renamecollection"]
    }
  ],
  roles: []
})

// 创建临时集合
db.temp_data.insertmany([...])

// 重命名并保留临时状态(4.4+)
db.admincommand({
  renamecollection: "test.temp_data",
  to: "test.final_data",
  staytemp: true
})

// 1. 检查oplog获取操作时间点
use local
db.oplog.rs.find({op: "c", ns: "admin.$cmd"}).sort({$natural: -1}).limit(1)

// 2. 执行反向重命名
db.admincommand({
  renamecollection: "test.new_name",
  to: "test.original_name",
  droptarget: true
})

// 好的命名
db.admincommand({renamecollection: "analytics.user_logs", to: "analytics.user_events"})

// 不好的命名
db.admincommand({renamecollection: "db1.col1", to: "db2.1234"})

# 监控集合重命名操作
mongotop -n 10
mongostat --discover -n 5