小红花·文摘
  • 首页
  • 广场
  • 排行榜🏆
  • 直播
  • FAQ
Dify.AI

As MySQL HeatWave environments continue to grow, many organizations prioritize scaling compute and storage resources while overlooking a critical area: database housekeeping. Inadequate...

MySQL HeatWave Database Housekeeping Best Practices

Planet MySQL
Planet MySQL · 2026-05-23T06:21:00Z
使用 Kiro 和 MCP 自动化大规模升级 RDS MySQL 8.0 至 RDS MySQL 8.4

本文介绍了RDS MySQL升级助手,这是一款开源工具,旨在自动化将Amazon RDS MySQL 8.0升级至8.4的过程。该工具提供19项SQL预检查和自动化脚本,解决了兼容性评估、参数迁移和应用验证等挑战,显著减少了手动操作的时间和风险。用户可以通过Kiro IDE或CLI轻松执行升级任务,确保过程高效可重复。

使用 Kiro 和 MCP 自动化大规模升级 RDS MySQL 8.0 至 RDS MySQL 8.4

亚马逊AWS官方博客
亚马逊AWS官方博客 · 2026-05-22T08:56:37Z
MySQL 9.7.0 PGO基准分析

本文讨论了MySQL的Profile-Guided Optimization(PGO)技术,强调其在性能上的显著提升。PGO通过运行时分析优化代码,使CPU更高效地执行MySQL的热代码路径,从而提高每秒处理事务的能力。测试结果显示,PGO在不同线程数下带来了0.5%到14.3%的性能提升,尤其在低并发情况下效果显著。

MySQL 9.7.0 PGO基准分析

Planet MySQL
Planet MySQL · 2026-05-22T07:33:49Z

Organizations modernizing transactional database environments are increasingly adopting MySQL HeatWave to simplify operations, improve scalability, increase availability, enhance security and...

Best Practices for MySQL HeatWave Adoption for OLTP and OLAP Workloads

Planet MySQL
Planet MySQL · 2026-05-22T05:30:19Z

Bintrail is a recently introduced layer that brings point-in-time queries and row-history lookups to MySQL, the only major relational database lacking native temporal querying. Using indexed...

Bintrail: MySQL Time-Travel Queries Using Indexed Binlogs

InfoQ
InfoQ · 2026-05-21T17:03:00Z

As organizations modernize their data platforms, MySQL HeatWave has emerged as a powerful solution for running online transactional processing (OLTP) and real-time online analytics processing...

A Practical Guide for MySQL HeatWave Capacity Planning

Planet MySQL
Planet MySQL · 2026-05-21T08:00:39Z

Modern cloud applications are expected to remain available even during infrastructure interruptions, replication failovers, maintenance events, and transient network failures. In distributed...

Designing Resilient APIs with MySQL HeatWave High Availability and Read Replicas

Planet MySQL
Planet MySQL · 2026-05-21T01:57:46Z
ProxySQL 3.0.8如何改进MySQL会话变量跟踪

ProxySQL 3.0.8通过MySQL的原生会话状态通知改进了会话变量跟踪,能够捕捉存储过程和动态SET语句中的变量变化,提升了连接复用的安全性和准确性,确保了会话一致性。

ProxySQL 3.0.8如何改进MySQL会话变量跟踪

Planet MySQL
Planet MySQL · 2026-05-17T00:00:00Z

现代人工智能系统越来越依赖多模态数据,尤其是图像理解。MySQL HeatWave GenAI使得在SQL工作流中直接实现图像理解成为可能,通过生成文本描述并转化为向量嵌入,提供可解释的语义检索。这种方法降低了基础设施成本,简化了AI系统的构建,使其更易于理解和管理。

使用MySQL HeatWave GenAI构建AI视觉搜索引擎

Planet MySQL
Planet MySQL · 2026-05-14T16:54:52Z

Following the strong engagement across the first three editions of our Public MySQL Community Discussion series, we’re pleased to invite you to Edition #4. We will focus on the upcoming...

MySQL Community Update: Public Discussion #4, Design Proposals, and Contributor Summit

Planet MySQL
Planet MySQL · 2026-05-12T15:20:34Z

Oracle has announced the general availability of MySQL 9.7.0, marking the start of a new 9.7 LTS release series and the first major one since MySQL 8.4. The release arrives amid community concerns...

MySQL 9.7: First Major LTS Since 8.4 Brings Enterprise Features to Community Edition

InfoQ
InfoQ · 2026-05-10T06:30:00Z

