Percona

APRIL 7, 2023

But since retrieving data from disk is slow, databases tend to work with a caching mechanism to keep as much hot data, the bits and pieces that are most often accessed, in memory. In MySQL, considering the standard storage engine, InnoDB , the data cache is called Buffer Pool. In PostgreSQL, it is called shared buffers.

Tuning 135

Tuning Cache Servers Benchmarking 135

Scalegrid

APRIL 16, 2020

A vast majority of the features are the same, outside of these advanced features available through the BYOC model: Virtual Private Clouds / Virtual Networks. Amazon Virtual Private Clouds (VPC) and Azure Virtual Networks (VNET) are private, isolated sections of the cloud infrastructure where you can launch resources.

Cloud 242

Cloud Azure AWS Database 242

Brendan Gregg

MARCH 16, 2024

Only in extreme circumstances does the cost (in processor time and I-cache footprint) translate to a tangible benefit - circumstances which usually resort to hand-coded assembly anyway. It shouldn't be 10%, unless it's cache effects. And for leaf routines (which never establish a frame), this is a non-issue.

Java 145

Java Cache Google Hardware 145

Percona

DECEMBER 23, 2022

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. I decided to use a virtual machine with two CPU cores, four GB of memory, and storage limited to a maximum of 1000 IOPs of 16KB. InnoDB and MyRocks dataset sizes.

Storage 55

Storage Cache C++ Virtualization 55

Brendan Gregg

FEBRUARY 28, 2023

Titus, the Netflix container management platform, is now open source,” [link] Apr 2018 - [Cutress 19] Dr. DDR6: Here's What to Expect in RAM Modules,” [link] Nov 2020 - [Salter 20] Jim Salter, “Western Digital releases new 18TB, 20TB EAMR drives,” [link] Jul 2020 - [Spier 20] Martin Spier, Brendan Gregg, et al.,

Performance 110

Performance Latency Cache Virtualization 110

The Morning Paper

MARCH 8, 2020

If all data was read from S3 every time, performance would suffer, so of course Snowflake has a caching layer – a distributed ephemeral storage service shared by all the nodes in a warehouse. The caching use case may be the most familiar, but in fact it’s not the primary purpose of the ephemeral storage service. Elasticity.

Storage 112

Storage Engineering Cache Serverless 112

ScaleOut Software

MAY 15, 2014

Given all this, we thought it would be a good opportunity to see how we are doing relative to the competition, and in particular, relative to Microsoft’s AppFabric caching for Windows on-premise servers. One or more specified cache servers are unavailable, which could be caused by busy network or servers. …). Please retry later.

Cache 40

Cache Servers Network Design 40

HammerDB

JUNE 27, 2022

An important concept was to simulate database users called Virtual Users in parallel (rather than concurrently) to accurately simulate a real database workload with multiple users running from separate systems. Cached vs Scaled Workloads. The workload also outputted the data from the Virtual Users by simulating individual terminals.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

DZone

DECEMBER 28, 2020

Virtual Tables. If you're using MySQL or any other SQL-based database, using virtual tables is the best thing that you can do. In that case, you can create virtual tables in your SQL databases, which are sometimes referred as views, and keep all the columns that you want to retrieve from all four tables.

Performance 189

Performance Virtualization Database Processing 189

Dynatrace

APRIL 21, 2022

Getting precise root cause analysis when dealing with several layers of virtualization in a containerized world. Missing caching layers. Here is a summary of the growing list of Dynatrace integrations for Azure: Compute – Dynatrace OneAgent provides full-stack monitoring for Azure Virtual Machine and Virtual Machine Scale Sets.

Azure 181

Azure Monitoring Virtualization Metrics 181

Scalegrid

OCTOBER 2, 2019

The demand for Redis™ is skyrocketing across dozens of use cases, particularly for cache, queues, geospatial data, and high speed transactions. Redis™, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 100

Azure Availability Open Source Virtualization 100

Percona

SEPTEMBER 1, 2023

Exploring How Triggers Impact MySQL Memory Allocation MySQL stores active table descriptors in a special memory buffer called the table open cache. These table cache instances could be accessed concurrently, allowing DML to use cached table descriptors without locking each other.

Cache 60

Cache Database Games Healthcare 60

HammerDB

APRIL 19, 2023

