启用真管道化批量执行。，基于 ADO.NET 标准接口实现，直接通过 TCP 通信实现 MySQL 协议层（Protocol Version 10），完全不依赖 NewLife 团队以外的任何第三方组件，采用。管道化模式（Pipeline=true）：批量发送 → 一次 Flush → 批量读取，耗时 ≈ 1 × 网络延迟 + N × 服务器处理时间。：内置多种批量操作方案（字典参数集 /...

DELETE 的管道化加速比高于 INSERT/UPDATE，原因：DELETE 操作的 InnoDB 标记删除+清理回收开销较大，事务批量提交的 group commit 收益更明显。管道化在 UPDATE 场景的优势最为显著，因为 UPDATE 的单行开销（索引查找+行锁+redo log）比 INSERT 更大，管道化+事务的 group commit 收益更高。原理：事务将多条...

As we mark the milestone of MySQL’s 30-year anniversary, the celebrations around the globe have been a testament to the widespread impact and popularity of the Dolphin. This week’s annual...

The new protocol dissector for X Protocol in MySQL was just merged to the master branch in Wireshark. To get it build Wireshark from the master branch or wait for the next release.This protocol is...

MySQL 8.0 is scheduled for End of Life (EOL) in April 2026. In line with this milestone, we previously announced in this Oracle blog post that all existing MySQL HeatWave instances running version...

目前有三种将 PostgreSQL 与 DuckDB 集成的方案：pg_duckdb（仅支持存量数据迁移）、pg_mooncake（支持存量和增量数据同步）以及 pg_lake（仅支持全量数据导入）。PostgreSQL 的逻辑复制能力较弱，且缺乏可插拔存储引擎，而 MySQL 的设计更适合支持 DuckDB 的列存，并且其 binlog 机制对生态支持良好。

MySQL 连接数查询对性能排查至关重要。可通过命令查看当前连接数、连接列表和最大连接数。大部分连接处于空闲状态，应根据并发情况调整连接池设置，以避免超出最大连接数导致错误。

MySQL is taking a significant step forward by rethinking how foreign key constraints and cascades are managed. Starting with MySQL 9.6, foreign key checks and cascade operations will be handled...

I am not intentionally trying to upset anyone with this blog post or minimize the efforts of many brilliant people whom I admire. However, I connected with several people over the 2025 holidays...

MySQL的插件式存储引擎架构支持多种存储引擎，主要包括默认的InnoDB（适合OLTP）和专为OLAP设计的DuckDB。DuckDB与MySQL兼容，提升查询性能并降低存储成本。

As a follow-up to our previous blog post, we are excited to invite you to a variety of shows, meetups, and events that we will be participating in from January 2026 through April 2026. Below, you...

MySQL Studio in Oracle Cloud Infrastructure MySQL Studio in Oracle Cloud Infrastructure (OCI) is a unified environment for working with MySQL and HeatWave features through a single, streamlined...