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

How Bloom Filters Work in MyRocks

Percona

For good performance, the filter blocks are cached in the RocksDB block cache and normally stay there since they are accessed frequently. LSM storage engines like MyRocks are very different from the more common B-Tree-based storage engines like InnoDB. Download Percona Distribution for MySQL Today

Storage 128
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 127
article thumbnail

Best practices and key metrics for improving mobile app performance

Dynatrace

This includes how quickly the application loads, how much load it is putting on the device, how much storage is being used, and how frequently it crashes. User acquisition measures the number of new users downloading and installing an app. Some of the most important KPIs are listed below. Optimize images and videos.

article thumbnail

MySQL Key Performance Indicators (KPI) With PMM

Percona

This includes metrics such as query execution time, the number of queries executed per second, and the utilization of query cache and adaptive hash index. query cache: Disable (query_cache_size: 0, query_cache_type:OFF) innodb_adaptive_hash_index: Check adaptive hash index usage to determine its efficiency.

article thumbnail

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

Percona

Download the eBook now What are the Common Performance Issues in MySQL Databases? Inadequate CPU, memory, or storage can lead to bottlenecks and performance degradation, so remedying these issues involves upgrading hardware or optimizing resource utilization through query and server configuration adjustments.

Tuning 52
article thumbnail

Cache-Control for Civilians

CSS Wizardry

To this end, having a solid caching strategy can make all the difference for your visitors. ?? How is your knowledge of caching and Cache-Control headers? That being said, more and more often in my work I see lots of opportunities being left on the table through unconsidered or even completely overlooked caching practices.

Cache 264