cd /news/artificial-intelligence/alisql-8-0-44-2-duckdb-vidx-native-f… · home topics artificial-intelligence article
[ARTICLE · art-66686] src=p1p1bear.github.io ↗ pub= topic=artificial-intelligence verified=true sentiment=↑ positive

AliSQL 8.0.44-2: DuckDB, VIDX, Native Flashback, and Transaction Optimizations

Alibaba Cloud released AliSQL 8.0.44-2, an enhanced MySQL 8.0.44 distribution that embeds DuckDB 1.4.4 as an analytical storage engine, adds native VECTOR(N) columns and HNSW indexes for vector search, introduces Native Flashback with AS OF TIMESTAMP queries, and optimizes large transactions with Binlog in Redo and Binlog Cache Free Flush to reduce I/O amplification and latency.

read1 min views7 publishedJul 21, 2026
AliSQL 8.0.44-2: DuckDB, VIDX, Native Flashback, and Transaction Optimizations
Image: source

01

DuckDB analytics

DuckDB 1.4.4 is embedded as an analytical storage engine, with stronger SQL compatibility, DDL, replication, and resource governance.

MySQL 8.0.44 with embedded DuckDB analytics, native vector indexing, Native Flashback, Binlog in Redo, and large-transaction optimizations.

Prebuilt packages and a multi-architecture Docker image are available for Linux x86_64 and ARM64.

WHAT'S NEW

This release expands AliSQL across analytical queries, vector search, recovery workflows, and transaction durability while preserving the MySQL protocol and SQL interface.

01

DuckDB 1.4.4 is embedded as an analytical storage engine, with stronger SQL compatibility, DDL, replication, and resource governance.

02

Native VECTOR(N) columns and HNSW indexes support Euclidean and cosine distance for approximate nearest-neighbor search.

03

Query retained InnoDB history with AS OF TIMESTAMP

to inspect and recover earlier row versions without restoring a full backup.

04

Eligible binlog events are persisted in InnoDB redo, allowing crash recovery to reconstruct a missing binlog tail before normal recovery.

05

Binlog Cache Free Flush avoids a second large cache copy for eligible InnoDB transactions, reducing commit I/O amplification and latency.

In this release, Free Flush applies to eligible InnoDB transactions. DuckDB transactions continue through normal binlog group commit.

GET THE RELEASE

Use the prebuilt Linux packages, pull the multi-architecture image, or build directly from the tagged source. LINUX X86_64

637 MB compressed archive for x86_64 systems.

LINUX ARM64

624 MB compressed archive for aarch64 systems.

DOCKER

songhuaxiong/alisql:8.0.44-2 MANAGED ON ALIBABA CLOUD

Alibaba Cloud RDS for MySQL provides managed editions of these capabilities with production topology, monitoring, backup, and support. Product versions and parameters may differ from this open-source release.

── more in #artificial-intelligence 4 stories · sorted by recency
── more on @alisql 3 stories trending now
sponsored brought to you by zahid.host 4,200+ EU-deployed projects
reading about agents? ship yours in a single git push.

Run your AI side-project on zahid.host

EU-based hosting, git-push deploys, automatic HTTPS, no cold starts. Free tier with a custom domain — perfect for shipping the agent you just read about.

$git push zahid main
Live at https://your-agent.zahid.host
Get free account → Pricing
from €0/mo · no card required
LIVE [news/alisql-8-0-44-2-duck…] indexed:0 read:1min 2026-07-21 ·