ProxySQL 3.0.8通过MySQL的原生会话状态通知改进了会话变量跟踪,能够捕捉存储过程和动态SET语句中的变量变化,提升了连接复用的安全性和准确性,确保了会话一致性。
现代人工智能系统越来越依赖多模态数据,尤其是图像理解。MySQL HeatWave GenAI使得在SQL工作流中直接实现图像理解成为可能,通过生成文本描述并转化为向量嵌入,提供可解释的语义检索。这种方法降低了基础设施成本,简化了AI系统的构建,使其更易于理解和管理。
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...
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...
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....
Slot-based Buffer Manager 设计中的 Pin 本质上是锁定 slot 与当前 page_id 的映射,确保在持有期间不被替换。这种架构在 PostgreSQL 和 InnoDB 中高度一致,提供了裸指针的稳定性,避免频繁的内存分配和查找开销。Pin 的目的是确保指针有效性,支持高并发访问。
MySQL 9.7将于2026年4月发布,Oracle将多个企业版功能移至社区版,包括超图优化器和复制组件。MySQL 8.0已停止支持,用户应尽快升级。新版本增强了密码哈希,支持JSON双重视图的DML操作,并简化了滚动升级过程。未来版本将加入向量搜索功能。
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...
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,...
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...
在处理 `gorm` 错误时,主键冲突错误无法直接用 `errors.Is` 判断。可以通过 `gorm.io/driver/mysql` 的 `Translate` 函数将 MySQL 错误码转换为 `gorm` 错误,从而有效判断插入冲突。
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...
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...
Introduction Replication performance depends on every stage in the pipeline, from the source database to transport and ultimately to commit on the replica. On the replica side, much of that...
I have written a new post on the MySQL blog about the hypergraph optimizer, which is now available in MySQL 9.7 Community Edition. The post gives a high-level technical overview of what is...
On April 21, 2026, our third public discussion continued the conversation around transparency, participation, and the future of MySQL. Building on the momentum from earlier sessions, the...
MySQL 9.7 Community Edition now includes the hypergraph optimizer as an alternative to the classic join optimizer, making this capability available across all MySQL editions. This is not a...
When people ask me how to tune MySQL, they usually mean, “Which variables should I change in my.cnf?” (the MySQL configuration file) That certainly is a reasonable place to start, because most...
As an update to our recent blog post, “Where can you find MySQL next? (Updated events list for March–May 2026)” we’d like to share the latest confirmed MySQL events and webinars, including newly...
As part of our MySQL community engagement plan, which includes delivering new features into MySQL Community Edition, increasing collaboration and transparency, and expanding and growing the MySQL...
完成下面两步后,将自动完成登录并继续当前操作。