Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52

Tuning Database Performance Hardware 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 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?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it. Next is the table definition.

Best Practices 87

Best Practices Tuning Database Testing 87

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Therefore, establishing a strong backup strategy is essential to ensure data security and minimize potential disruptions. In order to implement effective full backups of your database, you must follow some best practices.

Storage 66

Storage Strategy Network Efficiency 66

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. These benefits collectively contribute to a more efficient database environment.

Strategy 40

Strategy Storage Database Best Practices 40

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Definitely read up on the strategy and reasoning behind this stack in the first article if you missed it. Now, let’s dive into the technical features and best practices that my team adopted in the process of building the WaterBear web app.

Cache 73

Cache Strategy Best Practices Design 73

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. This affects the type and range of characters that can be inserted into the column.

Performance 52

Performance Storage Social Media Database 52

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. Although landing pages are a common practice in online marketing, we were trying to make the most of it.

Performance 75

Performance Cache Traffic Metrics 75

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. What is a Trigger in MySQL?

Cache 60

Cache Database Games Healthcare 60