1
UUIDs are popular, but bad for performance (2019)
MySQL UUIDs are still very popular despite a majority of posts warning against their usage. Learn what UUIDs are and why they are very bad for MySQL performance.
Percona Blog
Enterprise-class open source database software, support and services for MySQL, PostgreSQL, MongoDB, Redis and MariaDB.
- Popular posts
- 12
- Total points
- 2,002
- HN comments
- 739
- Rank
- #615 company
Visit percona.com → RSS feedOn Hacker News Nov 2017 – Aug 2022
Databases & Data 11Systems & Performance 7Software Engineering 5Infrastructure & DevOps 1
2
PostgreSQL on ARM-Based AWS EC2 Instances
With the second gen of Graviton2 instances announced, we decided to take a look at the price/performance from the standpoint of running PostgreSQL.
3
MySQL Challenge: 100k Connections
It's not beyond possibility to set up MySQL to achieve 100,000 concurrent connections if you balance network config and use thread pools. By Vadim Tkachenko
4
Parallelism in PostgreSQL
Parallelism in PostgreSQL was implemented as part of multiple features which cover sequential scans, aggregates, and joins.
5
About ZFS Performance
You likely know I like the ZFS filesystem a lot. ZFS stores the files in B-trees in a similar fashion as InnoDB stores data.
6
ZFS from a MySQL perspective
As the purpose of a database system is to store data, there is close relationship with the filesystem. Yves Trudeau reconsiders the use of ZFS with MySQL.
7
MySQL vs. MariaDB: Reality Check
Choosing between MariaDB and MySQL? In this blog, we provide an overview of the key differences between MariaDB vs. MySQL and explore their unique use cases.
8
PostgreSQL 15: Stats Collector Gone? What’s New?
Yes, the stats collector is gone from PostgreSQL 15, but there's lots of new exciting features to talk about!
9
Linux Fsync Issue for Buffered IO and Its Preliminary Fix for PostgreSQL
With the latest upgrades to PostgreSQL the fsync failure had been fixed. Avinash Vallarapu takes a look at why this issue might cause problems.
10
A Look at MyRocks Performance
Taking a look at MyRocks performance through some benchmark testing.
11
Pg_stat_monitor – better insights into query performance in PostgreSQL
Percona has developed a new pg_stat_monitor plugin for PostgreSQL which captures all the details in order to provide deep query performance insights.
12
AMD EPYC Performance Testing with systemd
With packet.net making bare metal servers available to cloud users, Percona CTO Vadim Tkachenko enjoys the opportunity to carry out some performance benchmarks with EPYC CPU, and experiences some surprising results running Percona Server for MySQL under systemd.