Percona
MARCH 23, 2023
This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7
Percona
OCTOBER 3, 2023
Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. The concept of HugePages in Linux has existed for many years, first introduced in 2007.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Percona
JANUARY 14, 2019
What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.
Percona
DECEMBER 19, 2023
The simplest way to run it for testing is to use the docker container: docker run --name pg-tde -e POSTGRES_PASSWORD=mysecretpassword -d perconalab/postgres-tde-ext This command starts a container with the extension loaded and already enabled for the Postgres database.
Percona
DECEMBER 21, 2023
The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. However, for 16 years since 2007, the MySQL query optimizer has had a “bug” that not only makes LIMIT 1 slower than LIMIT 10 but can also make the former a table scan, which tends to cause problems.
Percona
APRIL 12, 2023
MongoDB started out in 2007 as 10gen, a New York-based company looking to create a Platform as a Service (PaaS) solution. They came up with a horizontally scalable NoSQL database. Is MongoDB an open source NoSQL database? Here are other key developments in company history: 2013: 10gen changes its name to MongoDB, Inc.
SQL Performance
JULY 16, 2019
For many years, I explicitly advised people not to run their SQL Server workloads on AMD hardware because of the much lower single-threaded CPU performance and consequently higher SQL Server core license costs. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.
Expert insights. Personalized for you.
126 
Let's personalize your content