This post covers a hands-on walkthrough of MySQL 8.0's JSON functions. JSON support has been in MySQL since 5.7, but 8.0 added a meaningful set of improvements — better indexing strategies, new...

Right before FOSDEM kicked off, the preFOSDEM MySQL Belgian Days returned to the usual place in Brussels for two packed days (Jan 29-30, 2026). The format stayed true to what makes this event...

We are pleased to introduce the ability to export MySQL HeatWave backup data directly to an OCI Object Storage bucket in your tenancy, enabling a one-step process to create an exported backup via...

启用真管道化批量执行。，基于 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...

As AI workloads become standard in modern applications, engineering teams face a familiar dilemma: MySQL is already the system of record, but vector search typically requires bolting on a separate...

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...

The Problem with “Just Migrate” Most organizations are sitting on MySQL deployments they can’t easily change — a mix of community editions, managed cloud services, and legacy versions. Teams want...

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...

In this blog post, we will show you how to reset the MySQL root Password on a Linux operating system. ... Read More The post How to Reset MySQL Root Password appeared first on RoseHosting.

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...