BestHub
Sign in
Tagged articles
640 articles
Page 7 of 7
dbaplus Community
dbaplus Community
Sep 13, 2016 · Databases

How to Speed Up Zabbix Latest Data Display by Adding Dedicated Tables and Indexes

This article explains why Zabbix's original table design slows down data insertion and query in large‑scale deployments, and provides a step‑by‑step code‑level optimization that creates separate "latest" tables with primary‑key indexes, modifies the server source, and updates the front‑end query to dramatically improve performance without affecting historical data ingestion.

Database OptimizationOraclePerformance tuning
0 likes · 11 min read
How to Speed Up Zabbix Latest Data Display by Adding Dedicated Tables and Indexes
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Sep 7, 2016 · Databases

MongoDB Indexing Best Practices: Real‑World Tips & Common Pitfalls

This article shares practical MongoDB indexing guidelines—including compound index rules, naming limits, cardinality considerations, TTL and geospatial indexes, lock behavior, and real‑world case studies—to help DBAs and developers design efficient, safe indexes for production workloads.

Database PerformanceGeospatial IndexMongoDB
0 likes · 8 min read
MongoDB Indexing Best Practices: Real‑World Tips & Common Pitfalls
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Sep 1, 2016 · Databases

MongoDB Document Best Practices: Avoid Common Pitfalls with Real‑World Cases

This article outlines essential MongoDB document best‑practice guidelines, including key naming restrictions, collection organization, avoiding custom _id values, pitfalls of array fields, compression of large fields, using MD5 hashes for long strings, case‑sensitivity handling, and index size limits, illustrated with real‑world cases.

Best PracticesDocument DesignMongoDB
0 likes · 11 min read
MongoDB Document Best Practices: Avoid Common Pitfalls with Real‑World Cases
dbaplus Community
dbaplus Community
Aug 17, 2016 · Databases

How We Turned a Sluggish Hospital HIS on SQL Server 2008R2 into a Faster System

This article walks through a real‑world case study of a hospital HIS running on SQL Server 2008R2, detailing the system’s hardware specs, performance metrics, three‑phase optimization process—including general tuning, statement‑level fixes, and deep CPU/memory analysis—and the measurable results achieved without adding new hardware.

Database OptimizationHospital HISPerformance tuning
0 likes · 12 min read
How We Turned a Sluggish Hospital HIS on SQL Server 2008R2 into a Faster System
dbaplus Community
dbaplus Community
Aug 12, 2016 · Databases

Boost MySQL Performance: Data Types, Indexes, and SQL Optimization Techniques

This article walks through practical MySQL performance tuning from a developer's perspective, covering a real‑world example, data‑type selection, index design, and SQL query refinements, while providing concrete commands, visual illustrations, and expert Q&A for deeper understanding.

Data TypesDatabase OptimizationSQL Tuning
0 likes · 19 min read
Boost MySQL Performance: Data Types, Indexes, and SQL Optimization Techniques
ITPUB
ITPUB
Jul 25, 2016 · Databases

How BRIN Indexes Use allnulls and hasnulls to Slash PostgreSQL Scans

This article demonstrates how PostgreSQL 9.5's BRIN index leverages the allnulls and hasnulls flags in its regular pages to filter out unnecessary heap page scans, dramatically improving query performance while also discussing the impact of MVCC bloat and maintenance.

BRINMVCCNull Handling
0 likes · 10 min read
How BRIN Indexes Use allnulls and hasnulls to Slash PostgreSQL Scans
ITPUB
ITPUB
Jul 16, 2016 · Databases

BRIN vs BTREE in PostgreSQL: Massive Space Savings and Performance Trade‑offs

This article experimentally compares PostgreSQL 9.5's BRIN and BTREE indexes across seven data distributions, revealing that BRIN uses up to 6,848 times less storage while BTREE consistently outperforms BRIN in query speed, with the gap narrowing as data repetition increases.

BRINBTreePostgreSQL
0 likes · 12 min read
BRIN vs BTREE in PostgreSQL: Massive Space Savings and Performance Trade‑offs
Java High-Performance Architecture
Java High-Performance Architecture
Jun 20, 2016 · Databases

