Percona

MARCH 27, 2023

A lot of useful information can be retrieved from this schema, for example, table metadata and foreign key relations, but trying to query I_S can induce performance degradation if your server is under heavy load, as shown in the following example test. You can read some optimization examples in the official doc: [link].

Cache 102

Cache Hardware Servers Benchmarking 102

Dynatrace

SEPTEMBER 29, 2021

A standard Docker container can run anywhere, on a personal computer (for example, PC, Mac, Linux), in the cloud, on local servers, and even on edge devices. For a deeper look into how to gain end-to-end observability into Kubernetes environments, tune into the on-demand webinar Harness the Power of Kubernetes Observability.

Open Source 301

Open Source Traffic DevOps Cloud 301

Dynatrace

OCTOBER 26, 2020

In this blog, I want to give you two examples of internal innovation projects at Dynatrace which leverage this new API, to truly show you the power – and the fun-ness of this new metric ingest ??. So stay tuned. If you want to replicate Christians work – here are the software and hardware specs: Hardware.

Innovation 154

Innovation Metrics Hardware Games 154

Dynatrace

NOVEMBER 15, 2021

Logs can include data about user inputs, system processes, and hardware states. Log files contain much of the data that makes a system observable: for example, records of all events that occur throughout the operating system, network devices, pieces of software, or even communication between users and application systems.

Analytics 209

Analytics Monitoring Artificial Intelligence DevOps 209

The Morning Paper

NOVEMBER 3, 2019

Perhaps the most interesting lesson/reminder is this: it takes a lot of effort to tune a Linux kernel. For example: “Red Hat and Suse normally required 6-18 months to optimise the performance an an upstream Linux kernel before it can be released as an enterprise distribution”, and. Headline results. Security related root causes.

Performance 108

Performance Benchmarking Tuning Hardware 108

Scalegrid

JANUARY 25, 2024

It’s important to note that recommended throughput levels may vary depending on factors such as operating system type, network bandwidth availability, and hardware quality. For example, by tracking the value of RDB_last_save_time one can determine the last time an RDB file was saved.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

AUGUST 27, 2018

assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. Good examples are: ETL processes for data archiving, reporting, data consolidation and so on. Currently, CPU affinity (i.e., This is cool, isn’t it?

Tuning 45

Tuning Virtualization Testing Servers 45

Percona

JANUARY 4, 2024

This blog discusses general tablespaces and explores their functionalities, benefits, and practical usage, along with illustrative examples. Flexible location : Data files can reside within the MySQL data directory or an independent location, enabling finer control over storage management and performance tuning.

Storage 88

Storage Engineering Database Hardware 88

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

Dynatrace

OCTOBER 28, 2021

The crisis could be technical, natural, or malicious events, for example an earthquake affecting data center availability, or a cyberattack infecting applications and websites. Chaos engineers ask why. Practitioners subject software to a controlled, simulated crisis to test for unstable behavior.

Engineering 225

Engineering Entertainment Cloud Infrastructure 225

HammerDB

APRIL 19, 2023

For example, if you are buying the latest Amazon memory-optimized EC2 instance (R7iz), the AWS page ( [link] ) tells us the following: Up to 3.9 Please refer to this tuning guide to tune the system for HammerDB: Open Source Database Tuning Guide on 3rd Generation Intel® Xeon® Scalable Processors Based Platform.

Performance 54

Performance Benchmarking Cache Storage 54

Sutter's Mill

NOVEMBER 11, 2023

Here is an example from the paper that will now be legal: template <typename. Instead, you want a library that is tuned for your target hardware architecture and ready for par_unseq vectorized algorithms, for blazing speed. T> constexpr auto first_plus_last(T. values) -> T.[0] [0] { return T.[0](values.[0]

C++ 118

C++ Lambda Network Programming 118

The Netflix TechBlog

AUGUST 30, 2021

Complementing the hardware is the software on the RAE and in the cloud, and bridging the software on both ends is a bi-directional control plane. For example, when running tests, the state of the device will change from “available for testing” to “in test.” In this blog post, we will focus on the latter feature set.

Latency 213

Latency Traffic Transportation Cloud 213

The Morning Paper

JUNE 27, 2019

The thrust of the argument is that there’s a chain of inter-linked assumptions / dependencies from the hardware all the way to the programming model, and any time you step outside of the mainstream it’s sufficiently hard to get acceptable performance that researchers are discouraged from doing so. Challenges compiling non-standard kernels.

Systems 87

Systems Tuning Programming Innovation 87

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. systemctl stop tuned $ systemctl disable tuned Dirty ratio The dirty_ratio is the percentage of total system memory that can hold dirty pages.

Best Practices 52

Best Practices Design Tuning Database 52

Dynatrace

OCTOBER 22, 2019

For example, if you come in Monday morning and are informed that there was a massive problem on Sunday, it would be great to have a thread dump, but you forgot your time machine at home. While the system is well optimized in this example, we still find considerable locking behavior under load.

Java 103

Java Scalability Hardware Architecture 103

Adrian Cockcroft

JUNE 2, 2023

One example is that Netflix launched it’s streaming service in 2007, just at the point when the cost of streaming a movie over the network (which was dropping fast) became less than the cost of shipping a DVD. CtrlStack are building AI driven DevOps automation tools and they showed a few examples.

Social Media 98

Social Media Innovation Open Source Entertainment 98

The Morning Paper

JUNE 13, 2019

As we saw with the SOAP paper last time out, even with a fixed model variant and hardware there are a lot of different ways to map a training workload over the available hardware. Different hardware architectures (CPUs, GPUs, TPUs, FPGAs, ASICs, …) offer different performance and cost trade-offs.

Hardware 58

Hardware Latency Serverless Energy 58

The Morning Paper

NOVEMBER 10, 2019

It offers asynchronous operation-level commands and completions, with both two-sided and one-sided operations (of which RDMA is an example). The ability to rapidly deploy new versions of Pony Express significantly aided development and tuning of congestion control.

Network 92

Network Transportation Latency Entertainment 92

Alex Podelko

OCTOBER 20, 2016

System’s configuration is not given anymore and often can’t be easily mapped to hardware. As already mentioned, performance testing is rather a performance engineering process (with tuning, optimization, troubleshooting and fixing multi-user issues) eventually bringing the system to the proper state rather than just testing.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

The Morning Paper

MAY 21, 2019

If extra provisioned capacity was needed to offset a slowdown for example then this could easily offset all potential TCO savings. Using zswap means that no new hardware solutions are required, enabling rapid deployment across clusters. ML-based auto-tuning. Evaluation.

Software 78

Software Software Google Hardware 78

Percona

JANUARY 19, 2023

Example (using the employee sample DB ): Suppose we have the following schema: db1 employees> show create table employeesG 1. Example: Creating four simple tables to store strings but using different data types: db1 test> CREATE TABLE tb1 (id int auto_increment primary key, test_text char(200)); Query OK, 0 rows affected (0.11

Open Source 88

Open Source Storage Database Big Data 88

HammerDB

OCTOBER 18, 2019

cpupower frequency-info analyzing CPU 0: driver: intel_pstate CPUs which run at the same hardware frequency: 0 CPUs which need to have their frequency coordinated by software: 0 maximum transition latency: Cannot determine or is not supported. hardware limits: 1000 MHz - 4.00 hardware limits: 1000 MHz - 4.00 3834 2696 .

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Percona

AUGUST 5, 2023

This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. For example, when querying a large table for specific date ranges, partitioning allows the engine to scan only relevant partitions containing data within those ranges.

Strategy 40

Strategy Storage Database Best Practices 40

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Finding a small number of distinct values might seem like quite a specific requirement, but I have come across it fairly frequently over the years, usually as part of tuning a larger query. The last several examples were quite close in performance.

Servers 86

Servers Tuning Database Efficiency 86

HammerDB

JANUARY 5, 2019

For example the following chart (with the actual data removed for the reasons described further in this post) shows the HammerDB TPC-C workload run against the same database on different processing architectures (grouped by colour) and speed with the most recent at the top. can you be sure that it scales?

Benchmarking 40

Benchmarking Database Social Media Scalability 40

The Morning Paper

MARCH 17, 2020

For example, a study that looked at adapting RocksDB to use persistent memory (amongst many other systems) concluded that a fine-grained persistent memory approach worked better than moving the write-ahead log to persistent memory. The guidelines… provide a starting point for building and tuning Optane-based systems.

Scalability 59

Scalability Latency Cache Media 59

Adrian Cockcroft

NOVEMBER 13, 2023

In the simplest case, you have a growing workload, and you optimize it to run more efficiently so that you don’t need to buy or rent additional hardware, so your carbon footprint stays the same, but the carbon per transaction or operation is going down. I’ve written before about how to tune out retry storms.

Energy 52

Energy Cloud Traffic Transportation 52

SQL Server According to Bob

JANUARY 11, 2020

The following are examples of successful recovery situations actually encountered by Microsoft SQL Server Product Support Services personnel. Example 1: ​​ Hardware failure (CPU board) Battery backup on the caching controller maintained the data.

Servers 40

Servers Cache Media Hardware 40

Dotcom-Montior

NOVEMBER 11, 2020

Serverless computing can be a huge benefit to organizations that don’t have the necessary resources or teams to manage physical resources, like servers/hardware, and all the maintenance and licensing that goes along with that, allowing them to focus on developing their code and applications. Benefits of a Serverless Model.

Serverless 57

Serverless Monitoring Lambda Latency 57

VoltDB

JUNE 19, 2017

With the 5G revolution, operators will need to manage hundreds of edge deployments, and maintain the physical space and hardware to achieve 1ms of latency. The spotlight is on 5G due a number of alluring use cases, including autonomous surgery, drone control, and self-driving/remote control cars.

Latency 40

Latency Retail Virtualization Hardware 40

VoltDB

JUNE 19, 2017

With the 5G revolution, operators will need to manage hundreds of edge deployments, and maintain the physical space and hardware to achieve 1ms of latency. The spotlight is on 5G due a number of alluring use cases, including autonomous surgery, drone control, and self-driving/remote control cars.

Latency 40

Latency Retail Virtualization Hardware 40

Percona

AUGUST 29, 2023

Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. Here is an example of a table named replica2x, which has 2X redundancy across a cluster of four (4) nodes. For example, if node citus1 goes offline, the sharded table it holds still has copies on nodes citus2 and citus4.

C++ 79

C++ Database Storage Testing 79

HammerDB

FEBRUARY 25, 2021

The following is an example from TPROC-C from SQL Server. So now our TPROC-C example from the Stock Level stored procedure on SQL Server begins as follows. The example below is for the NEW ORDER stored procedure for the Oracle database. and the following from TPROC-H. select top 100. where p_partkey = ps_partkey. CPUSIMPLE].

Programming 67

Programming Benchmarking Virtualization C++ 67

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. an example is shown of the shortest of these: . hardware limits: 1000 MHz - 3.80

Best Practices 40

Best Practices Scalability Performance C++ 40

O'Reilly

JANUARY 16, 2024

For a concrete example of what such a personalized podcast felt like, I started one conversation by straight-up asking ChatGPT to keep me awake while I was driving in Southern California from Los Angeles to San Diego. software” rather than “hardware” in our brains).

Entertainment 73

Entertainment Internet Internet Design 73

KeyCDN

AUGUST 15, 2019

Before you begin tuning your website or application, you must first figure out which metrics matter most to your users and establish some achievable benchmarks. Bottlenecks can occur, for example, if you have a sudden surge in traffic that your servers are not equipped to handle. What is Performance Testing?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55