Tagged articles
index-management
22 articles · Page 1 of 1
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.
Document CRUDElasticsearchREST API
0 likes · 5 min read

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.
MilvusOperations AutomationPython
0 likes · 18 min read

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.
Cluster ScalingElasticsearchJVM Optimization
0 likes · 6 min read

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.
Database IndexesMySQLStorage Overhead
0 likes · 6 min read

This article provides a comprehensive reference of Elasticsearch 7.x+ RESTful API commands covering index management, document CRUD, query DSL (match, term, bool, aggregations), SQL access, cluster health, index aliases, reindexing, and _cat APIs with practical examples.
AggregationsDocument OperationsElasticsearch
0 likes · 13 min read

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.
ElasticsearchLoggingautomation
0 likes · 4 min read

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.
ElasticsearchGUIelasticvue
0 likes · 5 min read

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.
ElasticsearchOperationscron
0 likes · 3 min read

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.
Elasticsearchautomationdata cleaning
0 likes · 12 min read

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.
Cluster RecoveryRecovery APIindex-management
0 likes · 10 min read

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.
BackendDeep PaginationElasticsearch
0 likes · 9 min read

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.
Document CRUDElasticsearchMapping
0 likes · 5 min read

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.
Document CRUDMappingREST API
0 likes · 5 min read

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.
LSMLambda architectureSharding
0 likes · 28 min read

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.
ElasticsearchMappingTutorial
0 likes · 17 min read

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.
ElasticsearchSegment Mergingforce merge
0 likes · 9 min read

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.
BackendElasticsearchMapping
0 likes · 18 min read


ITPUBApr 3, 2020 · Databases
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.
Backup MonitoringPerformance TuningSQL Server
0 likes · 28 min read

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.
CuratorElasticsearchHot/Cold Nodes
0 likes · 6 min read

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.
MySQLSQLdatabase optimization
0 likes · 18 min read

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.
Performance TuningSQL ServerSystem Monitoring
0 likes · 11 min read


ITPUBMar 3, 2016 · Databases
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.
ALTER INDEXSQL Servercreate_index
0 likes · 16 min read