Boost MySQL Query Performance with Generated Virtual Columns

MySQL 5.7 introduces generated (virtual) columns, allowing you to store computed values such as day‑of‑week without extra storage, enabling indexed queries that bypass function‑based limitations, improving read performance while avoiding the write‑time overhead and redundancy of manual columns.

Generated ColumnsVirtual Columnsindexing
0 likes · 4 min read
Boost MySQL Query Performance with Generated Virtual Columns
21CTO
21CTO
Jun 15, 2016 · Databases

Why Adding Indexes to Every Column Won’t Speed Up MySQL Queries

This article explains MySQL’s indexing fundamentals, the left‑most prefix rule, B+‑tree structure, disk I/O considerations, and provides step‑by‑step methods and real‑world cases for diagnosing and optimizing slow queries in production systems.

B+TreeDatabase Performanceindexing
0 likes · 25 min read
Why Adding Indexes to Every Column Won’t Speed Up MySQL Queries
Baidu Maps Tech Team
Baidu Maps Tech Team
Jun 2, 2016 · Backend Development

How Baidu Maps Re‑engineered Its Indexing Unit for Scalable Data Storage

This article details Baidu Maps' technical team’s refactoring of the indexing (build) unit, outlining existing bottlenecks, design challenges, and a new decoupled architecture that separates storage, incremental updates, and full‑index construction using distributed table storage and message‑driven pipelines to improve scalability and reliability.

Baidu MapsScalabilitySearch Architecture
0 likes · 9 min read
How Baidu Maps Re‑engineered Its Indexing Unit for Scalable Data Storage
Qunar Tech Salon
Qunar Tech Salon
Apr 30, 2016 · Big Data

Designing and Optimizing Log Storage and Query in HBase

This article analyzes the characteristics of log data, explains why HBase is chosen for log storage, discusses the shortcomings of self‑built indexes, and presents optimization strategies such as rowKey design, filter usage, coprocessor integration, and third‑party indexing to improve query performance.

HBaseRowkey Designindexing
0 likes · 12 min read
Designing and Optimizing Log Storage and Query in HBase
dbaplus Community
dbaplus Community
Apr 28, 2016 · Databases

How Uber Built Schemaless: A Scalable MySQL‑Based No‑Schema Datastore

This article explains how Uber engineered Schemaless, a highly available, horizontally scalable datastore built on MySQL that stores immutable JSON cells without a fixed schema, detailing its design goals, architecture, data model, trigger system, indexing strategy, and fault‑tolerant read/write mechanisms.

NoSQLScalable DatastoreSchemaless
0 likes · 32 min read
How Uber Built Schemaless: A Scalable MySQL‑Based No‑Schema Datastore
Tencent Music Tech Team
Tencent Music Tech Team
Apr 28, 2016 · Mobile Development

Understanding and Using EventBus 3 in Android: Setup, Core Architecture, Index Acceleration, and Best Practices

EventBus 3 provides a lightweight publish/subscribe framework for Android that simplifies inter‑module communication by allowing any object to be posted and received via @Subscribe methods, with optional index acceleration for faster registration, customizable thread modes, and guidance on setup, ProGuard rules, pitfalls, and alternatives.

AndroidAnnotation ProcessingEventBus
0 likes · 22 min read
Understanding and Using EventBus 3 in Android: Setup, Core Architecture, Index Acceleration, and Best Practices
ITPUB
ITPUB
Apr 6, 2016 · Databases

Boost MySQL Performance: Engine Choice, Indexing, and EXPLAIN Tips

This guide explains practical MySQL optimization techniques—including selecting InnoDB vs. MyISAM, avoiding COUNT(*), using EXPLAIN, and adding selective indexes—to dramatically reduce query time and prevent full‑table scans.

Database OptimizationEXPLAINPerformance tuning
0 likes · 7 min read
Boost MySQL Performance: Engine Choice, Indexing, and EXPLAIN Tips
Architect
Architect
Mar 22, 2016 · Backend Development

