Brendan Gregg

FEBRUARY 28, 2023

It was a great privilege. ## SREcon 2023 CFP Tech moves fast, however, and I have little time to reflect on 2022 when there's 2023 to plan! I'm now program co-chair for SREcon 2023 APAC, and our 2023 conference is June 14-16 in Singapore. The call for participation ends on March 2nd 23:59 SGT!

Performance 110

Performance Latency Cache Virtualization 110

Percona

JUNE 15, 2023

Refresh the local cache to update the package information $ sudo apt update Hit:1 [link] bullseye-security InRelease Hit:2 [link] bullseye InRelease 1.5 2023-06-05T23:31:46.511283Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.28-20) For example, to enable the Percona Server 8.0 Please use authentication_policy instead.

Servers 85

Servers C++ Database Systems 85

Percona

JULY 27, 2023

on July 17th, 2023. is in October of 2023. The statements include ALTER TABLE, ANALYZE TABLE, CACHE INDEX, CHECK TABLE, CREATE INDEX, CREATE TABLE, DROP INDEX, LOAD INDEX, OPTIMIZE TABLE, REPAIR TABLE, TRUNCATE TABLE, DROP TABLE, and any open cursors. This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 Tempus Fugit!

Servers 84

Servers Open Source Tuning Cache 84

Brendan Gregg

FEBRUARY 28, 2023

SREcon 2023 CFP Tech moves fast, however, and I have little time to reflect on 2022 when there's 2023 to plan! I'm now program co-chair for SREcon 2023 APAC, and our 2023 conference is June 14-16 in Singapore. It was a great privilege. The call for participation ends on March 2nd 23:59 SGT!

Performance 52

Performance Latency Cache Virtualization 52

Dynatrace

MAY 17, 2023

Observability Clinic, OpenObservabilty without boundaries with Dynatrace To learn more about how Dynatrace connects all of your observability data from any source, join us for the Observability Clinic on Tuesday, 13 June 2023 with Dynatrace observability expert, Henrik Rexed. Register now!

Metrics 190

Metrics Open Source Traffic Cache 190

Percona

FEBRUARY 16, 2023

