Percona

DECEMBER 29, 2022

The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running. The process using pg_upgrade is well documented , and you can easily find the instructions with little googling. for lib in $(psql -qtA pgbench -c"select extname||'.so'

C++ 82

C++ Open Source Database Programming 82

SQL Performance

OCTOBER 9, 2019

The relevance to T-SQL is that sometimes we assume that we know everything there is to know about certain T-SQL features, and don't always bother checking the documentation to see if there's more to them. The EOMONTH function was introduced in SQL Server 2012. SQL Server 2017 introduced support for the function TRIM.

C++ 111

C++ Database Servers Code 111

HammerDB

OCTOBER 23, 2023

HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. Additionally, reviewing official TPC-C full disclosure reports highlighted that all vendors also use stored procedures.

Benchmarking 62

Benchmarking Database Network C++ 62

Smashing Magazine

NOVEMBER 26, 2021

However, there are a few ways in which you can make a large code-base easy to maintain. In certain cases, the build will fail if there are type mismatches in your code as Next.js We recommend using code editor type checking during development.”. Use Code Generators Like Hygen To Generate Boilerplate Code.

Cache 143

Cache Code Testing Design 143

Brendan Gregg

JANUARY 1, 2019

Some of these have plenty of free documentation online, like for tracing, and others not yet. Programming in eBPF directly is incredibly hard, the same as coding in v8 bytecode. But no one codes in v8: they code in JavaScript, or often a framework on top of JavaScript (jQuery, Angular, React, etc). encodings/ascii.so

C++ 111

C++ Virtualization Programming Code 111

Testlodge

MARCH 15, 2023

Internal structure may include code, architecture, integrations, and data flows of a system. The more code is tested, the less likely it is to have defects, and any defects found will have less severity. The more code is tested, the less likely it is to have defects, and any defects found will have less severity.

Testing 83

Testing Testing Tools Java Programming 83

HammerDB

NOVEMBER 30, 2022

If you need a different version of Python you can build HammerDB from source as detailed in the documentation to use any version of Python 3 that you wish. Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. Red Hat Enterprise Linux. Starting the CLI in Python Mode. Use a different Browser. $./hammerdbcli

Virtualization 44

Virtualization C++ Lambda Monitoring 44

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. name , [ Column ] = c. system_type_id <> c.

C++ 58

C++ Database Servers Performance 58

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

Smashing Magazine

JUNE 18, 2020

Flutter isn’t that, though: it runs natively on each platform, and it means each app runs just like it would run if it were written in Java/Kotlin or Objective-C/Swift on Android and iOS, pretty much. You need to know that because this implies that you need to take care of the many differences between these very diverse platforms.

Storage 93

Storage Mobile Website Java 93

Sutter's Mill

JANUARY 11, 2021

Assertions have been a foundational tool for writing understandable computer code since we could write computer code… far older than C’s assert() macro, they go back to at least John von Neumann and Herman Goldstine (1947) and Alan Turing (1949). 1,2] How well do we understand them… exactly? GUIDELINE: Assert liberally. [3]

C++ 58

C++ Programming Code Testing 58

HammerDB

NOVEMBER 22, 2021

usr/bin/install -c -m 644./pg_stat_statements--1.4.sql./pg_stat_statements--1.8--1.9.sql./pg_stat_statements--1.7--1.8.sql./pg_stat_statements--1.6--1.7.sql./pg_stat_statements--1.5--1.6.sql./pg_stat_statements--1.4--1.5.sql. include/server -I/opt/postgresql-14.1/include/internal include/internal -D_GNU_SOURCE -c -o pgsentinel.o

Metrics 62

Metrics Benchmarking C++ Database 62

Brendan Gregg

DECEMBER 31, 2018

Some of these have plenty of free documentation online, like for tracing, and others not yet. Programming in eBPF directly is incredibly hard, the same as coding in v8 bytecode. But no one codes in v8: they code in JavaScript, or often a framework on top of JavaScript (jQuery, Angular, React, etc). encodings/ascii.so

C++ 52

C++ Virtualization Programming Code 52

SQL Performance

SEPTEMBER 21, 2022

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. For the full technical details, I provided links to the official documentation.

Servers 122

Servers C++ Code Cache 122

HammerDB

APRIL 19, 2023

There are several ways to find out this information with the easiest way being by referring to the documentation. For the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement. and 8.0.32 HammerDB 4.5 Concurrency at 80 VU’s 1.00

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). Borrowing and adapting code from a previous post, Examining the Performance Impact of an Adhoc Workload , we will first create two stored procedures. CustomerID , c.

C++ 74

C++ Database Servers Tuning 74

Brendan Gregg

JULY 2, 2021

There is already documentation as man pages and example files in the bcc and bpftrace repositories that you can link to, to help your customers understand the tool output. The architecture is: While the bpftrace binary is installed on all the target systems, the bpftrace tools (text files) live on a web server and are pushed out when needed.

Latency 145

Latency Cache Energy Systems 145

Percona

DECEMBER 23, 2022

In this blog, we will integrate both of these tools and understand how they can work together to reduce the server load. It can be on a dedicated server or one of the DB hosts. However, it is recommended to use a dedicated server as in case DB goes down, we have a separate server to make the life of the DBAs easier.

Open Source 62

Open Source Servers Database Availability 62

Dynatrace

JUNE 10, 2022

