Database Optimization

An In-Depth Analysis of Buffer Pool in InnoDB

This article aims to focus on the core functionalities of the Buffer Pool, providing an introduction to its interfaces, memory organization, page retrieval, and flushing.

Implementing PostgreSQL Hook: Stats on Tables with Full Scans & Corresponding SQLs

This article provides a guide to implementing a PostgreSQL hook for tracking and gathering detailed statistics on tables undergoing full scans and their corresponding SQL statements.

Database Performance Optimization for High-concurrency Queue Processing Business

This article provides optimization methods and a demo for database performance optimization for queue processing business.

An Example of PostgreSQL join+order by limit Optimization

This article illustrates the key role of data distribution and scanning methods for optimization.

A Comparison of Data Modeling Methods for Big Data

Organizations need to invest in appropriate data models to draw insights from them. This article gives an overview of data modeling methods and introduces Alibaba Cloud’s Big Data modeling practices.

Learning about Distributed Systems – Part 9: An Exploration of Data Consistency

Part 9 of this series introduces the replica mechanism for high availability and discusses data consistency.

400x Faster HTAP Real-time Data Analysis with PolarDB

In this article, we‘ll discuss the development process of PolarDB MySQL and share our thought process behind the scheme selection.

PostgreSQL-Based Automatic Performance Diagnosis and Optimization

This short article discusses Postgres Query Analysis and optimization.

Jingdong: Flink SQL Optimization Practice

This article focuses on the optimization measures of Jingdong in Flink SQL tasks, focusing on the aspects of shuffle, join mode selection, object reuse, and UDF reuse.

A Detailed Explanation of the Detection and Processing of BigKey and HotKey in Redis

This blog introduces BigKey and HotKey in Redis and discusses what leads to HotKeys or BigKeys, how to recognize HotKeys or BigKeys, further, the problem it brings, and ways you can take to handle.

An Introduction to Subqueries

This article shares the optimization techniques of subqueries and tips on handling subqueries in distributed databases.

Detailed Explanation of Query Rewriting Based on Materialized Views

This article describes the definition of materialized view for databases and ways to rewrite queries based on it.

How to Implement Join Operation on Distributed Databases

This article explores several ways for implementing join on distributed databases, namely Lookup Join using PolarDB-X.

Query Performance Optimization – Runtime Filter

In this blog, we'll introduce Runtime Filters and discuss how it can help improve query performance of the Join operation for databases.

Making SQL Optimizer More Accurate: AnalyticDB for PostgreSQL Auto Analyze Feature

This blog introduces the AnalyticDB for PostgreSQL Auto Analyze Feature and discusses how it helps users collect more accurate statistical information.

On the Analysis of Sharding

This article provides a detailed analysis on changing a single database with a single table into multiple databases with multiple tables through sharding.

Secondary Index in Alibaba Cloud ClickHouse – Best Practices

This article introduces several methods for optimizing single-table analysis and query performance of ClickHouse and describes the DDL syntax in detail.

Flink: How to Optimize SQL Performance Using Multiple-input Operators

In this article, the author explains how to optimize SQL performance in Apache Flink using multiple-input operators.

PostgreSQL: How libpq Helps Configure Multi-Backend Connection Preferences

In this article, the author explains how libpq can support configuring multiple backend connection preferences, including read-only, prefer-read, and prefer-write.

How to Use PostgreSQL log_fdw to Query Logs

In this article, the author explains how to use PostgreSQL log_fdw to query log data directly in ApsaraDB RDS for PostgreSQL.