article thumbnail

Impact of Querying Table Information From information_schema

Percona

having to open each table.frm (and in which my test runs, I have purposely read a very high number of tables compared to “Table-open-cache” variable). When running only sysbench, there is a high number of cache hits (~99.98%) and a low number of “misses,” which means the table_cache is big enough for the workload.

Cache 105
article thumbnail

Bringing Rich Experiences to Memory-constrained TV Devices

The Netflix TechBlog

Our UI runs on top of a custom rendering engine which uses what we call a “surface cache” to optimize our use of graphics memory. Surface Cache Surface cache is a reserved pool in main memory (or separate graphics memory on a minority of systems) that the Netflix app uses for storing textures (decoded images and cached resources).

Cache 166
Insiders

Sign Up for our Newsletter

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

article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

Caches | 12.4G 2004l# Percona Toolkit System Summary Report ###################### Date | 2023-09-25 14:43:34 UTC (local TZ: CDT -0500) Hostname | testbox Uptime | 44 min, 1 user, load average: 0.47, 0.67, 0.57 Platform | Linux Release | Ubuntu 22.04.3 LTS (jammy) Kernel | 6.2.0-33-generic virtual = 2.2G Shared | 475.0M Buffers | 3.8G

Cache 102
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Books Online (BOL) References: ​​ All BOL references cited in this paper are taken from the Microsoft SQL Server 2000 Books Online site (updated to include SP3 functionality), which can be found at: [link] Click the Product Documentation link. This cache is often supported by a battery-powered backup facility.

Servers 40
article thumbnail

Azure Well-Architected Framework: What it is and how to tame it with AI and automation

Dynatrace

Missing caching layers. Figure 5 – Dynatrace measures over 2000 different metrics ready for use as dedicated SLIs. To understand, reduce, and optimize back-end systems, the service flow diagrams can show common performance problems: Too many roundtrips between services. Too much data requested from a database.

Azure 199
article thumbnail

High Memory Usage on ProxySQL Server

Percona

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Commands end with ; or g.

Servers 60
article thumbnail

When Do SQL Server Sorts Rewind?

SQL Performance

Its raison d’être is to cache result rows from a plan subtree, then replay those rows on subsequent iterations if any correlated loop parameters are unchanged. Table-valued functions use a table variable, which can be used to cache and replay results in suitable circumstances. Spools are the least costly way to cache partial results.

Servers 106