The IT world is rife with jargon — and “as code” is no exception. “As code” means simplifying complex and time-consuming tasks by automating some, or all, of their processes. Today, the composable nature of code enables skilled IT teams to create and customize automated solutions capable of improving efficiency.

Best Practices 207

Best Practices Infrastructure Code Speed 207

SQL Performance

DECEMBER 11, 2019

Like them or not, as a database practitioner you often have to deal with them, and given that NULLs do add complexity to your SQL code writing, it's a good idea to make it a priority to understand them well. The documentation also states that support for this option will be removed in some future version of SQL Server.

Best Practices 117

Best Practices C++ Database Code 117

Percona

JANUARY 28, 2019

EverSQL (use code PERCONA-EVERSQL-10OFF for a 10% discount on the first billing cycle) is a platform that intelligently tunes your SQL queries by providing query optimization recommendations, and feedback on missing indexes. The original runtime of that query is above 20 minutes and causes high load on the server while running.

Monitoring 42

Monitoring C++ Tuning Analytics 42

SQL Performance

APRIL 10, 2019

I posted a suggestion to improve SQL Server by adding support for RPR in T-SQL , but I was quite limited in the space that I had to provide the feedback. Use the following code to create the table, populate it with some sample data, and query it: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. LAST ( C.

C++ 73

C++ Servers Virtualization Code 73

CSS Wizardry

OCTOBER 16, 2023

Concatenating our files on the server: Are we going to send many smaller files, or are we going to send one monolithic file? Concatenate Concatenation is probably the trickiest bit to get right because, even though the three C s happen in order, decisions we make later will influence decisions we make back here. Back in the HTTP/1.1

Cache 291

Cache Latency Strategy Speed 291

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

SQL Performance

AUGUST 12, 2020

You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. T-SQL supports it starting with SQL Server 2005. What’s different about the design of CTEs compared to derived tables is where in the code these three elements are located. The elements are sort of intertwined.

C++ 140

C++ Code Design Database 140

Brendan Gregg

JULY 2, 2021

There is already documentation as man pages and example files in the bcc and bpftrace repositories that you can link to, to help your customers understand the tool output. The architecture is: While the bpftrace binary is installed on all the target systems, the bpftrace tools (text files) live on a web server and are pushed out when needed.

Open Source 40

Open Source Latency Cache Energy 40

Tasktop

OCTOBER 16, 2019

Ready to start digging into some code again, he gave me the broad picture: Internally we use Log4j2 as our logging solution of choice (with the various off-the-shelf adapters to handle 3rd libraries with different log frameworks). We run a lot of similar tests against myriad servers and even more versions of the aforementioned.

C++ 9

C++ Servers Testing Infrastructure 9

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

The Netflix TechBlog

MARCH 13, 2020

SVT-AV1 codebase status The SVT-AV1 repository includes both an AV1 encoder and decoder, which share a significant amount of the code. SVT-AV1 is written in C and can be compiled on major platforms, such as Windows, Linux, and macOS. The project is bolstered with extensive unit test coverage and documentation.

Open Source 154

Open Source Efficiency C++ Speed 154

HammerDB

JUNE 27, 2022

HammerDB is Free software and consequently engineers should consider not only how they can benefit from using the software but also how they can contribute to the community with code and documentation. In addition to the TPC-C specification for OLTP workloads, the TPC has also developed the TPC-E specification. The NOPM Metric.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

OCTOBER 17, 2023

Stricter downgrade policy The upstream documentation highlights the following: Starting in MongoDB 7.0, that’s not supported anymore , from the upstream documentation : MongoDB only supports single-version downgrades. Not being able to modify taskExecutorPoolSize is a good action to protect against overestimated parametrization.

Metrics 104

Metrics C++ Storage Database 104

All Things Distributed

NOVEMBER 22, 2016

AWS will contribute code and improved documentation as well as invest in the ecosystem around MXNet. In addition to scalability, MXNet offers the ability to both mix programming models (imperative and declarative), and code in a wide number of programming languages, including Python, C++, R, Scala, Julia, Matlab, and JavaScript.

AWS 167

AWS Open Source Scalability Programming 167

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. For HammerDB both TPROC-C and TPROC-H run all of their workloads on the database being tested in SQL. Database interfaces in C. select top 100.

Programming 67

Programming Benchmarking Virtualization C++ 67

Randon ASCII

OCTOBER 4, 2020

The behavior of the Windows scheduler changed significantly in Windows 10 2004, in a way that will break a few applications, and there appears to have been no announcement, and the documentation has not been updated. I think the new behavior is an improvement, but it’s weird, and it deserves to be documented. That’s crazy!

Programming 145

Programming Games Hardware Operating System 145

SQL Server According to Bob

FEBRUARY 13, 2020

​​ When the utility attempted to issue the thaw command the command would be queued, and the database could not return to an operational state until SQL Server was restarted. ​​ While the name can be any string it is commonly a Guid accommodating the ​​ uniqueness requirements.

Servers 40

Servers Availability Transportation Database 40

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Enprowess

MAY 24, 2022

It allows developers to create complex UIs from a small and isolated code called “components” ReactJS comprises two parts: the pieces containing HTML code, components, and an HTML document – where all your components will render. Platform-specific code. Power boost to Search Engine Optimization (SEO).

Mobile 52

Mobile Open Source Virtualization Speed 52