腾讯网

MySQL 中的 distinct和group by 哪个效率更高？

在语义相同，有索引的情况下group by和distinct都能使用索引，效率相同。 在语义相同，无索引的情况下：distinct效率高于group by。原因是distinct 和 group by都会进行分组操作，但group by可能会进行排序，触发filesort，导致sql执行效率低下。 基于这个结论，你可能会问 ...

As Oracle loses interest in MySQL, devs mull future options

As Big Red's governance of the popular database comes into question, contributors to MySQL consider wresting control ...
CNET

Group aims to keep MySQL healthy

One of original authors of MySQL, Michael 'Monty' Widenius, has founded the Open Database Alliance, a consortium that aims to become the industry hub for the open source database. The move was ...
腾讯网

MySQL 8.2 正式可用，支持读写分离

最近，Oracle 宣布 MySQL 8.2 正式可用，包括对读写分离的支持。这一备受期待的特性已经在最新的创新版本中引入，有助于优化数据库性能和提升可扩展性。 读写分离使应用程序能够将所有写入流量定向到读写（主要或源）实例，将所有读取流量定向到只读实例 ...
ZDNet

Group aims to keep MySQL healthy

One of original authors of MySQL, Michael 'Monty' Widenius, has founded the Open Database Alliance, a consortium that aims to become the industry hub for the open source database. The move was ...
TechNode

Ant Group said its new database surpasses MySQL in performance

Click to share on X (Opens in new window) X Click to share on Facebook (Opens in new window) Facebook Chinese fintech giant Ant Group announced the launch of OceanBase 4.0, an enterprise-level ...