小红花·文摘
  • 首页
  • 广场
  • 排行榜🏆
  • 直播
  • FAQ
沉浸式翻译 immersive translate
Dify.AI

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

MySQL 8.0 JSON Functions: Practical Examples and Indexing

Planet MySQL
Planet MySQL · 2026-02-21T22:39:00Z
致甲骨文的公开信:让我们谈谈MySQL的未来

在旧金山和布鲁塞尔举行的MySQL社区峰会上,参与者讨论了MySQL的未来。MySQL面临受欢迎程度下降的风险,PostgreSQL成为新项目的首选。为重振MySQL,呼吁建立非营利基金会以促进开放创新,并与Oracle合作。希望通过公开信团结社区,推动MySQL发展。

致甲骨文的公开信:让我们谈谈MySQL的未来

Percona Database Performance Blog
Percona Database Performance Blog · 2026-02-17T15:07:32Z

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

preFOSDEM MySQL Belgian Days 2026 Recap: Real-World Ops, New Features, and RockStar Moments

Planet MySQL
Planet MySQL · 2026-02-17T12:31:39Z
How to Enable the MySQL Optimizer Trace

在MySQL中,可以通过开启优化器跟踪来分析索引使用情况,从而了解优化器如何处理查询以及未使用预期索引的原因。

How to Enable the MySQL Optimizer Trace

Nicksxs's Blog
Nicksxs's Blog · 2026-02-15T14:51:13Z

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

Introducing MySQL Backup Export in MySQL HeatWave

Planet MySQL
Planet MySQL · 2026-02-13T12:32:47Z
VillageSQL作为一个专注于扩展的MySQL分支发布

VillageSQL是一个新开源项目,旨在提升MySQL的可扩展性,特别针对AI和代理工作负载。它提供结构化扩展框架,允许用户打包自定义数据类型和函数,促进“无权限创新”。初始版本包含多个示例扩展,现已开放供社区测试和反馈。

VillageSQL作为一个专注于扩展的MySQL分支发布

InfoQ
InfoQ · 2026-02-13T06:52:00Z

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

MySql客户端驱动NewLife.MySql

dotNET跨平台
dotNET跨平台 · 2026-02-13T00:02:09Z

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

NewLife.MySql 性能测试报告

dotNET跨平台
dotNET跨平台 · 2026-02-13T00:02:09Z

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

New Era of MySQL Community Engagement

Planet MySQL
Planet MySQL · 2026-02-12T15:53:33Z

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

Making MySQL AI-Ready: How MyVector and ProxySQL Work Together

Planet MySQL
Planet MySQL · 2026-02-11T18:34:22Z

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

Wireshark now can decode MySQL X Protocol

Planet MySQL
Planet MySQL · 2026-02-08T17:40:00Z

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

Bringing GenAI to Every MySQL Instance: ProxySQL v4.0

Planet MySQL
Planet MySQL · 2026-02-08T16:14:20Z
浅析下mysql的索引的基数与可选择性

文章讨论了索引的基数和可选择性,基数是字段值的差异度。高基数能提高索引效率,尤其在MySQL中。可通过查询information_schema.statistics查看表的基数值。

浅析下mysql的索引的基数与可选择性

Nicksxs's Blog
Nicksxs's Blog · 2026-02-08T12:56:37Z

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

Extending MySQL 8.0 support in MySQL HeatWave

Planet MySQL
Planet MySQL · 2026-02-05T21:48:32Z

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

为什么我认为 MySQL 比 PostgreSQL 集成 DuckDB 更加的优雅?

baotiao
baotiao · 2026-02-04T00:00:00Z

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

MySQL 连接数:为什么你的服务器总“Too many connections”?连接池的配置和优化

大象笔记 - Notes of Elephant Leg
大象笔记 - Notes of Elephant Leg · 2026-02-02T09:26:29Z

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

No More Hidden Changes: How MySQL 9.6 Transforms Foreign Key Management

Planet MySQL
Planet MySQL · 2026-01-30T11:54:51Z

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.

How to Reset MySQL Root Password

Planet MySQL
Planet MySQL · 2026-01-28T18:30:00Z
MySQL中MyVector插件的范围向量搜索 — 第三部分

本文介绍了MySQL中的MyVector插件,强调了语义搜索的重要性及其实际应用。通过示例展示了向量搜索、文档检索和聊天消息重排序的功能。MyVector v1.26.1版本增强了Docker支持,突出了无需单独数据库即可实现向量搜索的优势。接下来将探讨MyVector与ProxySQL的集成。

MySQL中MyVector插件的范围向量搜索 — 第三部分

Planet MySQL
Planet MySQL · 2026-01-27T09:30:00Z

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

Dave Stokes: Is the future of MySQL PostgreSQL (Or MariaDB, or TiDB, or ...)?

Planet PostgreSQL
Planet PostgreSQL · 2026-01-25T16:45:00Z
  • <<
  • <
  • 1
  • 2 (current)
  • 3
  • 4
  • >
  • >>
👤 个人中心
在公众号发送验证码完成验证
登录验证
在本设备完成一次验证即可继续使用

完成下面两步后,将自动完成登录并继续当前操作。

1 关注公众号
小红花技术领袖公众号二维码
小红花技术领袖
如果当前 App 无法识别二维码,请在微信搜索并关注该公众号
2 发送验证码
在公众号对话中发送下面 4 位验证码
小红花技术领袖俱乐部
小红花·文摘:汇聚分发优质内容
小红花技术领袖俱乐部
Copyright © 2021-
粤ICP备2022094092号-1
公众号 小红花技术领袖俱乐部公众号二维码
视频号 小红花技术领袖俱乐部视频号二维码