This article examines the challenges of querying massive follower lists stored in MySQL, compares limit‑based pagination with tag‑record and range‑limit methods, and offers practical indexing and query‑optimization recommendations for handling tables containing hundreds of millions of rows.
This article compiles practical Elasticsearch recommendations covering query caching, filter contexts, pagination, aggregation strategies, index mapping, shard design, and scripting best practices, providing developers with actionable insights to improve search performance, reduce resource consumption, and prevent common operational issues.
This article explains how to enable MySQL's optimizer_trace feature, retrieve the detailed execution plan from the information_schema.OPTIMIZER_TRACE table, and interpret the cost‑based optimization phases (prepare, optimize, execute) to understand why the optimizer selects a particular index for a query.
This article details Bilibili's practical deployment of an Iceberg lake‑warehouse architecture within its OLAP platform, covering the motivations for lake‑warehouse integration, core Iceberg optimizations such as data‑organization sorting, Z‑order and secondary indexes, the Magnus intelligent management platform, and future roadmap plans.
This article presents twenty practical MySQL optimization techniques—from selecting specific columns and avoiding OR in WHERE clauses to proper indexing, join strategies, and using EXPLAIN—helping developers improve query speed, reduce resource consumption, and write more maintainable SQL code.
The article explains how conventional SQL struggles with executing multiple grouping and Top‑N aggregations on massive tables, leading to repeated full scans and poor performance, and demonstrates how the SPL compute engine can perform these operations in a single pass with parallelism, improving speed and scalability.
This article explains how MySQL generates execution plans using EXPLAIN, details the meaning of each column such as id, select_type, table, type, possible_keys, key, rows, and Extra, and demonstrates how to interpret and improve query performance through examples and code snippets.
