Percona

MAY 15, 2023

This operation is quite expensive but our database can run it in a few milliseconds or less, thanks to several optimizations that allow the node to execute most of them in memory with no or little access to mass storage. The key factor is that the whole data structure resides in the same location (node), facilitating the operations.

Traffic 121

Traffic Scalability Database Servers 121

Official Blog - World Web Technology

NOVEMBER 27, 2023

You may have to put off learning web development and design. You can make a great website without coding or advanced web design skills. Anyone can use a good website builder, even if they don’t know web design. It depends on the best practices of web design. Top 5 Website Builders to Choose in 2023!

Website 59

Website Development Mobile Storage 59

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. These issues often arise from suboptimal query design, missing or ineffective indexes, or dealing with large datasets. MySQL relies heavily on the availability of hardware resources to perform at its best.

Tuning 52

Tuning Database Performance Hardware 52

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

OCTOBER 18, 2023

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Look closely at your current infrastructure (hardware, storage, networks, etc.)

Open Source 89

Open Source Database Hardware Strategy 89

Percona

JULY 7, 2023

Where a high availability design once worked well, it can no longer keep up with more complex requirements. The majority of SPOFs are a consequence of scale, where designs that were once adequate (excellent, even) no longer meet evolving, more complex requirements. Can you afford that recovery time?

Availability 82

Availability Open Source Architecture Database 82

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters.

Strategy 52

Strategy Database Storage Open Source 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Character encoding refers to the method used to represent characters as binary data for storage and transmission. This difference in storage size can lead to variations in the size of index entries, which can impact efficiency. while MySQL 5.7

Performance 52

Performance Storage Social Media Database 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

O'Reilly

JULY 25, 2023

Here’s how I worked on it: I subscribed to ChatGPT Plus and used the GPT-4 model in ChatGPT (first the May 12, 2023 version, then the May 24 version) to help me with design and implementation. I liked how ChatGPT helped me work through the tradeoffs of these initial design decisions before diving head-first into coding.

Programming 98

Programming Code Design Benchmarking 98