The Morning Paper

MAY 23, 2019

Compress objects, not cache lines: an object-based compressed memory hierarchy Tsai & Sanchez, ASPLOS’19. Existing cache and main memory compression techniques compress data in small fixed-size blocks, typically cache lines. ” The big idea. What about arrays? We want Zippads to compress both well.

Cache 61

Cache Benchmarking Hardware Java 61

Percona

APRIL 3, 2023

Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables. Type OID represents an object identifier. craft" SET WITHOUT OIDS; ALTER TABLE "public"."ports"

C++ 106

C++ Database Cache Storage 106

Nick Desaulniers

JULY 23, 2015

21st Century C by Ben Klemens. There are a few other useful tools that came to mind that I’ve used when working with C and C++ codebases. C & C++ codebases; running these tools on the code or adding them to the codebases. with lots of C++ code have documents. was a great read. Code Formatters.

C++ 75

C++ Programming Open Source Code 75

The Netflix TechBlog

JUNE 4, 2019

Because microprocessors are so fast, computer architecture design has evolved towards adding various levels of caching between compute units and the main memory, in order to hide the latency of bringing the bits to the brains. This avoids thrashing caches too much for B and evens out the pressure on the L3 caches of the machine.

Cache 251

Cache Latency Airlines Logistics 251

Scalegrid

AUGUST 30, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker. Redis Strings. Redis Strings Use Cases.

Cache 232

Cache Ecommerce Social Media Database 232

Sutter's Mill

SEPTEMBER 28, 2023

file compilation looks like when compiled on the command line on my laptop: But note you can still build cppfront as all-today’s-C++ using any fairly recent C++20 compiler because I distribute the sources also as C++ (just as Bjarne distributed the cfront sources also as C). Here’s what that reflect.h2

C++ 89

C++ Cache Code Design 89

Brendan Gregg

SEPTEMBER 5, 2021

They claimed that the ZFS file system was consuming 30% of CPU capacity. These included a breakdown of CPU time into percentages for "usr" (user: applications) and "sys" (system: the kernel). The other colors are yellow for C++, and red for other user-level code.) cd to the file system and ls(1) to see what's there.

Cache 145

Cache Cloud Java Tuning 145

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. 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

Hardware 91

Hardware C++ Storage Cache 91

HammerDB

JUNE 27, 2022

HammerDB has graphical and command line interfaces for the Windows and Linux operating systems. An important concept was to simulate database users called Virtual Users in parallel (rather than concurrently) to accurately simulate a real database workload with multiple users running from separate systems. Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Sutter's Mill

FEBRUARY 13, 2017

I don’t get to Europe very often apart from ISO C++ standards meetings, but this spring I’ve been able to accept invitations for two English-language European events in the last week of April. Tue-Thu Apr 25-27: High-Performance and Low-Latency C++ (Stockholm). Description.

Latency 51

Latency C++ Hardware Performance 51

The Morning Paper

OCTOBER 18, 2020

But what about systems software? Radix Sort is carefully designed to make effective use of the L2 cache and sequential memory accesses, whereas Learned Sort is making random accesses all over the destination array. How can learned sort be adapted to make it cache-efficient? Sympathy for the machine. Evaluation.

Cache 137

Cache C++ Java Tuning 137

CSS Wizardry

SEPTEMBER 28, 2023

There’s some subtle complexity designed to prevent people gaming the system, which is exactly what we’re trying to do. Again, to stop people gaming the system, Chrome decided that only images of a certain quality (or entropy ) will be considered as your LCP element. And it doesn’t necessarily spell bad news for our LQIP either.

Games 275

Games Ecommerce Cache Systems 275

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. Caches | 12.4G Caches | 12.4G

Cache 103

Cache Database Virtualization Servers 103

The Morning Paper

NOVEMBER 5, 2019

File systems unfit as distributed storage backends: lessons from 10 years of Ceph evolution Aghayev et al., In this case, the assumption that a distributed storage backend should clearly be layered on top of a local file system. A distributed file system provides a unified view over aggregated storage from multiple physical machines.

Storage 64

Storage Systems Hardware Efficiency 64

ACM Sigarch

MARCH 18, 2019

Computer systems, from the Internet-of-Things devices to datacenters, are complex and optimizing them can enhance capability and save money. Developing simulators, however, is time-consuming and requires a great deal of infrastructure development regarding a prospective system. Answered in Part 2.). Lazowska, et al.

Systems 60

Systems Latency Performance Analytics 60

HammerDB

OCTOBER 17, 2018

The official TPC-C test has a fixed number of users per warehouse and uses keying and thinking time so that the workload generated by each user is not intensive. This is a very typical FAQ and although detailed in the documentation some extra details may help in sizing and configuration.

C++ 40

C++ Testing Virtualization Cache 40

ACM Sigarch

OCTOBER 12, 2020

These, let’s call them metal languages , include FORTRAN (introduced in 1957), C (1972), and C++ (1985). Programmers continue to write applications in them, and they continue to evolve: the just approved C++20 standard is the latest example. Are caches large enough for this code? As Leiserson et al.

C++ 108

C++ Benchmarking Hardware Architecture 108

HammerDB

APRIL 19, 2023

Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. sysbench is a widely used open-source benchmarking tool that is designed to evaluate the performance of CPU, memory, disk I/O, and database systems. Operating System: Ubuntu 22.04 4.22 %usr 38.40

Performance 54

Performance Benchmarking Cache Storage 54

The Morning Paper

MAY 12, 2019

