article thumbnail

MySQL Data Caching Efficiency

Percona

A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. How do you know if your MySQL database caching is operating efficiently?

Cache 90
article thumbnail

Supporting Diverse ML Systems at Netflix

The Netflix TechBlog

Once we have discovered the Parquet files to be processed, MetaflowDataFrame takes over: it downloads data using Metaflow’s high-throughput S3 client directly to the process’ memory, which often outperforms reading of local files. Recently, we added support for the write path, so tables can be updated as well using the library.

Systems 226
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

Five Data-Loading Patterns To Improve Frontend Performance

Smashing Magazine

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. It essentially describes the lifetime of each file you download to load your page from the network. It is important to note how much data the client needs to download. Caching Schemes.

Cache 126
article thumbnail

MySQL Key Performance Indicators (KPI) With PMM

Percona

We will also discuss related configuration variables to consider that can impact these KPIs, helping you gain a comprehensive understanding of your MySQL server’s performance and efficiency. Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution.

article thumbnail

How Bloom Filters Work in MyRocks

Percona

A bloom filter is a space-efficient way of storing information about a list of keys. For good performance, the filter blocks are cached in the RocksDB block cache and normally stay there since they are accessed frequently. Download Percona Distribution for MySQL Today At its base, there is a bitmap and a hash function.

Storage 127
article thumbnail

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

Percona

Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. Let’s explore these benefits in more detail.

Tuning 52
article thumbnail

Slower Memory Zeroing Through Parallelism

Randon ASCII

A bug had been filed suggesting that Chrome download speeds (such as those measured by speedtest.net ) seemed to be affected by some anti-virus software. Downloads go through the cache, the cache is saved to disk, and saves to disk are slowed by (some) anti-virus software. As usual, I was minding my own business.

Cache 105