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 101
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 98
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

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 193
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

Back-to-Basics Weekend Reading - Counting Bloom Filters - All.

All Things Distributed

In 2000 an improvement on the original Bloom filters called Counting Bloom Filters was published as part of the Summary Cache protocol. Summary Cache: A Scalable Wide-Area Web Cache Sharing Protocol , Li Fan, Pei Cao, Jussara Almeida, Anrei Broder, IEEE/ACM Transactions on Networking, 8(3):281-293,2000.

Cache 86
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