High Scalability

AUGUST 24, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. In 2010, having seemingly gone all-in with the tenets of open source development , the company brought MongoDB to the market as an open source database server. 2016: The company adds service-loaded MongoDB Professional to its mix.

Open Source 83

Open Source Programming Database Servers 83

High Scalability

OCTOBER 27, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 29, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

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

Percona

JANUARY 19, 2023

There are a couple of blog posts from Yves that describe and benchmark MySQL compression: Compression Options in MySQL (Part 1) Compression Options in MySQL (Part 2) Archive or purge old or non-used data: Some companies have to retain data for multiple years either for compliance or for business requirements.

Open Source 91

Open Source Storage Database Big Data 91

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

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 137

Tuning Cache Servers Benchmarking 137

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 127

Performance Hardware Tuning Storage 127

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. However, it is crucial that the benchmarking application does not have inherent bottlenecks that artificially limits the scalability of the database. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

Programming 67

Programming Benchmarking Virtualization C++ 67

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 6. 30.14% in the middle of the flame graph.

Speed 126

Speed Java AWS Virtualization 126

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. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Much of my testing was on Linux 4.14.11

Performance 75

Performance Benchmarking Cache Tuning 75

Dynatrace

FEBRUARY 25, 2021

To handle N parallel requests, N Lambda instances need to be available, and AWS will spin up up to 1000 such instances automatically to handle 1000 parallel requests. A cold start occurs when there’s no instance of the requested Lambda function available. After each execution, AWS Lambda puts the instance to sleep. What’s next.

Lambda 218

Lambda AWS Monitoring Serverless 218

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

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

IO River

NOVEMBER 15, 2023

Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture. A horde of compromised computers overwhelms a server, rendering it incapable of handling legitimate requests.In Imagine you have a special promotion only available to customers in a particular country.

Traffic 52

Traffic Network Logistics Architecture 52

O'Reilly

JULY 25, 2023

Similarly, it taught me that “Background scripts are ideal for handling long-term or ongoing tasks, managing state, maintaining databases, and communicating with remote servers. I feel that humans are still better than LLMs at coming up with these sorts of hacks since there aren’t readily-available online resources to document them.

Programming 98

Programming Code Design Benchmarking 98

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. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Much of my testing was on Linux 4.14.11

Performance 40

Performance Benchmarking Cache Tuning 40

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 7. 30.14% in the middle of the flame graph.

Speed 40

Speed Java AWS Virtualization 40

IO River

NOVEMBER 2, 2023

Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture. A horde of compromised computers overwhelms a server, rendering it incapable of handling legitimate requests.In Let's dive deep into these challenges.‍1.

Traffic 40

Traffic Network Logistics Architecture 40

Percona

AUGUST 5, 2023

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. This helps identify potential issues and fine-tune the partitioning strategy. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

HammerDB

OCTOBER 12, 2018

For anyone benchmarking MySQL with HammerDB it is important to understand the differences from sysbench workloads as HammerDB is targeted at a testing a different usage model from sysbench. GHz available cpufreq governors: performance powersave . Error in Virtual User 1: mysqlexec/db server: Table 'mysql.proc' doesn't exist.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 108

Database Benchmarking Latency C++ 108

Scalegrid

JULY 13, 2020

Compare PostgreSQL vs. Oracle functionality across available tools, capabilities and services. Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. Not available. Not available. Not available. New Oracle versions are generally available every 2-4 years.

Open Source 244

Open Source Tuning C++ Database 244

High Scalability

NOVEMBER 25, 2019

Application Servers. Apache FTP server. Native desktop and server hosted clients that allow both interactive as well as hybrid sync access to the entire namespace. Tens of petabytes of data stored in our servers and other object stores such as GCS, S3 and Azure Blobstore. Ubuntu for server teams. Cloud Platform.

Architecture 52

Architecture Cache Azure Storage 52