Percona

APRIL 4, 2023

Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word. Instead, the server informs you that you have a syntax error. Yes, there is a workaround.

Open Source 118

Open Source Database Servers Scalability 118

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. While classic logging is an essential tool in debugging issues, it often lacks context and only provides snapshot information of one specific location in your code/application. Those are prime candidates for their own spans.

Metrics 177

Metrics Open Source Traffic Cache 177

CSS Wizardry

DECEMBER 9, 2023

All code examples are complete and correct. Connection overhead isn’t huge , but too many preconnect s that either a) aren’t critical, or b) don’t get used at all, is definitely wasteful. Further, opening and persisting connections has a CPU overhead on both the client and the server. When to Use crossorigin Okay.

Speed 234

Speed Network Analytics Availability 234

Randon ASCII

AUGUST 30, 2020

Sometimes tracking down a bug is as simple as paying attention to server dashboards, spending a few minutes in a profiler, or looking at compiler warnings. Server CPU Surprise. A few years ago I spent a few weeks doing some memory investigations on live game servers. The first server process that I profiled was… odd.

Games 142

Games Servers Code Monitoring 142

Dynatrace

MARCH 17, 2021

A single OneAgent instance can handle the monitoring of many types of entities, including servers, applications, services, databases, and more. You want to optimize your Citrix landscape with insights into user load and screen latency per server? Your SAP instance is slow, and you don’t know which transactions or users are affected?

Metrics 167

Metrics Monitoring Network Technology 167

Percona

AUGUST 30, 2023

If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code. 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 105

Database Servers Open Source Tuning 105

Brendan Gregg

APRIL 8, 2022

In this case there's an orange tower (kernel code) that's unusual. At Netflix, 10% of CPU time somewhere unexpected can be a large costly issue across thousands of server instances. But this process had been up and running for hours, and shouldn't still be doing so much page fault growth of its RSS. Why is it Still Faulting?

Performance 100

Performance Virtualization Code Servers 100

SQL Performance

JULY 14, 2021

The code that I’ll be using in this article can be executed in any database, but in my demos, I’ll be using TSQLV5—the same sample database that I used in previous articles. Use the following code to create a table called dbo.T1, and a view called dbo.V1 Use the following code to query the view: SELECT * FROM dbo. sql_modules.

Code 117

Code Database Servers Availability 117

SQL Performance

SEPTEMBER 8, 2021

Use the following code to create these tables in tempdb and populate them with some initial sample data: USE tempdb ; GO. To understand the circumstances where you would want to use the CHECK OPTION as part of a view’s definition, we’ll first examine what can happen when you don’t use it. Sample Data. DROP TABLE IF EXISTS dbo.

Servers 130

Servers Code Engineering Database 130

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. looking out for MongoDB Inc.

Open Source 83

Open Source Programming Database Servers 83

SQL Performance

APRIL 14, 2021

Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Let’s examine the plans for two of the earlier solutions that utilized batch processing. Here’s the function’s definition: -- Helper dummy table. DROP TABLE IF EXISTS dbo. BatchMe ; GO.

C++ 112

C++ Servers Testing Code 112

SQL Performance

FEBRUARY 10, 2021

I’ll do my testing in tempdb, enabling IO and TIME statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS IO , TIME ON ; The fastest solution from last month applies a join with a dummy table that has a columnstore index to get batch processing. Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. BatchMe ; GO.

C++ 124

C++ Servers Testing Code 124

Smashing Magazine

JULY 20, 2022

There doesn’t seem to be an indication of limitations on file size or the number of files, but it is a slow process if you try to do a bulk conversion. The compression, in this case, seems to be on the server side, so you’ll get much faster results. compresses images on the server. You’ll definitely want to give SVGOMG a try!

Media 134

Media Programming Mobile Website 134

Testsigma

APRIL 4, 2022

Automation is defined by Wikipedia as a wide range of technologies that reduce human involvement in processes. Let’s look at the definition of quality to see how test automation isn’t quality assurance. One of the popular definitions of Quality is that it is “value” to someone “who” matters. Martin Fowler.

Testing 95

Testing Open Source IoT Programming 95

tRPC

JANUARY 16, 2023

post ) throw new TRPCError ({ code : "NOT_FOUND" }); return post ; }) , ; 5 more.; post ) throw new TRPCError ({ code : "NOT_FOUND" }); return post ; }) , ; 5 more.; post ) throw new TRPCError ( { code : " NOT_FOUND " } ) ; return post ; } ) , ; 5 more.; any): Post | undefined (+1 overload)">find (( p ) => p. id ); if ( !

Servers 138

Servers Code Network Database 138

Dynatrace

JULY 10, 2019

Just a single OneAgent per host is required to collect all relevant monitoring data, all the way down to specific lines of code. This article we help distinguish between process metrics, external metrics and PurePaths (traces). However, there are certain situations where you’d like to extend our Dynatrace out-of-the-box monitoring.

Java 136

Java Best Practices Metrics Azure 136

High Scalability

FEBRUARY 1, 2022

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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MAY 4, 2022

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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

Scalegrid

JANUARY 20, 2020

We have all been there – a supposedly well-tested piece of code is deployed in production, and then all hell breaks loose. And since the entire import is performed using storage snapshots, rather than a logical dump, the process is nearly instantaneous. Database Dev/Test Setup.

Analytics 185

Analytics Storage Database Systems 185

High Scalability

JULY 18, 2022

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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

DECEMBER 9, 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

SQL Performance

MAY 13, 2020

Logical query processing handles query clauses in the following order: FROM>WHERE>GROUP BY>HAVING>SELECT>ORDER BY. I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well.

C++ 143

C++ Code Design Servers 143

Percona

APRIL 26, 2023

When a project’s source code is available to all, the question of security isn’t far behind. How can something be secure if anyone can examine the code and look for security flaws? Would-be attackers can comb through source code to find security flaws. Let’s start with the big one, security. Sometimes they do!

Open Source 86

Open Source Software Software Social Media 86

High Scalability

JUNE 10, 2022

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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MARCH 18, 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

MARCH 18, 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

JULY 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

JUNE 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

Testsigma

JUNE 10, 2021

In a 2FA system, a user has to enter a password and an OTP or a code obtained from a different app. Definition of 2 Factor Authentication : Authentication by means of both – a password and an OTP. Can you really automate the process of OTP based authentication under 2FA? See how Testsigma lets you automate 2FA live.

FinTech 140

FinTech Mobile Speed Testing 140

High Scalability

JUNE 8, 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

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. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

Percona

OCTOBER 17, 2023

The dynamic allocation might have flaws, but it’s definitely a good addition. That’s very welcome after upgrade/downgrade processes when metadata is touched after FCV change. In previous releases, the downgrade process was relatively simple: Have a valid backup. Remove backward-incompatible features.

Metrics 104

Metrics C++ Storage Database 104

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. Because the solutions still rely on writing in one single node that works as Primary. The POC Why this POC?

Traffic 125

Traffic Scalability Database Servers 125

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55