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 99
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 59
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

Examining the Performance Impact of an Adhoc Workload

SQL Performance

It’s one of the things we look at during a health audit, and Kimberly has a great query from her Plan cache and optimizing for adhoc workloads post that’s part of our toolkit. About 1GB of the plan cache is for prepared and procedure plans, and they only take up about 300MB worth of space. DBCC FREEPROCCACHE ; GO. EXEC dbo. [

Cache 54
article thumbnail

How Many Warehouses for the HammerDB TPC-C Test?

HammerDB

As noted configuring more should not have a major impact on results as depending on the number of virtual users used in the test most the warehouses will be idle (and ideally most of the warehouses you are using will be cached in memory in your buffer cache so the I/O to the data area is minimal). . .

C++ 40
article thumbnail

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Percona

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. Check the available Percona Server for MySQL 8.0 For example, to enable the Percona Server 8.0

Servers 81
article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

This example instrumented one of many thousands of available events. Kernel dynamic tracing of read() bytes bpftrace -e 'kretprobe:vfs_read { @bytes = lhist(retval, 0, 2000, 200) }'. There are often two modes, one for device cache hits and one for cache misses, which can be shown by this tool. SYNOPSIS biolatency.bt

Latency 68
article thumbnail

Increase the Performance of your Site with Lazy-Loading and Code-Splitting

Jos

</ div >. ) ; If you do this, make sure that the images have the right cache response headers so subsequent requests from the browser hit the cache and it doesn’t download the images again. animationDuration = 2000 ; this. This post is also available in Spanish Did you see any typo or wrong information?

Code 147