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. Is MongoDB free to use?

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. 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

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

Tim Kadlec

APRIL 12, 2020

The cache hit was very low (a topic for another day), and whenever the server had to provide a fresh version of the page, it was taking an unacceptably long time more often than not. Synthetic tests, even properly tuned to match device and network characteristics, only occasionally surfaced the issue.

Tuning 69

Tuning Cache Network Servers 69

MachMetrics

JULY 31, 2020

But we’ll definitely help you decide which is the best choice for your situation. Simply put, compression allows the web server to send smaller files to your web site viewers. Thankfully, it’s almost universally supported by web servers and all modern browsers and is also fairly easy to set up, as we’ll detail below.

Speed 67

Speed Servers Google Tuning 67

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

Percona

JANUARY 19, 2023

Sharding: Sharding is the concept of splitting data horizontally, i.e. by distributing data into multiple servers (shards), meaning that the different portions of data for a given table, may be stored on many different servers. This can help to split large data sets into smaller ones stored in multiple servers.

Open Source 88

Open Source Storage Database Big Data 88

SQL Performance

DECEMBER 9, 2020

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. Here’s the dummy table definition: CREATE TABLE dbo. For these reasons, I prefer option 1.

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

SQL Performance

DECEMBER 9, 2020

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. Here’s the dummy table definition: CREATE TABLE dbo. For these reasons, I prefer option 1.

C++ 61

C++ Servers Testing Processing 61

Percona

AUGUST 29, 2018

Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload. Be aware of differing definitions. These are the definitions: Linux: kernel.shmmax, kernel.shmall. Summing up.

Tuning 55

Tuning Database Servers Processing 55

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Architecture Database Servers 246

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.

C++ 100

C++ Traffic Servers Monitoring 100

The Netflix TechBlog

JUNE 14, 2023

Before GraphQL: Monolithic Falcor API implemented and maintained by the API Team Before moving to GraphQL, our API layer consisted of a monolithic server built with Falcor. A single API team maintained both the Java implementation of the Falcor framework and the API Server. To launch Phase 1 safely, we used AB Testing.

Traffic 353

Traffic Latency Cache Metrics 353

The Netflix TechBlog

AUGUST 22, 2019

The configuration file, referenced scripts, and artifact dependency definitions all live in an internal git repository. Running a canary for each change and testing the AMI in production allows us to capture insights around impact on Windows updates, script changes, tuning web server configuration, among others.

DevOps 207

DevOps AWS Tuning Infrastructure 207

Percona

AUGUST 30, 2023

Those parameters taken from the specific data directory initialization, which overrides the built-in parameters, can be checked like this: select name,setting from pg_settings where source='override'; This override includes some of the calculated auto-tune values for that environment. But changing this is possible only at the server startup.

Database 102

Database Servers Open Source Tuning 102

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

AUGUST 27, 2018

It is well hidden in the Optimization: Optimizing the MySQL Server chapter. In my scenario, I have a very noisy secondary application written by a very, very bad developer that accesses my servers, mostly with read queries, and occasionally with write updates. Then we need to see IF implementing the tuning will work or not.

Tuning 45

Tuning Virtualization Testing Servers 45

Percona

MARCH 23, 2023

PostgreSQL supports sharding, which allows data to be distributed across multiple servers, making it ideal for high-traffic websites and applications. If you are looking for a database system for your enterprise-level application, PostgreSQL is definitely worth considering.

Database 116

Database Open Source Traffic Small Business 116

Tim Kadlec

MARCH 23, 2009

I’ve mentioned before that the curriculum taught in most colleges tends to be dated and in need of definite help. Server-side Development. There is also a place to discuss the curriculum and input suggestions or criticisms to help fine tune the subjects addressed. Front-end Development. User Science. A Complete Package.

Education 40

Education Tuning Design Speed 40

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. This will happen with Dynatrace version 1.242 or later. New features and enhancements. APM-363024).

Azure 215

Azure Metrics AWS Monitoring 215

O'Reilly

FEBRUARY 13, 2024

The courts will have to decide whether inadvertent, inconsequential, or unpredictable reproduction meets the legal definition of copyright infringement. I’m sure the monopolists would say “of course, those can be built by fine tuning our foundation models”; but do we know whether that’s the best way to build those applications?

Open Source 93

Open Source Strategy Government Tuning 93

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. The second is the experienced ML professional who really knows how to build and tune models.

Tuning 130

Tuning Open Source AWS Software 130

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. From that, this article is born.

Metrics 101

Metrics C++ Storage Database 101

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

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

MachMetrics

APRIL 3, 2020

You will start with the front end optimization (parallel downloading, compression, JS optimization) and then go behind the scene with tips about the back end optimization and performance (memcache, Redis, MySQL tuning tips, NGINX and HA proxy). Definitely a must read for whoever is interested in web performance! – Aurel V.

Speed 85

Speed Performance Best Practices Website 85

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. SQL guarantees that the columns will be returned from left-to-right based on definition order.

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. A plan is essentially a set of features with a price. Step 3 & 4?—?Determine

Engineering 142

Engineering Scalability Architecture Innovation 142

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. You can add further conditions to the metric definition to limit the metric to a specific set of services or to a single service. Stay tuned for details.

Metrics 116

Metrics Analytics Programming Monitoring 116

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

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

Smashing Magazine

AUGUST 22, 2021

Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). This is one of the main reasons why content delivery networks (CDNs) exist: They place servers physically closer to the end user in order to reduce latency, and thus delay, as much as possible. and prior (a)).

Performance 106

Performance Network Latency Servers 106

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. Thanks to the built-in PHP server and debugging tool, you can integrate your other PHP tools to build and test PHP apps in one environment.

Development 57

Development Open Source Java AWS 57

HammerDB

FEBRUARY 25, 2021

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. and the following from TPROC-H. select top 100. where p_partkey = ps_partkey. Glue language.

Programming 67

Programming Benchmarking Virtualization C++ 67