Regardless of whether the computing platform to be evaluated is on-prem, containerized, virtualized, or in the cloud, it is crucial to consider several essential factors. By default, HammerDB is designed to take advantage of database system caching mechanisms such as buffer caches, query caches, or statement caches.

Performance 54

Performance Benchmarking Cache Storage 54

Dynatrace

APRIL 8, 2019

Virtual machines. Virtual machine scale sets. Redis Cache. Automatic handling of API request throttling to support large-scale environments. OOTB dashboard for a quick overview. Supported services. Azure application services. Azure functions. Load balancer. API management. Application gateway. Service Bus queues and topics.

Azure 103

Azure Monitoring Serverless Virtualization 103

IO River

NOVEMBER 2, 2023

Split and Separate Static and Dynamic TrafficStatic traffic is traffic that is cached close to the user and stored and served to them by the nearest server. For example, Amazon CloudFront offers a Reserved CDN pricing plan that can save you up to 30% on bandwidth.‍5. Following these tips will earn appreciation from your CFO.To

Infrastructure 52

Infrastructure Traffic Cache Strategy 52

Percona

MARCH 17, 2023

Virtual Memory utilization was averaging 48 GB of RAM. VictoriaMetrics maintains an in-memory cache for mapping active time series into internal series IDs. Capacity planning and setup details We used a dedicated 32-core CPU and 64GB of RAM for our testing. The CPU usage averaged 24% utilization, as you can see in the above picture.

Monitoring 96

Monitoring Scalability Cache Database 96

HammerDB

FEBRUARY 26, 2024

This is particularly important when running automated workloads back-back to generate a performance profile for a progressively increasing number of virtual users.

C++ 62

C++ Cache Database Virtualization 62

IO River

NOVEMBER 2, 2023

Make sure to never starve a CDN vendor - always keep all vendors with a portion of the traffic to keep the cache warm.Many organizations use a DNS switching service, which routes traffic between the different CDNs. In case of an error, a Virtual Edge solution also enables reverting to the previous configuration easily and quickly.5.

Best Practices 52

Best Practices Strategy Traffic Virtualization 52

Dynatrace

NOVEMBER 5, 2019

Microsoft offers a wide variety of tools to monitor applications deployed within Microsoft Azure, and the Azure Monitor suite includes several integration points into the enterprise applications, including: VM agent – Collects logs and metrics from the guest OS of virtual machines. Available as an agent installer).

Azure 135

Azure Artificial Intelligence Metrics Innovation 135

Brendan Gregg

FEBRUARY 28, 2023

Titus, the Netflix container management platform, is now open source,” [link] , Apr 2018 [Cutress 19] Dr. DDR6: Here's What to Expect in RAM Modules,” [link] , Nov 2020 [Salter 20] Jim Salter, “Western Digital releases new 18TB, 20TB EAMR drives,” [link] , Jul 2020 [Spier 20] Martin Spier, Brendan Gregg, et al.,

Performance 52

Performance Latency Cache Virtualization 52

ACM Sigarch

MAY 31, 2023

There are three common mechanisms to access remote memory: modifying applications, modifying virtual memory, and hardware-level cache coherence support. Memory disaggregation separates memory pools from traditional server boxes, enabling more flexible resource allocation and potentially reducing costs.

Latency 52

Latency Hardware Cache Architecture 52

IO River

NOVEMBER 2, 2023

Split and Separate Static and Dynamic TrafficStatic traffic is traffic that is cached close to the user and stored and served to them by the nearest server. For example, Amazon CloudFront offers a Reserved CDN pricing plan that can save you up to 30% on bandwidth.‍5. Following these tips will earn appreciation from your CFO.To

Infrastructure 52

Infrastructure Traffic Cache Strategy 52

Scalegrid

JULY 29, 2020

PgBouncer provides a virtual database that reports various useful statistics. Also, note the test here was actually perfectly crafted for Pgpool-II – since when N > 32, the number of clients and number of children processes were the same, and hence, each reconnection was guaranteed to find a cached process. Administration.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

n0derunner

JUNE 28, 2019

The Linux VM running postgres has two virtual disks – one taking transaction log writes. Since the DB is small (50% the size of the Linux RAM) – the database is mostly cached on the read side – so we only see writes going to the DB files. In this example from prior post.

Benchmarking 75

Benchmarking Storage Cache Database 75

HammerDB

OCTOBER 17, 2018

