Percona

DECEMBER 20, 2018

Linux OS Tuning for MySQL Database Performance. In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud.

Database 40

Database Tuning Performance AWS 40

Dotcom-Montior

NOVEMBER 11, 2020

Well, to start, serverless, or serverless computing , doesn’t really mean there aren’t servers involved, because there are, rather it refers to the fact that the responsibility of having to manage, scale, provision, maintain, etc., Applications that are running continuously on a dedicated server aren’t as impacted by latency issues.

Serverless 57

Serverless Monitoring Lambda Latency 57

Brendan Gregg

OCTOBER 8, 2018

more capable, and built from the ground up for the modern era of the eBPF virtual machine. eBPF was created by Alexei Starovoitov while at PLUMgrid (he's now at Facebook) as a generic in-kernel virtual machine, with software defined networks as the primary use case. It's shaping up to be a DTrace version 2.0: eBPF does more.

C++ 110

C++ Virtualization Programming Latency 110

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 135

Tuning Cache Servers Benchmarking 135

Dynatrace

JANUARY 26, 2021

Traditional computing models rely on virtual or physical machines, where each instance includes a complete operating system, CPU cycles, and memory. VMware commercialized the idea of virtual machines, and cloud providers embraced the same concept with services like Amazon EC2, Google Compute, and Azure virtual machines.

Serverless 244

Serverless Efficiency Lambda Azure 244

Brendan Gregg

OCTOBER 7, 2018

more capable, and built from the ground up for the modern era of the eBPF virtual machine. eBPF was created by Alexei Starovoitov while at PLUMgrid (he's now at Facebook) as a generic in-kernel virtual machine, with software defined networks as the primary use case. It's shaping up to be a DTrace version 2.0: eBPF does more.

C++ 40

C++ Virtualization Programming Latency 40

Percona

AUGUST 27, 2018

Essentially, you can assign a thread to a specific virtual CPU. It is well hidden in the Optimization: Optimizing the MySQL Server chapter. 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.

Tuning 44

Tuning Virtualization Testing Servers 44

Abhishek Tiwari

JULY 12, 2018

These nodes and edges require a good amount of compute and storage which is typically distributed across a large number servers either running in the cloud or your own data center. If tuned for performance, there is a good change reliability is compromised - and vice versa. In a nutshell, a data pipeline is a distributed system.

Latency 63

Latency Analytics Scalability Engineering 63

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

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

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). This was much worse many years ago on Xen virtual machine guests.

Speed 126

Speed Java AWS Virtualization 126

Scalegrid

OCTOBER 17, 2019

Using a connection pool in each module is hardly efficient: Even with a relatively small number of modules, and a small pool size in each, you end up with a lot of server processes. You either need an extra server (or 3), or your database server(s) must have enough resources to support a connection pooler, in addition to PostgreSQL.

Architecture 200

Architecture Database Latency Servers 200

HammerDB

FEBRUARY 25, 2021

To benchmark a database we introduce the concept of a Virtual User. When we have multiple CPU cores on both the benchmark client and database server it is crucial that these database sessions run independently of each other at the same time, in parallel. The following is an example from TPROC-C from SQL Server. select top 100.

Programming 67

Programming Benchmarking Virtualization C++ 67

Dynatrace

APRIL 8, 2021

This means that there is no need to provision or manage servers (or even containers). In contrast to a regular web page, where most user interactions lead to a complete reload and server-side rendering of the page, SPAs change their content dynamically using JavaScript. So, stay tuned for more blog posts and announcements.

Lambda 221

Lambda AWS Serverless Monitoring 221

Dynatrace

NOVEMBER 18, 2019

For example, you might want Dynatrace to treat a group of hosts in a load-balancer environment as a single virtual host. Stay tuned for more announcements on this topic. Get/set server+tenant+token+proxy tuple or any of the components (This can be very helpful in cases where OneAgent needs to be moved between environments.).

Tuning 143

Tuning Virtualization Monitoring Infrastructure 143

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Dynatrace

JULY 8, 2020

That’s another example where monitoring is of tremendous help as it provides the current resource consumption picture and help to continuously fine tune those settings. . Event objects are not typical log events ; they are produced by the API Server and not included in the logs produced by the cluster.

Infrastructure 198

Infrastructure Monitoring Cloud Metrics 198

Dynatrace

APRIL 8, 2021

This means that there is no need to provision or manage servers (or even containers). In contrast to a regular web page, where most user interactions lead to a complete reload and server-side rendering of the page, SPAs change their content dynamically using JavaScript. So, stay tuned for more blog posts and announcements.

Lambda 183

Lambda AWS Serverless Monitoring 183

The Netflix TechBlog

AUGUST 29, 2023

The abstractions that Eureka provides for this are Virtual IPs (VIPs) for insecure communication, and Secure VIPs (SVIPs) for secure. IPC clients are instantiated targeting that VIP or SVIP, and the Eureka client code handles the translation of that VIP to a set of IP and port pairs by fetching them from the Eureka server.

Traffic 220

Traffic Latency Cloud C++ 220

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Smashing Magazine

OCTOBER 22, 2021

The idea is simple : players steer virtual toy cars in a top-down arena that resembles a foosball table. Clearly, the “first client rules all” approach needed to be replaced with a solution in which the game state lives on the server. The first team to score 10 goals wins. Project Setup. Creating A Schema.

Games 95

Games Servers Database Virtualization 95

O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” A year after the first web servers became available, how many companies had websites or were experimenting with building them? Until AI reaches 100%, it’s still in the process of adoption.

Open Source 109

Open Source Artificial Intelligence Google Infrastructure 109

SQL Server According to Bob

JUNE 9, 2016

SQL Server, as outlined in the following post ( [link] ) adjusts to various processor configurations. I have received questions related to how SQL Server accomplishes the alignment on both bare metal and VM installations. For Virtual Machine (VM) installations you may need to consult the VM documentation for support capabilities.

Servers 40

Servers Virtualization Tuning Architecture 40

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). This was much worse many years ago on Xen virtual machine guests.