key id, key user, key type, together with keys themselves) into the cache, unless MySQL is restarted, or you want to rotate the master key (you won’t though, as you know you have removed the keyring_file), it will not need the keyring file anymore. [ec2-user@ip-172-31-32-242 ibd can't be decrypted, please confirm that keyring is loaded.

Database 119

Database Servers Engineering Testing 119

ACM Sigarch

MAY 31, 2023

To understand the current status, needs, and challenges in HCM, the first workshop for Heterogeneous and Composable Memory was held with HPCA’23 on Feb 26, 2023. There are three common mechanisms to access remote memory: modifying applications, modifying virtual memory, and hardware-level cache coherence support.

Latency 52

Latency Hardware Cache Architecture 52

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. Efficient memory management, including optimizing query caches and buffer pools, can help strike the right balance between memory consumption and query response times. Another highly beneficial caching method is key-value caching.

Tuning 52

Tuning Database Performance Hardware 52

Sutter's Mill

SEPTEMBER 28, 2023

Since the 2022-12-31 year-end mini-update and the 2023-04-30 spring update , progress has continued on cppfront. (If If you don’t know what this personal project is, please see the CppCon 2022 talk on YouTube for an overview, and the CppNow 2023 talk on YouTube for an interim update.) I hope to see many of you there!

C++ 89

C++ Cache Code Design 89

Percona

DECEMBER 19, 2022

Client-side caching minimizes potential for metrics loss. Stage two (will be rolled out in 2023). Stage three (will be rolled out in 2023). Tab completion for the pmm-admin CLI command, which makes it easier to use the command line interface to manage PMM.

Metrics 52

Metrics Monitoring Servers Open Source 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies. It is just a guideline, not the exact allocated memory or cache size.

Tuning 52

Tuning Efficiency Database Performance 52

Alex Russell

DECEMBER 18, 2022

2023 Content Targets Desktop Devices Networks Mobile Devices Networks Developing Your Own Targets The Performance Inequality Gap is Growing. 2023 Content Targets #. In the interest of brevity, here's what we should be aiming to send over the wire per page in 2023 to reach interactivity in less than 5 seconds on first load: [2].

Performance 113

Performance Network Mobile Latency 113

Brendan Gregg

MARCH 16, 2024

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. It shouldn't be 10%, unless it's cache effects. 2023, 2024: Frame Pointers in Fedora and Ubuntu!

Java 145

Java Cache Google Hardware 145

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. In the example below, I will show how to set the WiredTiger cache. The first one, written by Peter Zaitsev, was Installing MySQL with Docker.

Scalability 60

Scalability Best Practices Servers Database 60

Percona

MARCH 27, 2023

Today’s post includes those releases and updates that have come out since March 13, 2023. was released on March 23, 2023. On March 15, 2023, Percona Distribution for MySQL (Percona XtraDB Cluster-based variant) 8.0.31 was released on March 20, 2023. was released on March 20, 2023. Take a look! was released.

Open Source 80

Open Source Servers Scalability Cache 80

Dynatrace

JANUARY 5, 2023

On Tuesday, January 3, 2023, at 15:26 UTC, we experienced an interruption of Dynatrace’s Single Sign On (SSO) service, preventing our customers from logging into their Dynatrace Software as a Service (SaaS) environments and other Dynatrace portals.

Cache 208

Cache Monitoring Strategy Speed 208

Percona

MARCH 28, 2023

The same data, in the form of pages inside the Wiredtiger cache, are also marked dirty. At every checkpoint interval (Default 60 seconds), MongoDB flushes the modified pages that are marked as dirty in the cache to their respective data files (both collection-*.wt This happens at every journalCommitIntervalMs. wt and index-*.wt).

Hardware 89

Hardware C++ Storage Cache 89

Smashing Magazine

OCTOBER 2, 2023

Jump to the workshops ↬ Using CDN For Caching And WebP For Lighter File Sizes As I mentioned a little earlier, our stack includes Sanity’s CMS. It offers a robust content delivery network (CDN) out of the box , which serves two purposes: (1) optimizing image assets and (2) caching them. Let’s see the query caching in action.

Cache 72

Cache Strategy Best Practices Design 72

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 137

Tuning Cache Servers Benchmarking 137

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. This caching mechanism also improves the website’s resilience to distributed denial-of-service (DDoS) attacks.

Performance 74

Performance Cache Traffic Metrics 74

Percona

JULY 17, 2023

1 among non-relational/document-based systems ( DB-Engines, July 2023 ). Those problems (some with shared elements) include: High cost and complicated pricing structure : Many companies say MongoDB has an expensive and complicated pricing structure ( Cloud Zero, January 2023 ). It ranks No. Couchbase — No.

Open Source 77

Open Source Database Scalability Software 77

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. Exploring How Triggers Impact MySQL Memory Allocation MySQL stores active table descriptors in a special memory buffer called the table open cache. That is also not quite a huge number for this number of tables.

Cache 62

Cache Database Games Healthcare 62

Percona

MAY 15, 2023

One example could be using an RDBMS for most of the Online transaction processing ( OLTP) data shared by country and having the products as distributed memory cache with a different technology. At the same time, all the data related to orders, payments, and customer history can be consolidated in a data warehouse used to generate reporting.

Traffic 125

Traffic Scalability Database Servers 125

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MyRocks is based on the RocksDB engine, and both are developed extensively at Facebook.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JULY 6, 2023

Using our test table, the following is an example of an Index Scan : db1=# EXPLAIN (ANALYZE) SELECT * FROM person WHERE age = 20 AND register_date = '2023-03-23 19:50:03.22938+00'::timestamp; QUERY PLAN - Index Scan using idx_person_age_date_active on person (cost=0.56.8.58

Best Practices 91

Best Practices Tuning Database Testing 91

Smashing Magazine

JANUARY 16, 2023

2023-01-16T18:00:00+00:00. 2023-01-16T22:03:27+00:00. For the LCP score and its “Resource load time” subpart to be really optimal, you may also consider compressing your images using modern image formats , setting far-future cache expiry headers, or even using a CDN to reduce network distance. Optimizing The Image Element LCP.

Media 105

Media Mobile Website Metrics 105

Smashing Magazine

OCTOBER 31, 2023

Answering Common Questions About Interpreting Page Speed Reports Answering Common Questions About Interpreting Page Speed Reports Geoff Graham 2023-10-31T16:00:00+00:00 2023-10-31T17:06:18+00:00 This article is sponsored by DebugBear Running a performance check on your site isn’t too terribly difficult.

Speed 97

Speed Google Website Metrics 97

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. Cons of logical backups As it reads all data, it can be slow and will require disk reads too for databases that are larger than the RAM available for the WT cache—the WT cache pressure increases, which slows down the performance.

Best Practices 52

Best Practices Database Storage Servers 52

ACM Sigarch

JULY 17, 2023

© 2023 Advanced Micro Devices, Inc. Enhancing the RAS design of a processor that is cognizant of new faults can also improve the observability of existing system level tests, which in turn, can help catch defects during manufacturing tests. As with testing, the knowledge of root causes drives specific RAS actions. All rights reserved.

Energy 52

Energy Hardware Best Practices Architecture 52

Speed Curve

FEBRUARY 25, 2024

Guest profiles also start with empty caches, empty cookie stores, empty browser storage, etc. Do less work Ryan Townsend spoke about The Unbearable Weight of Massive JavaScript at performance.now() in November 2023. I expect consent managers to adopt this approach as a default.

Analytics 91

Analytics Processing Google Mobile 91

Enprowess

JANUARY 12, 2022

So it is convenient for all to use irrespective of internet speed and it works offline using cached data. According to a Statista report, it is forecasted that worldwide spending on IoT by 2023 will reach 1.1 Offline Support : SPA consumes less bandwidth; meanwhile, it loads pages once only. billion connected devices by 2025.

Blockchain 59

Blockchain IoT Development Serverless 59

John McCalpin

APRIL 25, 2023

For most high-end processors these values have remained in the range of 75% to 85% of the peak DRAM bandwidth of the system over the past 15-20 years — an amazing accomplishment given the increase in core count (with its associated cache coherence issues), number of DRAM channels, and ever-increasing pipelining of the DRAMs themselves.

Benchmarking 97

Benchmarking Cache Latency Tuning 97