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

Comparisons of Proxies for MySQL

Percona

When deciding what to pick, there are many things to consider, like where the proxy needs to be, if it “just” needs to redirect the connections, or if more features need to be in, like caching and filtering, or if it needs to be integrated with some MySQL embedded automation. Given that, there never was a single straight answer.

Games 125
Insiders

Sign Up for our Newsletter

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

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. 2) mysql-query_digests_max_digest_length – This is by default set to 2048. It is a proven tool and is used largely in production. If you need, you can enable it.

Servers 60
article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

There are also two modes visible, one between 1 and 2 milliseconds, and another between 8 and 16 milliseconds: this sounds like cache hits and cache misses. 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 57
article thumbnail

Getting Started with HTTP/2 and Server Push

Dean Hume

Instead of waiting for the HTTP response, it allows the server to “push” the resources it thinks the client will need into its cache. openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 -keyout server.key -out server.crt. With HTTP/1.1, This is where Server Push is a game changer.

Servers 40
article thumbnail

Getting Started with HTTP/2 and Server Push

Dean Hume

Instead of waiting for the HTTP response, it allows the server to “push” the resources it thinks the client will need into its cache. openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 -keyout server.key -out server.crt. With HTTP/1.1, This is where Server Push is a game changer.

Servers 40
article thumbnail

Getting Started with HTTP/2 and Server Push

Dean Hume

Instead of waiting for the HTTP response, it allows the server to “push” the resources it thinks the client will need into its cache. openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 -keyout server.key -out server.crt. With HTTP/1.1, This is where Server Push is a game changer.

Servers 40