However most people use HammerDB with keying and thinking time disabled and therefore each virtual user can approximately drive the CPU resources of one CPU core on the database server. By default each virtual user has the concept of a home warehouses where approximately 75% of its workload will take place.

C++ 40

C++ Testing Virtualization Cache 40

IO River

NOVEMBER 2, 2023

Make sure to never starve a CDN vendor - always keep all vendors with a portion of the traffic to keep the cache warm.Many organizations use a DNS switching service, which routes traffic between the different CDNs. In case of an error, a Virtual Edge solution also enables reverting to the previous configuration easily and quickly.5.

Best Practices 40

Best Practices Strategy Traffic Virtualization 40

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. Microsoft has helped simplify things by creating multiple types of virtual machines. Memory optimized – High memory-to-CPU ratio, relational database servers, medium to large caches, and in-memory analytics.

Azure 76

Azure Benchmarking Storage Virtualization 76

SQL Server According to Bob

DECEMBER 18, 2018

Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache.

Servers 90

Servers Media Cache Storage 90

Dynatrace

DECEMBER 15, 2020

Resolved IIS crash on RUM activity interactions (user caching is now disabled if UEM is enabled). Citrix Profile Management now correctly indicated as Citrix Common technology, instead of Citrix Virtual Delivery Agent (VDA). ONE-49694). ONE-45777). APM-269331). APM-265940). ONE-50749). Plugin module.

Operating System 106

Operating System Java Mobile Cache 106

All Things Distributed

DECEMBER 18, 2012

May 28 - Virtual Time and Global States of Distributed Systems , Friedemann Mattern, Parallel and Distributed Algorithms, North-Holland (1989) , p. Jul 4 - Leases: An efficient fault-tolerant mechanism for distributed file cache consistency , Gray, Cary, and David Cheriton, Vol. Bar-Yam, Journal of Systems Science and Complexity.

Operating System 144

Operating System Cache AWS Scalability 144

Randon ASCII

JULY 11, 2022

Downloads go through the cache, the cache is saved to disk, and saves to disk are slowed by (some) anti-virus software. I’d been testing on a virtual machine in a data center that I had access to, purely because this machine has an internet connection that runs at over 2 Gbps. It looks like this can happen. Case closed.

Cache 105

Cache Energy Google Processing 105

IO River

NOVEMBER 2, 2023

Given its unchanging nature, static content is ideal for caching. These can be cached – much more effectively than what’s usually used:‍Standard CDNs for Static Content:The very nature of video streaming makes its traffic relatively straightforward to manage. It doesn’t change very often and is generally not affected by user sessions.

Architecture 52

Architecture Performance Internet Internet 52

Scalegrid

FEBRUARY 8, 2024

Nevertheless, strategies like using content delivery networks (CDNs), implementing effective caching mechanisms for data retrieval efficiency, refining network traffic routing methods, and incorporating compression technologies can help overcome these obstacles.

Storage 130

Storage Systems Big Data Azure 130

The Morning Paper

DECEMBER 10, 2019

This is a companion paper to the " persistent problem " piece that we looked at earlier this week, going a little deeper into the object pointer representation choices and the mapping of a virtual object space into physical address spaces. " Epheremal virtual addresses don’t cut it as the basis for persistent pointers.

Hardware 52

Hardware Virtualization Operating System Programming 52

Rigor

NOVEMBER 7, 2019

Modern sites or apps don’t exist in one single, specific place; they are fragmented across many virtual and physical systems, in different locations, in a variety of ways: Applications can be multitiered , with different systems living in different (physical or virtual) servers or entirely different data centers. Credit: cpdos.org.

Monitoring 40

Monitoring Performance Cache Ecommerce 40

ScaleOut Software

JULY 21, 2020

For more than fifteen years, ScaleOut StateServer® has demonstrated technology leadership as an in-memory data grid (IMDG) and distributed cache. Designed to help scalable applications deliver high performance, it stores live, fast-changing data in memory (DRAM) for fast updates and retrieval. The Challenges with Parallel Queries.

Analytics 52

Analytics Airlines Cache Scalability 52

ScaleOut Software

JULY 21, 2020

For more than fifteen years, ScaleOut StateServer® has demonstrated technology leadership as an in-memory data grid (IMDG) and distributed cache. Designed to help scalable applications deliver high performance, it stores live, fast-changing data in memory (DRAM) for fast updates and retrieval. The Challenges with Parallel Queries.

Analytics 52

Analytics Airlines Cache Scalability 52