Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 101

Database Servers Open Source Tuning 101

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself.

Open Source 81

Open Source Programming Database Servers 81

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. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications.

Education 100

Education DevOps Infrastructure Benchmarking 100

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. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications.

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. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications.

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. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications.

Education 100

Education DevOps Infrastructure Benchmarking 100

Percona

AUGUST 27, 2018

It is well hidden in the Optimization: Optimizing the MySQL Server chapter. Database administrators with appropriate privileges can associate virtual CPUs with resource groups and assign threads to these groups. Then we need to see IF implementing the tuning will work or not. I am talking about resource groups. Will this work?

Tuning 44

Tuning Virtualization Testing Servers 44

Dynatrace

APRIL 21, 2022

To stay tuned, keep an eye on our release notes. You can now enable a burn rate visualization during SLO creation either from the SLO wizard or from Service-level objective definitions by enabling Burn rate visualization enabled. Now you can extend your observability into data acquired from an Oracle Database using SQL queries.

Azure 212

Azure Metrics AWS Monitoring 212

The Netflix TechBlog

JUNE 13, 2023

Migrating Critical Traffic At Scale with No Downtime — Part 2 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Picture yourself enthralled by the latest episode of your beloved Netflix series, delighting in an uninterrupted, high-definition streaming experience.

Traffic 279

Traffic Metrics Systems Strategy 279

Percona

OCTOBER 17, 2023

Many changes and new features are brought to the system, and as part of keeping in tune with the changes and how they can impact us, we go through the changes to better understand them. The dynamic allocation might have flaws, but it’s definitely a good addition. Bounce the database, replacing the binaries with the older release.

Metrics 100

Metrics C++ Storage Database 100

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. This can help to split large data sets into smaller ones stored in multiple servers.

Open Source 87

Open Source Storage Database Big Data 87

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. Then follow the instructions to either download the BOL or browse online.

Servers 40

Servers Cache Media Hardware 40

Dynatrace

MAY 16, 2019

Once the EAP has been activated for your environment, you’ll see a new Service metrics entry in the Server-side service monitoring settings menu. Calls to database. Time spent in calls to database. Stay tuned for details. Request count. Successful request count. Failed request count. Failure rate. HTTP 4xx count.

Metrics 116

Metrics Analytics Programming Monitoring 116

SQL Performance

APRIL 8, 2020

As Grant repeatedly points out, many who use common table expressions in T-SQL think that SQL Server persists the inner query result set, and that the reason for this belief is the use of the term table in the construct's name. In my examples I'll use a sample database called TSQLV5. Physical data independence.

C++ 143

C++ Azure Database Servers 143

The Netflix TechBlog

FEBRUARY 9, 2021

Plans & Offers Definitions Let’s define what a plan and an offer is at Netflix. The action corresponds to the button on the page and the withFields specify which fields the server expects to have sent back when the button is clicked. The database contains the plans, prices and offers. Step 3 & 4?—?Determine

Engineering 142

Engineering Scalability Architecture Innovation 142

Alex Podelko

OCTOBER 20, 2016

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. System’s configuration is not given anymore and often can’t be easily mapped to hardware.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. I tested my solutions in SQL Server 2019 Enterprise edition. SQL Server chose row mode processing for all previously shown solutions by default. There are a couple of ways to get SQL Server to use batch processing here. You can add hints as needed.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

JANUARY 11, 2021

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. We'd definitely prefer to change the query, or the indexes, if we could. Let's try a plan guide.

Cache 59

Cache Tuning Database Performance 59

KeyCDN

OCTOBER 31, 2018

Thanks to its reliable performance, extensive documentation and dedicated user community, PHP is one of the preferred server-side scripting language of many web developers. PHPStorm PHPStorm streamlines application development by offering integration with relational databases and other PHP tools. Best PHP Development Environments 1.

Development 57

Development Open Source Java AWS 57

SQL Performance

APRIL 6, 2020

DDL); and, it captures events using local time (our servers are Eastern and obey DST). FROM trc ORDER BY StartTimeUTC DESC ; Sample results from one server, where there were definitely some manual and automatic events that happened ( click to enlarge ): Writing a replacement. EndTime < DATEADD ( HOUR , 2 , st2.

Servers 61

Servers Tuning Database 61

Percona

MARCH 7, 2019

The server is a small instance: Models | 6xIntel(R) Xeon(R) CPU E5-2430 0 @ 2.20GHz 10GB RAM This symptom can be caused by various different reasons. There could be more, but this particular query was definitely hurting the performance of the server. We needed to reduce the high CPU usage on MySQL. Increase QPS by 2x.

C++ 99

C++ Traffic Servers Monitoring 99

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. I tested my solutions in SQL Server 2019 Enterprise edition. SQL Server chose row mode processing for all previously shown solutions by default. There are a couple of ways to get SQL Server to use batch processing here. You can add hints as needed.

C++ 61

C++ Servers Testing Processing 61

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. It’s fast, too, but it’s not perfect.

C++ 59

C++ Servers Testing Database 59

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. Egnyte Connect Tech Stack. Cloud Platform.

Architecture 52

Architecture Cache Azure Storage 52

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. It definitely works on 4.14, if you can run that, with CPUs that support pcid (check /proc/cpuinfo). Much of my testing was on Linux 4.14.11 and 4.14.12 On recent LTS Linux (4.4

Performance 75

Performance Benchmarking Cache Tuning 75

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. It definitely works on 4.14, if you can run that, with CPUs that support pcid (check /proc/cpuinfo). Much of my testing was on Linux 4.14.11 and 4.14.12 On recent LTS Linux (4.4

Performance 40

Performance Benchmarking Cache Tuning 40

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 108

Open Source Artificial Intelligence Google Infrastructure 108

O'Reilly

JANUARY 17, 2023

You’ll try this with a few other algorithms, and their respective tuning parameters–maybe even break out TensorFlow to build a custom neural net along the way–and the winning model will be the one that heads to production. This person is comfortable talking to databases to pull data, then calling Pandas to transform it.

Tuning 130

Tuning Open Source AWS Software 130

Smashing Magazine

OCTOBER 22, 2021

Clearly, the “first client rules all” approach needed to be replaced with a solution in which the game state lives on the server. Note : The Colyseus docs make it easy to get started with a barebones Colyseus server by providing an npm init script and an examples repository. Project Setup. Creating A Schema.

Games 95

Games Servers Database Virtualization 95

O'Reilly

OCTOBER 11, 2022

It’s possible to augment this basic process with OCR so the application can find data on paper forms, or to use natural language processing to gather information through a chat server. However, one thing should be obvious: to fill a prescription, you need to access many different kinds of data, in many different databases.

Games 116

Games Healthcare Processing Retail 116