BestHub
Sign in
Tagged articles
20 articles
Page 1 of 1
Shuge Unlimited
Shuge Unlimited
Feb 11, 2026 · Operations

How to Easily Manage Operations of 10 Milvus Clusters with an Agent Skill

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.

Index ManagementMilvusOperations Automation
0 likes · 18 min read
How to Easily Manage Operations of 10 Milvus Clusters with an Agent Skill
Senior Brother's Insights
Senior Brother's Insights
Sep 13, 2025 · Databases

When Do Database Indexes Hurt More Than Help?

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 IndexesIndex ManagementStorage Overhead
0 likes · 6 min read
When Do Database Indexes Hurt More Than Help?
Su San Talks Tech
Su San Talks Tech
Dec 25, 2024 · Databases

Discover Elasticvue: A Lightweight Yet Powerful Elasticsearch GUI

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.

ElasticsearchGUIIndex Management
0 likes · 5 min read
Discover Elasticvue: A Lightweight Yet Powerful Elasticsearch GUI
Zhuanzhuan Tech
Zhuanzhuan Tech
May 26, 2023 · Backend Development

ECP (Elasticsearch Chain Planning) System: Design, Features, and Implementation for Efficient Index Management

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.

ElasticsearchIndex Managementautomation
0 likes · 12 min read
ECP (Elasticsearch Chain Planning) System: Design, Features, and Implementation for Efficient Index Management
dbaplus Community
dbaplus Community
Apr 24, 2023 · Operations

Why Your Elasticsearch Cluster Stalls at Red and How to Recover It Fast

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 RecoveryIndex ManagementRecovery API
0 likes · 10 min read
Why Your Elasticsearch Cluster Stalls at Red and How to Recover It Fast
Tencent Cloud Developer
Tencent Cloud Developer
Dec 24, 2020 · Big Data

Distributed Search Engine Design and Index Management in WeChat Search

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.

Distributed SystemsIndex ManagementLSM
0 likes · 28 min read
Distributed Search Engine Design and Index Management in WeChat Search
Java Architect Essentials
Java Architect Essentials
Oct 30, 2020 · Databases

Elasticsearch Essentials: Quick Start, Index Management, Mapping, and Advanced Operations

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.

ElasticsearchIndex ManagementMapping
0 likes · 17 min read
Elasticsearch Essentials: Quick Start, Index Management, Mapping, and Advanced Operations
DevOps Coach
DevOps Coach
Oct 19, 2020 · Backend Development

Understanding Elasticsearch Segment Merging: When and How to Use Force Merge

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.

ElasticsearchForce MergeIndex Management
0 likes · 9 min read
Understanding Elasticsearch Segment Merging: When and How to Use Force Merge
ITPUB
ITPUB
Apr 3, 2020 · Databases

Essential SQL Server Queries: From Server Properties to Index Management

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.

Always OnBackup MonitoringDatabase Administration
0 likes · 28 min read
Essential SQL Server Queries: From Server Properties to Index Management
Ops Development Stories
Ops Development Stories
Mar 13, 2020 · Operations

How to Extend Zabbix Monitoring Data Retention in Elasticsearch for a Year

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.

ElasticsearchHot/Cold NodesIndex Management
0 likes · 6 min read
How to Extend Zabbix Monitoring Data Retention in Elasticsearch for a Year
Aikesheng Open Source Community
Aikesheng Open Source Community
May 28, 2019 · Databases

Unlocking MySQL 8.0 Invisible Indexes for Safer Query Optimization

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.

Database OptimizationIndex ManagementInvisible Index
0 likes · 18 min read
Unlocking MySQL 8.0 Invisible Indexes for Safer Query Optimization
ITPUB
ITPUB
Mar 3, 2016 · Databases

Mastering SQL Server Index Creation, Maintenance, and Optimization

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 INDEXIndex ManagementSQL Server
0 likes · 16 min read
Mastering SQL Server Index Creation, Maintenance, and Optimization