article thumbnail

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

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
article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. 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
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Application Scalability — How To Do Efficient Scaling

DZone

In this article, we explain why you should pay attention to when building a scalable application. What Is Application Scalability? Application scalability is the potential of an application to grow in time, being able to efficiently handle more and more requests per minute (RPM).

article thumbnail

Migrating Critical Traffic At Scale with No Downtime?—?Part 1

The Netflix TechBlog

Migrating Critical Traffic At Scale with No Downtime — Part 1 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Hundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive streaming experience. It helps expose memory leaks, deadlocks, caching issues, and other system issues.

Traffic 339
article thumbnail

How Bloom Filters Work in MyRocks

Percona

Tuning In terms of tuning, two parameters can be tuned, the size of the bitmap and the number of bits set by every value. For good performance, the filter blocks are cached in the RocksDB block cache and normally stay there since they are accessed frequently.

Storage 125
article thumbnail

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Scalegrid

Once the authentication succeeds: PgBouncer checks for a cached connection, with the same username+database combination. If a cached connection is found, it returns the connection to the client. Stay tuned for our fourth post in this four-part series where we compare PgBouncer vs. Pgpool-II. And that is it!

Cache 246
article thumbnail

InnoDB Performance Optimization Basics

Percona

By caching hot datasets, indexes, and ongoing changes, InnoDB can provide faster response times and utilize disk IO in a much more optimal way. Some cloud providers also offer specialized instances for database workloads, which may provide additional features and optimizations for performance and scalability. I hope this helps!