Percona

JANUARY 5, 2023

In PostgreSQL, vacuuming is a maintenance task that helps to optimize database performance and reclaim space. This process is necessary to prevent the accumulation of unnecessary data, known as “dead rows,” which can take up significant space and slow down queries.

Database 106

Database Performance C++ Efficiency 106

Percona

SEPTEMBER 1, 2023

While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. This streamlined process reduces the risk of errors and simplifies the downgrade procedure. implemented improved data integrity checks during the downgrade process.

Database 85

Database Artificial Intelligence Servers Operating System 85

Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Why choose Percona Server for MongoDB? Why release Percona Server for MongoDB 7 now?

Availability 96

Availability Servers Database Open Source 96

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 105

Availability Database Open Source Hardware 105

SQL Shack

OCTOBER 6, 2021

This article explains the internals of the Ghost cleanup task for SQL Server Databases. Introduction Each relational database consists of the background process and user processes.Similarly, SQL Server has many internal processes such as Checkpoint, Lazy Writer, Lock Monitor, System_Health_Monitor, Trace Queue Task and Ghost CleanUp.

Database 83

Database Servers Monitoring Processing 83

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. Through this meticulous process, commits are accurately logged in their respective sequences.

Database 162

Database Strategy Servers Best Practices 162

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Why not have this built it into the server?

Database 184

Database Open Source Storage Servers 184

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. This can negatively impact performance and cause delays.

Servers 109

Servers Best Practices Database Open Source 109

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166

Database Cloud Website Azure 166

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. It’s a complex process involving various factors and meticulous planning. Flexibility and scalability Open source databases provide much greater flexibility regarding customization and configuration.

Open Source 90

Open Source Database Hardware Strategy 90

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

Performance 124

Performance Hardware Tuning Storage 124

SQL Shack

APRIL 7, 2021

This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases. Introduction As a database professional, you confront the performance issues with databases. It is essential to […].

AWS 74

AWS Database Servers Processing 74

Dynatrace

OCTOBER 23, 2023

Secondly, determining the correct allocation of resources (CPU, memory, storage) to each virtual machine to ensure optimal performance without over-provisioning can be difficult. This presents a challenge for IT operations teams, specifically in identifying and addressing performance issues or planning how to prevent future issues.

Efficiency 203

Efficiency Virtualization Hardware Performance 203

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 86

Database Hardware Open Source Strategy 86

DZone

NOVEMBER 2, 2023

When a user logs on to this desktop/laptop or mobile, opens a browser, and types the name of a website, the browser displays the required information, and the user performs an action on the site. It’s an underlying web application architecture that makes this process possible.

Architecture 272

Architecture Mobile Website Servers 272

SQL Shack

APRIL 19, 2021

In this article, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it. SQL Server is a common platform for enterprise-grade database workloads.

Tuning 70

Tuning Servers Performance Database 70

SQL Shack

SEPTEMBER 29, 2020

In this article, we will learn the Delayed Durability feature that helps to improve transaction log file write throughput in SQL Server. OLTP (Online Transaction Processing) databases should process a huge number of transactions within the shortest time and concurrently.

Servers 98

Servers Performance Database Processing 98

Percona

APRIL 3, 2024

One of the most common tasks for database administrators is checking logs; you can either work directly with the file or process it using another tool. Either way, regularly checking the logs remains essential.

Processing 74

Processing Database Servers Performance 74

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 102

Database Benchmarking Latency C++ 102

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 102

Performance Monitoring Traffic Database 102

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend.

Database 81

Database Serverless Tuning Cloud 81

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular. Very popular.

Database 90

Database Servers Processing Efficiency 90

SQL Shack

OCTOBER 14, 2021

Transparent Data Encryption (TDE) encrypts database files to secure your data. It also encrypts the tempdb database to secure your data in a temporary space. The process of encryption and decryption adds additional overhead to the database system.

Servers 79

Servers Performance Database Systems 79

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 94

Database C++ Servers Open Source 94

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. You might already use ScaleGrid hosting for Redis hosting to power your performance-sensitive applications.

Metrics 130

Metrics Monitoring Latency Cache 130

Scalegrid

JANUARY 19, 2024

Key Takeaways Rollbacks in MongoDB are triggered by disruptions in the replication process due to primary node crashes, network partitions, or other failures, which can lead to substantial data loss and inconsistencies. With direct, actionable insights, prepare to navigate the complexities of rollbacks with confidence.

Database 130

Database Network Servers Monitoring 130

Scalegrid

MARCH 28, 2024

In this comparison of Redis vs Memcached, we strip away the complexity, focusing on each in-memory data store’s performance, scalability, and unique features. Redis and Memcached both provide high performance with sub-millisecond response times. Choosing between Redis and Memcached hinges on specific application requirements.

Cache 130

Cache Storage Scalability Architecture 130

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. Default database: 'test'. Want to give it a try?

Servers 160

Servers Database Processing Availability 160

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. The process of registering PMM in the Platform is described in the documentation. Day-2 operations for databases are complex. Try PMM Now.

Database 101

Database Open Source Monitoring Innovation 101

Dynatrace

DECEMBER 9, 2020

Most applications communicate with databases to, for example, pull a catalog entry or submit a new record when an order is placed. To achieve this, there must be a healthy connection between the application and the database. Application servers use connection pools to maintain connections with the databases that they communicate with.

Traffic 136

Traffic Performance Database Metrics 136

Baron Schwartz

MAY 29, 2019

It’s easy for modern, distributed, high-scale applications to hide database performance and efficiency problems. Optimizing performance of such complex systems at scale requires some skill, but more importantly it requires a sound strategy and good observability, because you can’t optimize what you can’t measure.

Efficiency 75

Efficiency Database Performance Strategy 75

SQL Shack

OCTOBER 4, 2021

This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA. Introduction SQL Server system database – MSDB stores SQL Server agent jobs, History, schedules, database mail, service broker, backup, and restore History.

Database 97

Database Servers Systems Processing 97

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. When undertaking any sort of performance optimisation work, one of the very first things we learn is that before you can improve performance you must first measure it. Browsers now even have performance audits built right in.

Servers 88

Servers Performance Metrics Database 88

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 83

Scalability Database Open Source Traffic 83

Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. Typical applications are interacting with different database servers based on the business logic.

Java 130

Java Network Servers Database 130