In modern application development, observability is no longer optional. It is a core requirement for stable operations, faster troubleshooting, and better understanding of system behavior....

A New Era of MySQL Monitoring: OpenTelemetry Metrics with Prometheus

Planet MySQL
Planet MySQL · 2026-05-07T01:58:47Z

Slot-based Buffer Manager 设计中的 Pin 本质上是锁定 slot 与当前 page_id 的映射,确保在持有期间不被替换。这种架构在 PostgreSQL 和 InnoDB 中高度一致,提供了裸指针的稳定性,避免频繁的内存分配和查找开销。Pin 的目的是确保指针有效性,支持高并发访问。

MySQL/PostgreSQL Slot-based Buffer Manager Pin/buf_block_fix operator

baotiao
baotiao · 2026-05-07T00:00:00Z
MySQL 9.7发布,社区获胜

MySQL 9.7将于2026年4月发布,Oracle将多个企业版功能移至社区版,包括超图优化器和复制组件。MySQL 8.0已停止支持,用户应尽快升级。新版本增强了密码哈希,支持JSON双重视图的DML操作,并简化了滚动升级过程。未来版本将加入向量搜索功能。

MySQL 9.7发布,社区获胜

Planet MySQL
Planet MySQL · 2026-05-06T11:37:26Z

Alkin Tezuysal Director of Services at Altinity Inc. MySQL 9.7 came out on April 21 and I’ve been going through the release notes so you don’t have to. The short version: Oracle has made several...

MySQL 9.7 Is Out and the Community Wins

Planet MySQL
Planet MySQL · 2026-05-06T10:39:07Z

Many applications start with a simple database setup: create one MySQL user, give it access to the application schema, put the credentials in the app config, and move on. That may work at first,...

Why Your Application Should Not Use One MySQL User for Everything

Planet MySQL
Planet MySQL · 2026-05-04T20:48:06Z

Once you move from self-managed MySQL to a MySQL DB System with HeatWave on OCI, the tuning story changes in an important way. On a self-managed server, you worry about two layers: MySQL and the...

MySQL Tuning on OCI HeatWave: What Still Matters, What OCI Manages, and What You Should Actually Tune

Planet MySQL
Planet MySQL · 2026-04-30T20:13:58Z

在处理 `gorm` 错误时,主键冲突错误无法直接用 `errors.Is` 判断。可以通过 `gorm.io/driver/mysql` 的 `Translate` 函数将 MySQL 错误码转换为 `gorm` 错误,从而有效判断插入冲突。

gorm 中 MySQL 错误码映射与主键冲突错误处理

了迹奇有没
了迹奇有没 · 2026-04-30T07:03:32Z

MySQL 9.7 introduces a long-requested improvement: Child table triggers are executed during SQL-layer foreign key cascades. Historically, cascades executed inside InnoDB did not invoke child table...

No More Silent Foreign Key Cascades: MySQL 9.7 Lets Child Triggers Speak Up

Planet MySQL
Planet MySQL · 2026-04-30T05:37:57Z

Best practices for MySQL customers and users in an AI-accelerated security landscape: A practical guide to hardening MySQL and the environment around it Oracle recently described how AI is...

AI Is Raising the Bar for MySQL Database Security

Planet MySQL
Planet MySQL · 2026-04-29T23:51:05Z
  • <<
  • <
  • 1 (current)
  • 2
  • 3
  • >
  • >>
👤 个人中心
在公众号发送验证码完成验证
登录验证
在本设备完成一次验证即可继续使用

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

1 关注公众号
小红花技术领袖公众号二维码
小红花技术领袖
如果当前 App 无法识别二维码,请在微信搜索并关注该公众号
2 发送验证码
在公众号对话中发送下面 4 位验证码
友情链接: MOGE.AI 九胧科技 模力方舟 Gitee AI 菜鸟教程 Remio.AI DeekSeek连连 53AI 神龙海外代理IP IPIPGO全球代理IP 东波哥的博客 匡优考试在线考试系统 开源服务指南 蓝莺IM Solo 独立开发者社区 AI酷站导航 极客Fun 我爱水煮鱼 周报生成器 He3.app 简单简历 白鲸出海 T沙龙 职友集 TechParty 蟒周刊 Best AI Music Generator

小红花技术领袖俱乐部
小红花·文摘:汇聚分发优质内容
小红花技术领袖俱乐部
Copyright © 2021-
粤ICP备2022094092号-1
公众号 小红花技术领袖俱乐部公众号二维码
视频号 小红花技术领袖俱乐部视频号二维码