Recipes
undefined
Oracle
- Redo log switch (switch the current log file)Redo & Archive
- Add a new redo log groupRedo & Archive
- Resize a redo log group (drop + add)Redo & Archive
- Put the database in ARCHIVELOG modeRedo & Archive
- Fix a full FRA / archive destinationRedo & Archive
- View redo log statusRedo & Archive
- Add disks to an ASM diskgroupASM
- Remove a disk from an ASM diskgroupASM
- Set the ASM rebalance POWERASM
- View ASM diskgroup free spaceASM
- Monitor an ASM rebalanceASM
- Add a new tablespaceStorage
- Add a datafile to an existing tablespaceStorage
- Resize a datafile / set autoextendStorage
- Move a datafile onlineStorage
- Add a temp tablespace / change the defaultStorage
- Tablespace free space queryStorage
- Change a parameter (with SCOPE)Memory & Parameters
- Shared pool / buffer cache flushMemory & Parameters
- Create a pfile from the spfile and vice versaMemory & Parameters
- Change SGA / PGA targetsMemory & Parameters
- Kill a session (kill session)Sessions & Processes
- View long-running queries / sessionsSessions & Processes
- Find the blocking sessionSessions & Processes
- Gather statistics (DBMS_STATS)Maintenance
- Rebuild an index onlineMaintenance
- Quick full backup with RMANMaintenance
- Take a controlfile trace backupMaintenance
- Check RAC database, instance and service status with srvctlRAC & Grid
- Stop / start a RAC database or a single instance with srvctl (rolling)RAC & Grid
- Add a RAC service with preferred/available instances (including Application Continuity)RAC & Grid
- Relocate a RAC service to another instanceRAC & Grid
- Check cluster resource status (crsctl stat res -t)RAC & Grid
- Check cluster stack health, the node list and the Clusterware versionRAC & Grid
- Check OCR integrity and take an OCR backup (ocrcheck / ocrconfig)RAC & Grid
- Check voting disks and CSS timeoutsRAC & Grid
- Run pre/post checks with the Cluster Verification Utility (cluvfy)RAC & Grid
- Diagnose the cause of a node eviction / unexpected node rebootRAC & Grid
- Analyze cluster-wide wait events (gc waits) per instance with GV$RAC & Grid
- Show disk group, disk and directory usage with asmcmd (lsdg / lsdsk / du)ASM
- Check ASM disk state, error counters and candidate disks with SQLASM
- View and change ASM disk group attributes (compatible, disk_repair_time)ASM
- Show the Data Guard broker configuration and database status (DGMGRL)Data Guard
- Check primary/standby role and switchover readiness with SQLData Guard
- Measure transport/apply lag, apply rate and Data Guard processes on the standbyData Guard
- Validate the standby with the broker before switchover/failover (VALIDATE DATABASE)Data Guard
- Perform a planned switchover (DGMGRL, role change without data loss)Data Guard
- Perform a failover after losing the primary (DGMGRL)Data Guard
- Recover the old primary as a standby after a failover (REINSTATE)Data Guard
- Stop / start redo apply or redo transport with the broker; configure delayed applyData Guard
- Enable Fast-Start Failover (FSFO) and start the observerData Guard
- Convert a physical standby to a snapshot standby and back (test environment)Data Guard
- Create an RMAN recovery catalog and register the databaseRMAN
- Create a physical standby from the active database with RMAN DUPLICATERMAN
- Validate and clean up RMAN backup records (CROSSCHECK, EXPIRED, OBSOLETE)RMAN
- Validate the database and backups against corruption (VALIDATE)RMAN
- See which backups a restore would use and validate them (PREVIEW / VALIDATE)RMAN
- Repair corrupt blocks online (block media recovery, RECOVER CORRUPTION LIST)RMAN
- Return a tablespace to a point in the past (TSPITR)RMAN
- Recover a single table to a past point in time from an RMAN backup (RECOVER TABLE)RMAN
- Create a new PDB from PDB$SEEDMultitenant
- Clone a PDB within the same CDB (local / hot clone)Multitenant
- Clone a PDB from another CDB over a DB link (remote clone)Multitenant
- Unplug a PDB and plug it into another (or the same) CDBMultitenant
- Open PDBs and keep them open across CDB restarts (SAVE STATE)Multitenant
- Set per-PDB CPU, memory, I/O and storage limitsMultitenant
- Confirm which container you are in and query all PDBs from the root (CDB_ / CONTAINERS)Multitenant
- Create a refreshable PDB, refresh it and convert it to an independent PDBMultitenant
- Take an AWR snapshot and generate an AWR report between two snapshotsPerformance
- AWR diff (compare period) report between two periodsPerformance
- Top wait events and top SQL from ASH for the last minutesPerformance
- Run an ADDM analysis and get its reportPerformance
- Get a SQL Monitor report (running or completed long SQL)Performance
- Enable/disable 10046 trace for a session and summarize with TKPROFPerformance
- Show the actual execution plan with row source statistics (ALLSTATS LAST)Performance
- Create and run a SQL Tuning Advisor task and read its recommendationsPerformance
- Accept, disable and drop a SQL profilePerformance
- Load a good plan from the cursor cache as a SQL plan baselinePerformance
- Evolve unaccepted SQL plan baseline plansPerformance
- Fix, disable or drop a SQL plan baseline planPerformance
- Check bind peeking and adaptive cursor sharing statusPerformance
- Find top SQL by elapsed time/CPU in a past period (AWR + V$SQLAREA)Performance
- Find stale statistics and set per-table statistics preferences (prefs)Statistics
- Lock and unlock table/schema statisticsStatistics
- Restore statistics to a point in the pastStatistics
- Gather statistics as pending, test them and publishStatistics
- Configure incremental statistics for a partitioned tableStatistics
- Split and merge partitions onlinePartitioning
- Bulk load or archive data with exchange partitionPartitioning
- Truncate/drop a partition while keeping global indexes usablePartitioning
- Create interval partitioning and convert an existing range table to intervalPartitioning
- Verify partition keys and partition-wise join usagePartitioning
- Redefine a table online with DBMS_REDEFINITION (full flow)Online Operations
- Move a table or partition online (ALTER TABLE MOVE ONLINE)Online Operations
- Create, open, set the master key of and back up a TDE keystore (19c+)Security
- Encrypt tablespaces with TDE (new and existing, online/offline)Security
- Create a Unified Auditing policy, enable it conditionally, review records, remove itSecurity
- Add a row-level access policy with VPD (DBMS_RLS)Security
- Create a password policy profile and assign it to usersSecurity
- Find unused privileges with privilege analysisSecurity
- Inspect the inventory with OPatch and run pre-patch checksPatching & Lifecycle
- Update the SQL layer with datapatch -verbose after a binary patchPatching & Lifecycle
- Verify SQL patch history, component status and invalid objectsPatching & Lifecycle
- Create, run manually, disable and drop a scheduler jobScheduler
- Monitor scheduler job run history and failuresScheduler
- Create and activate a simple Resource Manager planScheduler
PostgreSQL
- Switch the WAL segmentWAL & Checkpoint
- Run a manual CHECKPOINTWAL & Checkpoint
- Show WAL size and current LSNWAL & Checkpoint
- Show archive lag (WAL not yet archived)WAL & Checkpoint
- Add a new tablespaceStorage
- Move a table to another tablespaceStorage
- Move an index to another tablespaceStorage
- Query database and table sizeStorage
- Estimate table bloatStorage
- VACUUM ANALYZE a specific tableMaintenance
- Run an aggressive VACUUM FREEZEMaintenance
- Rebuild an index without locking (REINDEX CONCURRENTLY)Maintenance
- Tune autovacuum for a specific tableMaintenance
- Increase a column's statistics targetMaintenance
- Change a parameter and reload (ALTER SYSTEM)Parameters
- Change a parameter for the session (SET)Parameters
- Show the current parameter valueParameters
- Build a physical replica (pg_basebackup)Replication
- Promote a replica to primaryReplication
- Show replication lagReplication
- Create and drop a replication slotReplication
- Set up a logical replication publication and subscriptionReplication
- Terminate a backend (pg_terminate_backend)Sessions
- Cancel a running query (pg_cancel_backend)Sessions
- Show active and blocking queriesSessions
- Add an extensionExtensions
- List installed extensionsExtensions
- Show Patroni cluster status, topology and historyPatroni
- Perform a planned switchover with PatroniPatroni
- Perform a manual failover with PatroniPatroni
- Rebuild a broken replica with Patroni (reinit)Patroni
- Change cluster-wide parameters in Patroni (edit-config) and apply pending restartsPatroni
- Put Patroni into maintenance mode and back (pause/resume)Patroni
- Check Patroni DCS (etcd/Consul) and REST API healthPatroni
- Configure WAL archiving for pgBackRest (archive-push/archive-get)Backup & PITR
- Create the pgBackRest stanza and verify archiving (stanza-create/check)Backup & PITR
- Take full, differential and incremental backups with pgBackRestBackup & PITR
- Show the pgBackRest backup catalog and WAL archive range (info)Backup & PITR
- Restore the latest backup with pgBackRestBackup & PITR
- Restore to a point in time with pgBackRest (PITR, --type=time)Backup & PITR
- Quickly rebuild a standby with pgBackRest delta restoreBackup & PITR
- Configure pgBackRest retention and run expireBackup & PITR
- Configure a standby manually (standby.signal + primary_conninfo)Replication
- Monitor WAL receive and replay lag on the standby (pg_stat_wal_receiver)Replication
- Rejoin the old primary as a replica after failover with pg_rewindReplication
- Configure synchronous replication with quorum (ANY) or priority (FIRST)Replication
- Monitor WAL retained by replication slots and safely drop an abandoned slotReplication
- Limit the WAL that slots can retain (max_slot_wal_keep_size)Replication
- Add a table to a publication and refresh the subscription (REFRESH PUBLICATION)Logical Replication
- Monitor logical replication (pg_stat_subscription, apply errors, slot lag)Logical Replication
- Resolve a logical replication conflict (disable_on_error, SKIP)Logical Replication
- Synchronize sequence values to the subscriber in logical replicationLogical Replication
- Remove a subscription and clean up an orphaned logical slot on the publisherLogical Replication
- Major version upgrade with pg_upgrade --link (end-to-end runbook)Upgrade
- Near-zero-downtime major version upgrade with logical replicationUpgrade
- Show PgBouncer pools, statistics and connections (SHOW POOLS/STATS/CLIENTS/SERVERS)PgBouncer
- Hold connections during maintenance with PgBouncer (PAUSE/RESUME) and reload configuration (RELOAD)PgBouncer
- PgBouncer pool_mode choice and basic sizingPgBouncer
- Find the most expensive queries (pg_stat_statements: total and mean time)Performance
- Find queries driving disk I/O, temp files and WAL (pg_stat_statements)Performance
- Reset pg_stat_statements statistics (all or a single query)Performance
- Log execution plans of slow queries with auto_explainPerformance
- Read a plan in depth with EXPLAIN (ANALYZE, BUFFERS, SETTINGS, WAL)Performance
- Catch plan regressions by queryid (pg_stat_statements snapshot comparison)Performance
- Check parallel query capacity and current worker usagePerformance
- Measure the impact of JIT compilation on query timePerformance
- Build the blocking tree (find the root blocker)Sessions
- Inspect lock waits in detail by object and lock mode (pg_locks)Sessions
- Find long-running and 'idle in transaction' transactionsSessions
- Terminate long 'idle in transaction' sessions in bulk, in a controlled waySessions
- Set statement_timeout / lock_timeout per role and databaseSessions
- Apply DDL safely with lock_timeout and retries (avoid lock queues)Sessions
- Measure connection usage against max_connectionsSessions
- Monitor the progress of running autovacuum/VACUUM operationsMaintenance
- Measure transaction ID wraparound risk (XID age per database and table)Maintenance
- Find the xmin horizon holders that stop VACUUM from removing dead tuplesMaintenance
- Measure table and index bloat with pgstattupleMaintenance
- Reorganize a bloated table without long locks (pg_repack)Maintenance
- Find and clean up INVALID indexesMaintenance
- Create extended statistics for correlated columns (CREATE STATISTICS)Maintenance
- Find tables with stale statistics (ANALYZE strategy)Maintenance
- Check visibility map coverage and Index Only Scan efficiencyMaintenance
- Create a monthly range-partitioned table (generate partitions in a loop)Partitioning
- Attach a prepared table as a partition with a short lock (ATTACH PARTITION)Partitioning
- Detach an old partition without blocking live traffic (DETACH CONCURRENTLY)Partitioning
- Default partition pitfall: new partition fails with 'would be violated by some row'Partitioning
- Verify that partition pruning works (plan time and run time)Partitioning
- Automate partition creation and retention with pg_partmanPartitioning
- Build a least-privilege role hierarchy (GRANT + ALTER DEFAULT PRIVILEGES)Security
- Set up tenant isolation with row-level securitySecurity
- Validate pg_hba.conf rule order and reload safelySecurity
- Enable SSL/TLS and verify encrypted connections (pg_stat_ssl)Security
- Migrate from md5 passwords to scram-sha-256Security
- Keep role- and object-level audit logs with pgauditSecurity
- Review memory settings (shared_buffers, work_mem, maintenance_work_mem)Parameters
- Show parameters pending restart and configuration file errorsParameters
- Review checkpoint behavior (PG17+ pg_stat_checkpointer, PG16 and earlier pg_stat_bgwriter)Parameters
- List table size broken down into heap / index / TOAST, and the largest indexesStorage
- Find extensions with pending updates and update themExtensions
- Analyze where I/O comes from with pg_stat_io (backend type, object, context)Extensions
MySQL
- Rotate the binary logBinlog & Log
- Purge old binary logs (PURGE)Binlog & Log
- View binary log statusBinlog & Log
- Enable the general and slow query logsBinlog & Log
- Change the InnoDB redo log sizeStorage
- Add / manage an InnoDB undo tablespaceStorage
- Add a general tablespaceStorage
- OPTIMIZE a tableStorage
- Query table and schema sizesStorage
- Update table statistics (ANALYZE TABLE)Maintenance
- Rebuild a table/indexesMaintenance
- Check table integrity (CHECK TABLE)Maintenance
- Change a global variable and persist itParameters
- View the current value of a variableParameters
- Reload the grant tables (FLUSH PRIVILEGES)Parameters
- Set up a replica (CHANGE REPLICATION SOURCE)Replication
- Start / stop a replicaReplication
- View replica status (SHOW REPLICA STATUS)Replication
- Skip a broken transaction (GTID)Replication
- Kill a query or connection (KILL)Session
- View the process listSession
- View blocking locks (data_lock_waits)Session
- Monitor replica lag and applier worker errors (performance_schema)Replication
- Tune the multi-threaded replica (replica_parallel_workers)Replication
- Repair a broken replica: 1062 / 1032 row conflictsReplication
- Find and neutralize errant GTID transactionsReplication
- Rebuild a replica from scratch with the CLONE pluginReplication
- Recover from a bad DROP / DELETE with a delayed replica (SOURCE_DELAY + UNTIL)Replication
- Take a consistent logical backup with GTID info using mysqldumpBackup & PITR
- Parallel dump / load with MySQL Shell (util.dumpInstance, loadDump)Backup & PITR
- Full + incremental physical backup and restore with XtraBackupBackup & PITR
- Point-in-time recovery with binlogs: find and skip the bad transactionBackup & PITR
- Check InnoDB Cluster / Group Replication healthInnoDB Cluster
- Planned primary switchover in InnoDB ClusterInnoDB Cluster
- Bring the cluster back after a complete outage (rebootClusterFromCompleteOutage)InnoDB Cluster
- Bootstrap MySQL Router against an InnoDB ClusterRouter & Proxy
- Read/write split and replica health checks with ProxySQLRouter & Proxy
- Online DDL: ALGORITHM=INSTANT / INPLACE, LOCK=NONE and progress trackingOnline Operations
- Non-blocking ALTER on a large table with pt-online-schema-changeOnline Operations
- Triggerless online schema change with gh-ostOnline Operations
- Find the most expensive queries (performance_schema digest)Performance
- What is running right now: active sessions, latency, locks and transactions (sys.session)Performance
- Diagnose 'Waiting for table metadata lock' and find the real blockerPerformance
- Analyze InnoDB deadlocks and log all of themPerformance
- Long-running transactions and history list length (purge lag)Performance
- Capture a short full slow log and analyze it with pt-query-digestPerformance
- Debug a bad plan with EXPLAIN ANALYZE and the optimizer tracePerformance
- Create and manage histograms for non-indexed columnsIndex & Statistics
- Find unused / redundant indexes, make them invisible, drop safelyIndex & Statistics
- Is the buffer pool big enough: hit ratio, wait_free and online resizeMemory
- RANGE partition maintenance: add future partitions, archive / drop old onesPartitioning
- Build a least-privilege model with roles (CREATE ROLE, DEFAULT ROLE)Security
- Password policy, failed-login lockout and zero-downtime password rotationSecurity
- Enforce TLS, find non-TLS connections, renew certificates without restartSecurity
- Audit risky accounts: empty password, '%' host, SUPER, mysql_native_passwordSecurity
- 8.0 → 8.4 LTS upgrade pre-check (util.checkForServerUpgrade)Upgrade
- Convert latin1 / utf8mb3 tables to utf8mb4Maintenance
SQL Server
- Take a transaction log backupBackup & Log
- Take FULL and DIFFERENTIAL backupsBackup & Log
- Why the log file grew / why it is not truncatingBackup & Log
- Shrink the log fileBackup & Log
- Show the VLF (Virtual Log File) countBackup & Log
- Find the oldest open transaction (ACTIVE_TRANSACTION)Backup & Log
- Add a data file to a databaseStorage
- Add a filegroupStorage
- Change file size / autogrowthStorage
- Move a data/log file to another locationStorage
- Add a data file to tempdbStorage
- Index rebuild / reorganizeMaintenance
- Update statisticsMaintenance
- Integrity check (DBCC CHECKDB)Maintenance
- Show index fragmentationMaintenance
- Kill a session (SPID)Session
- Find the blocking (lock) chainSession
- Show active queries and their costSession
- Configure with sp_configure (max server memory)Configuration
- General sp_configure setting and RECONFIGUREConfiguration
- Availability Group failoverConfiguration
- Change the database recovery modelConfiguration
- Monitor availability group health and lag (log send / redo queue, RPO)Always On & HA
- Forced failover (FORCE_FAILOVER_ALLOW_DATA_LOSS) and post-failover recoveryAlways On & HA
- Add a database to an AG (automatic seeding) and monitor seeding progressAlways On & HA
- Check the listener, its IPs and read-only routing configurationAlways On & HA
- Monitor log shipping status and latencyAlways On & HA
- Take an ad-hoc backup without breaking the chain (COPY_ONLY, striping, throughput)Backup & Log
- Back up to URL (Azure Blob SAS / S3-compatible storage)Backup & Log
- Backup history from msdb and missing backup checkBackup & Log
- See backup / restore / CHECKDB progress and estimated completionBackup & Log
- Take a tail-log backup before a restore (NORECOVERY / NO_TRUNCATE)Restore & Recovery
- Restore to a point in time (point-in-time restore, STOPAT)Restore & Recovery
- Inspect and verify a backup file (VERIFYONLY, HEADERONLY, FILELISTONLY)Restore & Recovery
- Find corrupt pages (suspect_pages) and restore single pagesRestore & Recovery
- Find the most expensive queries in the plan cache (CPU, reads, duration)Performance
- Wait statistics: what the server is waiting onPerformance
- Read past deadlocks from the system_health session (deadlock graph)Performance
- Create an Extended Events session: capture slow queries to file and read themPerformance
- Diagnose tempdb contention and space usagePerformance
- Enable Query Store, apply recommended settings and check its stateQuery Store
- Find plan regressions with Query Store (same query, different plans)Query Store
- Force a good plan or attach a hint with Query StoreQuery Store
- Read missing index suggestions from DMVs (with caveats)Maintenance
- Find unused / write-only indexesMaintenance
- Statistics health: when updated, how many rows changedMaintenance
- DBCC CHECKDB strategy: last good check, splitting the work, interpreting resultsMaintenance
- Limit reporting load with Resource Governor (pool, workload group, classifier)Configuration
- Set up TDE: master key, certificate, certificate backup and encryption progressSecurity
- Set up SQL Server Audit: logins, permission changes and table accessSecurity
- Find orphaned users and remap them to logins (after restore / AG)Security
- Login and permission audit: sysadmin members, risky permissions, weak passwordsSecurity
- Create a ledger table, read its change history and verify integritySecurity
- SQL Agent job failure history and last run statusSQL Agent
MongoDB
- Add a member to the replica setReplica Set
- Remove a member from the replica setReplica Set
- Step down the primary (stepDown)Replica Set
- Change member priorityReplica Set
- View replica set statusReplica Set
- Configure a hidden / non-voting memberReplica Set
- Resync a member from scratchReplica Set
- Add a shard to the clusterSharding
- Shard a collectionSharding
- Start the balancerSharding
- Stop the balancerSharding
- View sharding statusSharding
- Add a zone (tag) and assign a rangeSharding
- Move a chunk manuallySharding
- Compact a collectionMaintenance
- Create an index (non-blocking)Maintenance
- View index and collection sizesMaintenance
- Rotate the log fileMaintenance
- Find long-running operationsMaintenance
- Kill an operationMaintenance
- Change a runtime parameterParameters
- Set the profiling levelParameters
- Measure the oplog window and replication lagReplica Set
- Resize the oplog online (replSetResizeOplog)Replica Set
- Force a replica set reconfiguration after losing the majority (force reconfig)Replica Set
- Rolling maintenance on a replica set (restart, OS patch, minor upgrade)Replica Set
- Balancer state, active window and per-collection balancingSharding
- Find jumbo chunks, split them and clear the flagSharding
- Check shard key choice and data distribution (getShardDistribution, analyzeShardKey)Sharding
- Inspect a query plan with real execution statistics (explain executionStats)Performance
- Extract the slowest queries and query shapes from profiler dataPerformance
- Find unused indexes and hide them before dropping (hideIndex)Performance
- Count connections by application and client (connection storm diagnosis)Performance
- Monitor and abort an in-progress index buildMaintenance
- Rolling index build on a replica set (member by member)Maintenance
- Create a TTL index, change its expiry and monitor TTL deletesMaintenance
- Measure WiredTiger cache pressure (fill, dirty ratio, application eviction)Performance
- Take an archive backup with mongodump/mongorestore and restore a single collectionBackup
- Point-in-time restore with oplog replay (return to before a bad drop/delete)Backup
- Define a custom role, create a user, grant/revoke roles and change the passwordSecurity
- Check featureCompatibilityVersion (fCV) and the major upgrade sequenceUpgrade
Redis
- Rewrite (compact) the AOF filePersistence
- Take an RDB snapshot in the backgroundPersistence
- Take a synchronous RDB snapshotPersistence
- View the last successful snapshot timePersistence
- Write the running configuration to diskPersistence
- Enable or disable AOFPersistence
- Set RDB snapshot rulesPersistence
- Make a node a replicaReplication
- Promote a replica to masterReplication
- Perform a manual failoverCluster
- Add a node to the clusterCluster
- Assign cluster slotsCluster
- View replication statusCluster
- View cluster statusCluster
- Set maxmemory and the policyMemory
- Analyze memoryMemory
- View the slow command logMaintenance
- Set the slow command thresholdMaintenance
- Reset the slow command logMaintenance
- Kill a client connectionMaintenance
- List connected clientsMaintenance
- View a parameter valueRuntime
- Change a parameter valueRuntime
- Analyze memory usage and fragmentation, enable active defragMemory
- Find big keys (--bigkeys, --memkeys, MEMORY USAGE)Memory
- Find hot keys (--hotkeys, OBJECT FREQ)Performance
- Find keys matching a pattern without KEYS and delete them safely (SCAN + UNLINK)Maintenance
- Diagnose the source of latency (LATENCY DOCTOR, histogram, commandstats)Performance
- Diagnose eviction, expiry and OOM errorsMemory
- Find connections bloating memory (output buffer, query buffer, maxmemory-clients)Memory
- Diagnose RDB/AOF error state, fork time and the cause of MISCONFPersistence
- Repair Redis that will not start because of a corrupt AOF (redis-check-aof, redis-check-rdb)Persistence
- Fix replication drops and an endless full resync loop (backlog, replica buffer)Replication
- Check Sentinel state, the current master and quorumSentinel
- Perform a manual failover with Sentinel and clean up the topologySentinel
- Check cluster health and repair slot inconsistencies (--cluster check/fix)Cluster
- Add nodes, move slots and remove nodes in a cluster (add-node, reshard, rebalance)Cluster
- Create ACL users, test permissions and make them persistentSecurity
- Investigate NOPERM and WRONGPASS errors (ACL LOG)Security
- Monitor key deletion and expiry events with keyspace notificationsMaintenance
Elasticsearch
- Flush an indexIndex Lifecycle
- Merge index segments (force merge)Index Lifecycle
- Roll over via an aliasIndex Lifecycle
- Change the refresh intervalIndex Lifecycle
- Change the replica countIndex Lifecycle
- Open or close an indexIndex Lifecycle
- Add a node to the clusterCluster/Node
- Drain a node (decommission)Cluster/Node
- Move a shard manually (reroute)Cluster/Node
- Enable or disable shard allocationCluster/Node
- Change a cluster settingCluster/Node
- Register a snapshot repositorySnapshot
- Take a snapshotSnapshot
- Restore from a snapshotSnapshot
- Clear the cacheMaintenance
- View pending cluster tasksMaintenance
- Get a hot threads analysisMaintenance
- View shard distributionMaintenance
- Find why a shard is unassignedMaintenance
- View cluster healthMaintenance
- Manually refresh an indexIndex Lifecycle
- Red/yellow cluster triage flow (which index, which shard, why)Cluster/Node
- Reallocate shards that hit the retry limit (reroute retry_failed)Cluster/Node
- Allocate a lost primary shard as a last resort (allocate_stale_primary)Cluster/Node
- Manage disk watermarks and remove the flood-stage write blockCluster/Node
- Rolling restart / rolling upgrade (node by node, without unnecessary shard moves)Cluster/Node
- Audit shard sizes and shard count (oversharding / oversized shard detection)Maintenance
- Shrink an index with too many shardsIndex Lifecycle
- Define an ILM policy, attach it via a template and bootstrap the rollover chainIndex Lifecycle
- Diagnose a stuck ILM step and retry it (_ilm/explain, _ilm/retry)Index Lifecycle
- Build an index template from component templates and simulate the resultIndex Lifecycle
- Change a mapping with zero downtime (reindex + atomic alias switch)Index Lifecycle
- Find, cancel or throttle long-running search and reindex tasksMaintenance
- Enable the search and indexing slow log (per-index thresholds)Performance
- Diagnose 429 rejections, heap and circuit breaker pressurePerformance
- Automate snapshots and retention with SLM, monitor snapshot progressSnapshot
- Create a role and native user, change the password, issue an API keySecurity