Percona Database Performance Blog
The following are the titles of recent articles syndicated from Percona Database Performance Blog
Add this feed to your friends list for news aggregation, or view this feed's syndication information.

LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.

[ << Previous 20 ]
Thursday, February 8th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
3:41 pm
Why Migrating to Open Source is Essential to Your Business Growth
Migrating to Open SourceThe strategic adoption of different database technologies can make or break a company’s success and long-term viability. Among the many types of database software that companies can choose from, one type stands out for its ability to drive innovation, cut costs, and offer unparalleled flexibility: open source software.The freedom of users to access, modify, and […]
Wednesday, February 7th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:57 pm
Decoupling Backup and Expiry Operations in PostgreSQL With pgBackRest
Decoupling Backup and Expiry Operations in PostgreSQL With pgBackRestBackup management is the backbone of any reliable database administration strategy, and while pgBackRest simplifies this process, its default configuration often combines backup and expiry together. At times, due to slow network bandwidth, huge database sizes, or any other resource crunch, expiring backups (i.e., deleting the older backups) require more than taking backups for databases. […]
Tuesday, February 6th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:17 pm
Are Your MySQL Users Using ‘password’ or ‘thebossisajerk’ as Passwords?
MySQL password securityAre your MySQL users using ‘password’, ‘s3cr3t’, or ‘thebossisajerk’ as their passwords? Easy-to-guess passwords can be disastrous to the security of your data, but there is a way to exclude inappropriate words or phrases from being used. The first step is to compile a list of words and phrases you want to exclude, and that […]
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
6:13 pm
MySQL 8.2.0 Community vs. Enterprise; Is There a Winner?
MySQL 8.2.0 Community vs. EnterpriseTo be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base.To my knowledge the differences in the enterprise version are in the additional […]
Monday, February 5th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
4:51 pm
Five Notable Changes in Percona Everest Alpha
changes in Percona Everest AlphaPercona Everest is a cloud-native database platform to deploy and manage enterprise-grade PostgreSQL, MongoDB, and MySQL database clusters.Percona Everest 0.7.0 (Alpha) was released on January 31, 2024. The new version contains significant changes on the backend. However, I will show what is visible to the user. Let’s explore what has improved.1. Installation with everestctl became […]
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
1:38 pm
Percona Monitoring and Management 2.41.1, Percona Distribution for MongoDB 7.0.5: Release Roundup February 5, 2024
Percona ReleasesPercona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.Our Release Roundups showcase the latest Percona software updates, tools, […]
Friday, February 2nd, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
3:00 pm
Considering a MongoDB Migration? Why Percona Should Be Your First Choice
MongoDB MigrationAs a DBA or database architect, you’re well-acquainted with the offerings of MongoDB Community Edition, MongoDB Enterprise, and MongoDB Atlas. Maybe you’re even thinking of jumping ship from your current database over to MongoDB – adventurous, aren’t you? If you are considering a MongoDB migration, before making a commitment to corporate MongoDB, it would be […]
Thursday, February 1st, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
6:26 pm
Simplify the Use of ENV Variables in Percona Monitoring and Management AMI
ENV Variables in PMM AMI.jpgThe Percona Monitoring and Management (PMM) Amazon Machine Image (AMI) currently lacks native support for ENV variables. In this guide, we’ll walk through a straightforward workaround that simplifies the process of using ENV variables in PMM AMI and reapplying them after an upgrade.Step one: Adding ENV variables to /srv/.envBegin by consolidating your ENV variables in […]
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:43 pm
In Search of Transparency at FOSDEM
FOSDEM – In Search of TransparencyFOSDEM is for sure one of the most respected free and open source software-focused conferences in Europe, which is loved by many, myself included. It is from the point of love I am raising concerns about transparency, which seems to be lacking in regard to some processes at FOSDEM.For many years, as long as I […]
Wednesday, January 31st, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:00 pm
MySQL Table Size Is Way Bigger After Adding a Simple Index; Why?
MySQL Table Size Is Way Bigger After Adding a Simple IndexIt is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. This simple rule is mentioned briefly in the official MySQL Documentation:https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.htmlHowever, in some cases, the overhead from adding a new index can be way above the expectations! Recently, I’ve been analyzing a customer case like […]
Tuesday, January 30th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
5:40 pm
PG_TDE Update: Percona’s Project to Add Transparent Data Encryption to PostgreSQL
Transparent Data Encryption to PostgreSQLPG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond that I reviewed last October. There have been a lot of changes that covered in this post. This software is under active development. In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to […]
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
3:36 pm
Master PostgreSQL Upgrades: The Ultimate Checklist
PostgreSQL Upgrade ChecklistAre you planning to upgrade your PostgreSQL database but feeling overwhelmed by the complexity of the task?  We have something that will make your life much easier. Introducing The Ultimate PostgreSQL Upgrade Checklist – designed to guide both seasoned and new DBAs and developers through the intricate process of a PostgreSQL upgrade.Why you need this […]
Monday, January 29th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:52 pm
Percona PG_TDE and Ubuntu: Please Test Transparent Data Encryption for PostgreSQL
Percona PG_TDE and Ubuntu.jpegPostgreSQL differs from certain other databases as it lacks a native solution to encrypt data on disk transparently. At Percona, we are in the process of developing PG_TDE, a tool designed to encrypt data using the AES-CTR encryption algorithm. This code is currently under development, and we are seeking your assistance in testing it.This blog […]
Friday, January 26th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
1:48 pm
Percona PG_TDE and Docker: Please Test Transparent Data Encryption for PostgreSQL
Percona PG_TDE and DockerSecuring your data can be a tough task. Unlike some other databases, PostgreSQL does not have a native solution to encrypt data on disk transparently. Percona is developing PG_TDE to encrypt that data using the AES-CTR encryption algorithm. This code is in development, and we need your help testing it.This blog will cover what you […]
Thursday, January 25th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:37 pm
Decoding Sequential Scans in PostgreSQL
In every database product, sequential scans or full table scans are often resource consuming, so almost all the developers and DBAs see such scans as a performance killer. In my opinion, this is a false perception or biased view. In many cases, sequential scans are proven to be a performance booster. However, due to a […]
Wednesday, January 24th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:00 pm
An Introduction to Vector Databases
An Introduction to Vector Databases.jpegImagine that winter is coming to the south of the planet, that you are going on a vacation trip to Patagonia, and you want to buy some cozy clothes. You go to that nice searcher page that says “do no evil” and write in the search field “Jackets for Patagonia weather,” not thinking of a […]
Tuesday, January 23rd, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
3:07 pm
Common PostgreSQL Upgrade Errors and How to Avoid Them
common PostgreSQL upgrade errorsEveryone usually welcomes an upgrade, whether it’s a new operating system on your phone, a first-class seat on a flight, or a revamped kitchen in your home. Upgrades typically mean improvement, which is true for PostgreSQL, as each new version of PostgreSQL brings updates and enhancements essential for your application’s optimal performance, stability, and security. […]
Monday, January 22nd, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
2:10 pm
Percona Distribution for MongoDB 4.4.27, Updates to Percona Distribution for PostgreSQL, : Release Roundup January 22, 2024
Percona ReleasesPercona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.Our Release Roundups showcase the latest Percona software updates, tools, […]
Thursday, January 18th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
3:08 pm
Syscalls Analysis in MySQL When Using innodb_flush_method and innodb_use_fdatasync
MySQL When Using innodb_flush_method and innodb_use_fdatasyncIn this blog post, we will discuss how to validate at the operating system level the effects of changing the innodb_flush_method to variations other than the default (particularly for O_DIRECT which is most commonly used) and the use of innodb_use_fdatasync.IntroductionFirst, let’s define what the innodb_flush_method parameter does. It dictates how InnoDB manages the flushing of data […]
Wednesday, January 17th, 2024
LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.
1:58 pm
Quick Peek: MySQL 8.0.36 and 8.3
Quick Peek MySQL 8.0.36 and 8.3Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what is new, what is in the seventy-three bugs fixed, and what has changed in the three months since the last releases. Comments in italics are my own and do not reflect the view of anyone […]
[ << Previous 20 ]

LJ.Rossia.org makes no claim to the content supplied through this journal account. Articles are retrieved via a public feed supplied by the site for this purpose.