Community

Blog Events Webinars Tutorials Forum
  1. Blog
  2. Events
  3. Webinars
  4. Tutorials
  5. Forum
Create Account
×

ApsaraDB

19512 Reputation

Database branding & operation

Follow
Activities(50) Posts(401) Series(12) Areas of Expertise Following Followers
Areas of Expertise

Following (0)

See All

Followers (81)

See All

Introduction to the Core Features of the Partitioned Table in PolarDB for PostgreSQL

This article introduces the advantages of partitioned table strategies and discusses query optimization features and index options for PolarDB for PostgreSQL.

Inefficient Indexes in the Database

This article summarizes some common inefficient indexes and the causes of their inefficiency.

Introduction to Application Scenarios of PostgreSQL JSON and Optimization of Shared Detoast

This article introduces the application scenarios of PostgreSQL JSON and the optimization of Shared Detoast.

[Infographic] Highlights | Database New Features in June 2024

Discover the latest database product updates for June 2024 in our informative infographic!

Core Technology of PolarDB-X Storage Engine | Index Lookup Optimization

Have you ever encountered difficulties with database index lookups? This article reveals the optimization techniques of PolarDB's storage engine.

[Infographic] Highlights | Database New Feature in May 2024

Discover the latest database product updates for May 2024 in our informative infographic!

Official Open Source of PolarDB-X V2.4 Columnar Engine

This article introduces the architecture and release notes of PolarDB-X V2.4 and the new clustered columnar index (CCI) feature in PolarDB-X v2.4.

Building High-Availability Routing Service for PolarDB-X Standard Edition Using ProxySQL

This article describes how to quickly build and configure PolarDB-X Standard Edition and ProxySQL, and provides verification tests to validate the high-availability routing service.

Point-in-Time Recovery for PolarDB-X Operator: Leveraging Two Heartbeat Transactions

This article explains PolarDB-X Operator's global PITR (point-in-time recovery) achievement for XA/TSO transactions and introduces a two-heartbeat transaction recovery method.

Safeguarding Your Data with PolarDB-X: Backup and Restoration

This article describes the backup and restoration features of PolarDB-X.

Interpretation of Global Binlog and Backup and Restoration Capabilities of PolarDB-X 2.0

This article delves into PolarDB-X 2.0's Global Binlog feature and its backup and restoration functionalities, highlighting their role in preventing data silos and safeguarding database information.

What are the Differences Between PolarDB-X and DRDS?

This article analyzes the similarities and differences between PolarDB-X and DRDS from different perspectives.

Insights into the Selection of PolarDB XPlan Indexes

This article introduces a local index algorithm on CN: XPlan index selection.

PolarDB-X Optimizer Core Technology: Execution Plan Management

This article discusses the importance of SQL Plan Management in maintaining stable database performance by optimizing the execution plan and managing multiple plans for a single SQL query.

Detailed Explanation of MySQL Character Set and Collation

This article explains the relationship between the Unicode standard and the various character sets in MySQL, with a detailed introduction to the defau.

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.

Analysis of MySQL Cost Estimator

This article introduces the principle of cost estimation and the implementation details of MySQL.

Alibaba Cloud PolarDB Awarded ICDE 2024 Industry and Applications Track Best Paper Award

The article introduces Alibaba Cloud's award-winning database PolarDB and its innovative solution to the problem of cross-machine transaction migration in serverless databases.

Starter Guide | AnalyticDB for PostgreSQL TPC-H Benchmark Testing in One Click

This tutorial describes how to run TPC-H benchmark on AnalyticDB for PostgreSQL.

[Infographic] Highlights | Database New Feature in April 2024

Discover the latest database product updates for April 2024 in our informative infographic!

Latest Comments

5094515609765557 Commented on How to Claim PolarDB Resources for Free

yes

rambo Commented on Running TPC-H Benchmark on AnalyticDB PostgreSQL

It's correct. There is no need to define a foreign key, index, etc., because it uses similar names in DDL for the columns that refer to the same value. For example, 'NATIONKEY' is configured as 'c_nationkey' in the CUSTOMER table and as 'n_nationkey' in the NATION table. Then when running the TPC query workload (DML), it uses a WHERE condition like 'WHERE c_nationkey = n_nationkey' to filter.

5646998924277397 Commented on Best Practice: Migrate AWS ElastiCache to Alibaba Cloud Tair via RIOT

6666

Kidd Ip Commented on An Excellent Three-Year Cooperation between MongoDB and Alibaba Cloud

Looking forward to further integration on PaaS!

HrimfaxiYKW Commented on MySQL Deep Dive - Implementation and Acquisition Mechanism of Metadata Locking

Great article! Additionally, I have a question to ask the author. Will all the paths for acquiring `mdl` converge to `acquire_lock`? If so, does it mean that I only need to obtain all the `mdl_key` and their corresponding durations within one thread (`thd`), in order to construct an `mdl_request` in another MySQL process and fully replicate the `mdl` information?