Top Technology Performance Pulse Benchmarking Cache Content for Mon.Jan 09, 2023

Mon.Jan 09, 2023

Updated Percona Distribution for MySQL, Percona XtraDB Cluster: Release Roundup January 9, 2023

Percona

JANUARY 9, 2023

It’s time for the release roundup! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Open Source

Open Source Database Servers Software

COUNT(*) vs COUNT(col) in MySQL

Percona

JANUARY 9, 2023

Looking at how people are using COUNT(*) and COUNT(col), it looks like most of them think they are synonyms and just use what they happen to like, while there is a substantial difference in performance and even query results. Also, we find a difference in execution on InnoDB and MyISAM engines. NOTE : All tests were applied for MySQL version 8.0.30, and in the background, I ran every query three to five times to make sure that all of them were fully cached in the buffer pool (for InnoDB) or by t

Cache

Cache Engineering Storage Speed

Mon.Jan 09, 2023

Updated Percona Distribution for MySQL, Percona XtraDB Cluster: Release Roundup January 9, 2023

COUNT(*) vs COUNT(col) in MySQL

Stay Connected