Youzan Search Engine Practice – Engineering Part: Architecture, Indexing, and Performance Optimization

This article describes the practical architecture of Youzan's commercial e‑commerce search engine, covering data source integration, distributed real‑time indexing with Elasticsearch, Hadoop and Kafka, advanced search modules, and several performance‑tuning techniques for large‑scale deployments.

Backend ArchitectureElasticsearchKafka
0 likes · 13 min read
Youzan Search Engine Practice – Engineering Part: Architecture, Indexing, and Performance Optimization
21CTO
21CTO
Mar 22, 2016 · Databases

How Facebook’s Dragon Engine Accelerates Graph Queries at Scale

Facebook’s Dragon distributed graph query engine optimizes high‑volume single‑hop and multi‑hop queries by introducing specialized indexing, socially aware inverted indices, and functional primitives, dramatically reducing latency, storage reads, and CPU usage while handling massive social‑graph data.

DragonFacebookGraph Database
0 likes · 11 min read
How Facebook’s Dragon Engine Accelerates Graph Queries at Scale
Baidu Maps Tech Team
Baidu Maps Tech Team
Mar 9, 2016 · Cloud Computing

How Baidu’s LBS Cloud Storage Revolutionizes Massive Geospatial Data Retrieval

Baidu’s LBS Cloud Storage and Retrieval platform offers developers a fully managed, high‑performance solution for massive geospatial data, featuring free large‑scale storage, GeoHash‑based spatial queries, real‑time updates, strong isolation, and a series of architectural optimizations that dramatically improve latency, availability, and scalability.

LBScloud storageindexing
0 likes · 9 min read
How Baidu’s LBS Cloud Storage Revolutionizes Massive Geospatial Data Retrieval
Architect
Architect
Mar 3, 2016 · Databases

Understanding InnoDB Adaptive Hash Index (AHI) Mechanism

This article explains how InnoDB's Adaptive Hash Index works, covering its initialization, information gathering, index and block statistics updates, page‑level hash construction, usage conditions, maintenance procedures, shortcut query mode, and monitoring via performance metrics.

Adaptive Hash IndexDatabase OptimizationInnoDB
0 likes · 15 min read
Understanding InnoDB Adaptive Hash Index (AHI) Mechanism
Architect
Architect
Mar 2, 2016 · Databases

InnoDB Full-Text Index Architecture and Operations in MySQL 5.7

This article explains MySQL InnoDB full-text indexing, covering supported modes, auxiliary tables, creation, DML handling, query processing, transaction management, cache synchronization, optimization, background threads, monitoring, stopwords, plugins, and the built‑in n‑gram parser, with code references from MySQL 5.7.

DatabaseFull-Text SearchInnoDB
0 likes · 17 min read
InnoDB Full-Text Index Architecture and Operations in MySQL 5.7
High Availability Architecture
High Availability Architecture
Jan 20, 2016 · Databases

MongoDB Storage Engine Evolution, Replication Enhancements, and New Features

The article reviews MongoDB's storage engine developments—including MMAP, WiredTiger, RocksDB, and Memory engines—highlights replication protocol improvements, automatic sharding changes, and introduces new features such as batch and partial indexes, document validation, and join capabilities, while providing performance test results and a Q&A section.

MongoDBStorage EngineWiredTiger
0 likes · 14 min read
MongoDB Storage Engine Evolution, Replication Enhancements, and New Features
ITPUB
ITPUB
Dec 30, 2015 · Databases

Essential MySQL DBA Interview Guide: Key Topics & Evaluation Checklist

This guide outlines a structured MySQL DBA interview process, covering self‑introduction, resume deep‑dive, career‑development questions, fundamental knowledge such as index types, core technical skills like backup, replication and performance troubleshooting, and broader potential areas including Linux and programming language proficiency.

DBADatabaseInterview
0 likes · 8 min read
Essential MySQL DBA Interview Guide: Key Topics & Evaluation Checklist
ITPUB
ITPUB
Dec 21, 2015 · Databases

Master MySQL Indexes: BTREE, Hash, and Query Optimization Secrets

