Percona

AUGUST 8, 2023

Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database. Global caches like the InnoDB buffer pool and MyISAM key cache and session-level caches like the sort buffer, join buffer, random read buffer, etc. Do these queries use more caches?

Traffic 90

Traffic Cache Monitoring Database 90

Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. One of the most effective ways to tackle performance improvement is having the proper indexes for the table columns. Next is the table definition.

Best Practices 93

Best Practices Tuning Database Testing 93

The Morning Paper

NOVEMBER 14, 2019

Sharing is caring caching. Therefore friend groups all end up accessing similar content, a fact that can be exploited in the backend to improve cache utilisation. The deployment of connection-aware routing reduced query-load on backend databases by 17%, compared to a baseline implementation using Social Hash alone.

Traffic 42

Traffic Internet Internet Latency 42

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 128

Internet Internet AWS Performance 128

The Netflix TechBlog

MARCH 6, 2019

Disk Caching? — ? MezzFS can be configured to cache objects on the local disk. Regional caching? —?Netflix If an application in region A is using MezzFS to read from an object stored in region B, MezzFS will cache the object in region A. we only pay the transfer costs for one worker, and the rest use the cached object.

Media 214

Media Storage Processing Cache 214