Speed 40

Speed Java AWS Virtualization 40

Dynatrace

FEBRUARY 25, 2021

The virtual CPU is turned off. Lambda functions are often used as back ends for static, single-page applications, and many customers asked for the same level of insights they get when running Dynatrace against a regular web server. Stay tuned?for After each execution, AWS Lambda puts the instance to sleep. What’s next.

Lambda 219

Lambda AWS Monitoring Serverless 219

Brendan Gregg

SEPTEMBER 5, 2017

I've suggested adding a command to docker to make listing at least the top-level PIDs in containers easier. ## Virtual Machines The two main technologies on Linux are Xen and KVM (and there's Bhyve for BSD). Oracle VM Server is based on Xen. Outside of EC2, many other providers are deploying on KVM.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. I’ve written before about how to tune out retry storms. The first thing to understand is that doing things consumes time and energy and has a carbon footprint of its own. they are never really idle.

Energy 52

Energy Cloud Traffic Transportation 52

All Things Distributed

OCTOBER 2, 2017

VPC Endpoints give you the ability to control whether network traffic between your application and DynamoDB traverses the public Internet or stays within your virtual private cloud. percent availability in the event of a server, a rack of servers, or an Availability Zone failure.

Internet 128

Internet Internet AWS Performance 128

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. A good example of how tuning is an iterative process.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

SQL Performance

APRIL 27, 2020

Many of the newer features we have in SQL Server were initially launched in Azure SQL Database, including (but not limited to) Always Encrypted, Dynamic Data Masking, Row Level Security, and Query Store. There is a lot of awesome technology involved with Hyperscale in how it is architected to use SSD-based caches and page servers.

Azure 55

Azure Database Serverless Hardware 55

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Many thanks to the engineers working hard to develop workarounds to these processor bugs.

Performance 75

Performance Benchmarking Cache Tuning 75

HammerDB

OCTOBER 12, 2018

Historically MySQL has been positioned for supporting web-based applications this is in contrast to enterprise based database workloads that have been served by commercial databases such as Oracle, Db2 and SQL Server. Download and install HammerDB on a test client system, Like PostgreSQL another 2 socket server is ideal. perf special.

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

JANUARY 5, 2019

If you are going to restore your production backups onto the new server how can you be sure that this data is safe in transit and completely deleted when the test is complete. If not are you going to “clean” your data so it does not present a security risk?

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Many thanks to the engineers working hard to develop workarounds to these processor bugs.

Performance 40

Performance Benchmarking Cache Tuning 40

Smashing Magazine

FEBRUARY 2, 2022

Like any file referenced and used on a website, it first needs to be downloaded from a server. We can code-split virtually any component in our project. We can fine-tune performance budgets to tailor for worse possible user scenarios, and use that as a baseline for performance optimization. Large preview ). Project components.

Code 89

Code Performance Network Website 89

MachMetrics

SEPTEMBER 5, 2019

When a user comes to a website that has been fine tuned, they aren’t having their time wasted with long load times, and their devices aren’t having their batteries and resources drained. The owner of the website also benefits in the form of lower bounce rates and reduced server loads (resulting in lower hosting costs).

Website 48

Website Performance Speed Design 48