This article explains MySQL's indexing mechanisms—including BTREE and hash structures, page layout, index types, and practical query patterns—while showing how to interpret EXPLAIN output and avoid common pitfalls for efficient database performance.

BTreeDatabaseHash Index
0 likes · 19 min read
Master MySQL Indexes: BTREE, Hash, and Query Optimization Secrets
Efficient Ops
Efficient Ops
Dec 7, 2015 · Backend Development

Mastering the ELK Stack: From Lucene Indexing to ElasticSearch Queries

This article walks through the fundamentals of search engine architecture, explains Lucene's role as an indexing library, details ElasticSearch's distributed design, clustering, sharding, and plugins, and demonstrates practical RESTful API usage and query DSL techniques for effective log analysis.

Searchbackendindexing
0 likes · 23 min read
Mastering the ELK Stack: From Lucene Indexing to ElasticSearch Queries
Architect
Architect
Oct 31, 2015 · Databases

MySQL High‑Performance Architecture and Optimization Techniques

This article provides a comprehensive guide to MySQL performance optimization, covering isolation levels, MVCC, schema design, index strategies, query execution, partitioning, replication, scaling, hardware considerations, and backup/recovery techniques for building high‑performance, reliable database systems.

Isolation Levelsbackupindexing
0 likes · 22 min read
MySQL High‑Performance Architecture and Optimization Techniques
Qunar Tech Salon
Qunar Tech Salon
Oct 10, 2015 · Fundamentals

Overview of Search Engine Architecture and Core Technologies

This article provides a comprehensive overview of search engine evolution, core technologies such as crawling, indexing, retrieval and link analysis, platform foundations including cloud storage and computing, and techniques for improving search results through anti‑spam, user‑intent analysis, deduplication and caching.

Cloud ComputingLink Analysiscrawling
0 likes · 15 min read
Overview of Search Engine Architecture and Core Technologies
Java High-Performance Architecture
Java High-Performance Architecture
Jul 16, 2015 · Databases

When MySQL Indexes Fail: 4 Common Pitfalls to Avoid

This article explains four situations where MySQL will ignore indexes—using a non‑leading column in a composite index, leading wildcards in LIKE queries, OR conditions with non‑indexed fields, and unquoted string literals—offering guidance to improve query performance.

Database OptimizationSQLindexing
0 likes · 3 min read
When MySQL Indexes Fail: 4 Common Pitfalls to Avoid
Architect
Architect
Jul 9, 2015 · Databases

Building a Flexible, Searchable, Low-Latency Product Catalog with MongoDB

This article explains how retailers can replace costly ETL‑driven vendor systems with a centralized MongoDB‑based service architecture, detailing data models for products, variants, store‑specific pricing, and multi‑facet search, and showing query and indexing techniques to achieve fast, reliable catalog access.

MongoDBProduct CatalogRetail Architecture
0 likes · 11 min read
Building a Flexible, Searchable, Low-Latency Product Catalog with MongoDB
MaGe Linux Operations
MaGe Linux Operations
Apr 14, 2015 · Databases

Unlocking MySQL 5.7 JSON: Native Support, Indexing, and Virtual Columns

This article explains how MySQL 5.7 introduced native JSON support with validity checks, performance improvements, and virtual column indexing, compares it to MariaDB's dynamic column and PostgreSQL, and provides step‑by‑step SQL examples for creating, inserting, querying, and indexing JSON data.

DatabaseJSONVirtual Columns
0 likes · 5 min read
Unlocking MySQL 5.7 JSON: Native Support, Indexing, and Virtual Columns
Baidu Tech Salon
Baidu Tech Salon
Jan 12, 2015 · Artificial Intelligence

Boolean Algebra and Search Engine Technology

The article outlines how search engines combine the Tao of underlying principles—crawling, binary‑based Boolean indexing, PageRank matrix calculations, and TF‑IDF weighting—with specific Shu implementations to efficiently retrieve, rank, and present relevant web pages using Boolean logic, link analysis, and term relevance metrics.

PageRankTF-IDFalgorithm
0 likes · 7 min read
Boolean Algebra and Search Engine Technology