This article provides a step‑by‑step reference of essential ElasticSearch REST commands—including cluster health checks, node information, index management, document CRUD operations, and various search queries with examples and expected responses—helping practitioners efficiently manage and troubleshoot large ElasticSearch deployments.
This article walks through the real‑world pain points of monitoring dozens of Milvus collections across multiple clusters, then details a Python‑based Skill that automates connection handling, aggregates collection metadata, evaluates index health with a three‑state model, and provides unified health checks, performance testing, and capacity analysis for reliable large‑scale vector database operations.
This article details a real‑world Elasticsearch performance overhaul on a 12‑billion‑document cluster, covering shard rebalancing, index slimming, JVM tuning, query optimization, safe scaling, monitoring alerts, and data cleanup, complete with formulas, code snippets, and measurable results.
This article explains how indexes boost query speed but also incur storage, write‑performance, and maintenance costs, offering practical SQL scripts and guidelines for auditing, testing, and safely removing unnecessary indexes.
This guide shows how to use a Python script with the Elasticsearch client to connect to a cluster, identify UAT indices older than a specified date, and safely delete them while logging each step for audit and troubleshooting.
This guide introduces Elasticvue, a lightweight and powerful Elasticsearch GUI, walks through downloading and installing the tool, configuring clusters, creating and managing indices via both GUI and REST, and demonstrates adding and viewing data with practical code examples.
This guide explains how to identify and remove outdated Elasticsearch indices by listing shards, filtering target indices, deleting them with a shell loop, and automating the process with a scheduled cron job, helping keep ELK performance optimal.
The article introduces the ECP system, a backend platform built on Elasticsearch that standardizes, automates, and visualizes index refresh workflows, addressing manual bottlenecks, data cleaning challenges, and coupling issues while providing task management, permission control, and environment isolation for high‑efficiency index operations.
A large foreign‑enterprise Elasticsearch cluster with 10 TB of data and 200 shards got stuck in a red state after a restart, prompting a detailed diagnosis and step‑by‑step recovery plan that includes shard actions, recovery API tuning, delayed allocation, speed limits, and cautious index deletion to restore normal operation.
This guide explores practical strategies for managing Elasticsearch indexes, covering management approaches, structural maintenance, data synchronization, refresh policies, and deep pagination techniques to avoid common pitfalls and ensure reliable search performance.
This guide walks you through creating, viewing, updating, and deleting Elasticsearch indices, documents, and mappings using RESTful HTTP methods, complete with example requests, JSON bodies, and visual illustrations for each operation.
This guide walks through using Elasticsearch 7.8.0 and Postman to create, view, update, and delete indices and documents via RESTful API calls, including mapping setup and query‑based deletions, providing clear code examples and request details.
The article details WeChat Search’s practical distributed architecture—using a Chubby‑elected leader for shard‑to‑node mapping, hash‑based sharding with dynamic rebalancing, a Lambda‑style batch and near‑real‑time indexing pipeline, relaxed monotonic consistency, and group‑based searcher scaling—to illustrate trade‑offs and lessons for building scalable, reliable search services.
The article offers a thorough, step‑by‑step guide to Elasticsearch, explaining how to check cluster health, create and manage indices, define mappings and field types, use dynamic mapping, and perform maintenance tasks such as shrink, split, rollover, and cache management, all illustrated with concrete API examples.
This article explains what Elasticsearch segments are, why they are immutable, how segment merging works, its impact on resources and search performance, and provides practical configuration tips such as using force_merge, refresh_interval adjustments, and thread count settings.
This guide walks through essential Elasticsearch operations, covering cluster health checks, creating and querying indices, managing settings, templates, aliases, index shrink, split, rollover, and detailed mapping definitions, providing practical code examples for each step.
A comprehensive collection of SQL Server commands covering server properties, configuration, system views, monitoring, backup, replication, Always On, file management, index operations, and troubleshooting techniques for database administrators.
Facing limited storage of Zabbix historical data in Elasticsearch, the article outlines a comprehensive strategy—expanding nodes, adding SSDs, redesigning index mapping, using hot‑cold node tiers, employing Curator for automated shrink, segment merging, and lifecycle management—to retain up to a year of monitoring data efficiently.
This article explains MySQL 8.0's invisible index feature, outlines practical scenarios for its use, provides step‑by‑step SQL examples to create, hide, and test indexes, and shows how to enable the optimizer to consider invisible indexes for better performance and safer schema changes.
This article walks through a real‑world SQL Server case study, explaining how to assess system hardware, interpret performance counters and wait statistics, identify CPU, memory, disk and indexing issues, and apply a three‑stage optimization process to dramatically improve database performance.
This article explains why proper index design is crucial for SQL Server performance and provides detailed guidance on creating clustered and non‑clustered indexes, using ALTER INDEX to disable, rebuild, reorganize, and modify index metadata, as well as a comprehensive overview of index options and best‑practice recommendations.