An open-source benchmark suite for microservices and their hardware-software implications for cloud & edge systems Gan et al., Systems built with lots of microservices have different operational characteristics to those built from a small number of monoliths, we’d like to study and better understand those differences.

Open Source 61

Open Source Hardware Benchmarking Systems 61

Official Blog - World Web Technology

AUGUST 27, 2023

Unlike other popular programming languages such as C or Pearl, PHP pages have HTML with embedded code with some start and end processing instructions that allow you to jump directly into and out of PHP mode. Regarding CMS, PHP can be integrated with other content management systems, such as WordPress, to build robust ecommerce websites.

Development 98

Development Ecommerce Open Source Website 98

Brendan Gregg

AUGUST 29, 2021

1072-aws (xxx) 12/18/2018 _x86_64_ (16 CPU) avg-cpu: %user %nice %system %iowait %steal %idle 5.03 avg-cpu: %user %nice %system %iowait %steal %idle 14.81 avg-cpu: %user %nice %system %iowait %steal %idle 14.86 avg-cpu: %user %nice %system %iowait %steal %idle 14.95 avg-cpu: %user %nice %system %iowait %steal %idle 14.54

Cache 40

Cache C++ AWS Systems 40

Percona

MAY 1, 2023

It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies.

Tuning 52

Tuning Efficiency Database Performance 52

ACM Sigarch

MARCH 25, 2019

The M/M/1 queue will show us a required trade-off among (a) allowing unscheduled task arrivals, (b) minimizing latency, and (c) maximizing throughput. The M/M/1 queue also assumes that the arrival rate is not affected by the unbounded number of tasks in the queue (called an “open system”). 50ms), but this is actually necessary.

Systems 53

Systems Latency Performance C++ 53

Adrian Cockcroft

JANUARY 29, 2023

There is no way to model how much more traffic you can send to that system before it exceeds it’s SLA. This is unfortunate, because we’d really like to be able to build systems that have an SLA that we can share with the consumers of our interfaces, and be able to measure how well we are doing.

Lambda 98

Lambda Latency Cache C++ 98

Dynatrace

DECEMBER 15, 2020

Upcoming Operating systems support changes. The following operating systems will no longer be supported starting 01 February 2021. The following operating systems will no longer be supported starting 01 May 2021. The following operating systems will no longer be supported starting 01 May 2021. Linux: Ubuntu 19.10.

Operating System 108

Operating System Java Mobile Cache 108

High Scalability

SEPTEMBER 3, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker.

Open Source 55

Open Source Cache C++ Database 55

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 116

Servers Best Practices Database Open Source 116

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 20 Percona Server (GPL), Release '20', Revision 'fd4b5a776a6' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Servers 85

Servers C++ Database Systems 85

Nick Desaulniers

JUNE 2, 2018

ccache , the compiler cache, is a fantastic way to speed up build times for C and C++ code that I previously recommended. Usually when this happens with ccache, there’s something non-deterministic about the builds that prevents cache hits. make -j4 2008.93s user 231.69s system 346% cpu 10:47.07 Cold Cache.

Speed 46

Speed Cache C++ Systems 46

Brendan Gregg

SEPTEMBER 5, 2021

They claimed that the ZFS file system was consuming 30% of CPU capacity. These included a breakdown of CPU time into percentages for "usr" (user: applications) and "sys" (system: the kernel). The other colors are yellow for C++, and red for other user-level code.) No ZFS file systems were currently mounted.

Cache 52

Cache Cloud Java Tuning 52

Brendan Gregg

JULY 2, 2021

This is also applicable for people adding it to their own in-house monitoring systems. You likely already have agents running on all your customer systems. There are so many options it's really your own preference based on your existing system and customer environments. cachestat File system cache statistics line charts.

Latency 145

Latency Cache Energy Systems 145

Scalegrid

JULY 29, 2020

However, these must be set up outside the PostgreSQL system, while PgBouncer can offload this to the PostgreSQL server. Forced pgbench to create a new connection for each transaction using the -C option. Administration. PgBouncer provides a virtual database that reports various useful statistics.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

HammerDB

JULY 5, 2022

So instead we are going to take a cut down version of the HammerDB TPROC-C driver script and do the same in Python and use the HammerDB infrastructure to measure performance. (We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test). usr/local/bin/tclsh8.6

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Brendan Gregg

AUGUST 18, 2019

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. system(".") Hit Ctrl-C to end. ^C Attaching 2 probes. ^C pid process ID.

Latency 68

Latency C++ Cache Programming 68

The Morning Paper

AUGUST 29, 2019

We focused on OLAP-oriented parallel data warehouse products available for AWS and restricted our attention to commercially available systems. As it is infeasible to test every OLAP system runnable on AWS, we chose widely-used systems that represented a variety of architectures and cost models. System initialisation time.

Architecture 76

Architecture Cloud Storage Serverless 76

SQL Performance

SEPTEMBER 21, 2022

Examples include the following: The set_options and required_cursor_options cached plan attributes, which you obtain using the sys.dm_exec_plan_attributes DMF. L0 AS ( SELECT 1 AS c. Another example is using a bitwise representation of a set of settings turned on or off in a given environment.

Servers 122

Servers C++ Code Cache 122

Brendan Gregg

SEPTEMBER 5, 2021

They claimed that the ZFS file system was consuming 30% of CPU capacity. These included a breakdown of CPU time into percentages for "usr" (user: applications) and "sys" (system: the kernel). The other colors are yellow for C++, and red for other user-level code.) cd to the file system and ls(1) to see what's there.

Cache 40

Cache Cloud Java Tuning 40