Sutter's Mill

MARCH 11, 2024

To talk about C++’s current safety problems and solutions well, I need to include the context of the broad landscape of security and safety threats facing all software. tl;dr: I don’t want C++ to limit what I can express efficiently. tl;dr: I don’t want C++ to limit what I can express efficiently. issues with C++.

C++ 139

C++ Programming Code Java 139

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. In this example on a development PC the regular build started at 10:48:35 and ended at 10:54:46 meaning it took 6 minutes 11 seconds to build our 20 warehouse schema. With the default for v4.9

Servers 62

Servers C++ Benchmarking Virtualization 62

Brendan Gregg

JANUARY 1, 2019

What is an example of eBPF tracing? For example, it does not trace every packet like older techniques, which can add too much performance overhead. encodings/ascii.pyc 25548 gnome-shell 33 0 /proc/self/stat 29588 device poll 4 0 /dev/bus/usb ^C. What's missing is production examples. encodings/ascii.x86_64-linux-gnu.so

C++ 111

C++ Virtualization Programming Code 111

High Scalability

FEBRUARY 17, 2021

Redis Server: 5.07, x86/64. MongoDB server: 4.4.2, BangDB server: 2.0.0, An application example is a session store recording recent actions. Application example: photo tagging; add a tag is an update, but most operations are to read tags. Workload C: Read only. About YCSB. YugabyteDB:2.5.0, Couchbase2: 7.0

Benchmarking 308

Benchmarking Latency C++ Database 308

Percona

FEBRUARY 16, 2023

I asked ChatGPT the question: “C an we backup and then remove the keyring file used for encryption at rest plugin after MySQL starts? ” We can verify that through the following example: We started MySQL with the configuration of “ early-plugin-load=keyring_file.so mysql> [ec2-user@ip-172-31-32-242 ~]$ sudo cat /var/log/mysqld.log.

Database 121

Database Servers Engineering Testing 121

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 87

Servers C++ Database Systems 87

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 OrderID , c. OrderID , c.

Servers 95

Servers C++ Testing Systems 95

Testsigma

FEBRUARY 3, 2021

Example: Let’s take an example of an e-commerce mobile app. Example: We are considering the same e-commerce app example, a small unit like ‘login’ may be tested during the unit testing. Example: Here, we test the integration of two or more modules like- from cart to make a payment module. Reference: [link].

Mobile 82

Mobile Testing Hardware C++ 82

Percona

MARCH 8, 2023

I’ll show an example of this feature; for this example, I have an instance with “max_connections=20”, and I have three users, user “monitor1” has only the PROCESS privilege, user “admin1” has the privileges PROCESS and CONNECTION_ADMIN, finally user “admin2” has the privilege SUPER (deprecated). Commands end with ; or g. No problem!

C++ 99

C++ Database Servers Open Source 99

HammerDB

DECEMBER 5, 2020

compared to previous releases is that the workload names have changed from TPC-C and TPC-H to TPROC-C and TPROC-H respectively and therefore a key question is how are the v4.0 The simple answer is nothing, the workloads are exactly the same workloads derived from the TPC-C and TPC-H specifications and HammerDB v4.0

C++ 40

C++ Benchmarking Virtualization Open Source 40

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

The Netflix TechBlog

NOVEMBER 11, 2022

In semi-supervised anomaly detection models, only a set of benign examples are required for training. On the client’s side, a request is sent to the streaming server to obtain the protected encrypted digital content. false-positive incidents), for example in the case of a buggy client or device.

C++ 312

C++ Metrics Tuning Strategy 312

Percona

DECEMBER 15, 2023

In PostgreSQL 15 and older versions postgres=#CREATE ROLE Alice CREATEROLE LOGIN; CREATE ROLE postgres=# CREATE role bob; CREATE ROLE postgres=# du bob List of roles Role name | Attributes | Member of --+ --+ -- bob | Cannot login | {} postgres=# c postgres alice You are now connected to database "postgres" as user "alice".

C++ 99

C++ Database Open Source Systems 99

Brendan Gregg

DECEMBER 31, 2018

What is an example of eBPF tracing? For example, it does not trace every packet like older techniques, which can add too much performance overhead. encodings/ascii.pyc 25548 gnome-shell 33 0 /proc/self/stat 29588 device poll 4 0 /dev/bus/usb ^C. What's missing is production examples. encodings/ascii.x86_64-linux-gnu.so

C++ 52

C++ Virtualization Programming Code 52

Percona

JULY 19, 2023

Well, “easy” if you know just a tiny bit of C++. Our function will implement a ULID generator using a C++ library from ChrisBove/ulid. Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ mkdir ~/percona-server-8.0.32-24/plugin/ulid/

C++ 84

C++ Servers Benchmarking Best Practices 84

High Scalability

JANUARY 11, 2022

When the server receives a request for an action (post, like etc.) Subsequently, the data entities C and D denote the different actions which users may take. The entity C denotes the event where a user likes a post and entity D denotes the action when a user follows another user. High Level Design. Architecture.

Design 334

Design Media Storage Logistics 334

Brendan Gregg

MARCH 23, 2024

Also note that bcc is evolving and migrating tools from Python to libbpf C (with CO-RE and BTF) but we haven't reworked the package yet. Some servers have accelerators and you'll want their analysis tools installed as well: e.g., on Intel GPU servers, the intel-gpu-tools package; on NVIDIA, nvidia-smi. in the comments).

Servers 145

Servers Traffic Network Systems 145

Percona

SEPTEMBER 29, 2023

This is a global and dynamic variable, and we can set this mode when the server is running. sec) If you try to connect the DB with app_user when offline_mode=1 , it will not allow the connections and get an error message that the server is currently in offline mode. But by using this mode, we can avoid the new connections.

C++ 101

C++ Servers Open Source Database 101

Percona

SEPTEMBER 19, 2023

This issue most often occurs when there is significant MySQL server activity during the backup operation, and the redo log file storage media operates faster than the backup storage media. Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable. Press ^C to stop.

C++ 110

C++ Servers Storage Speed 110

Percona

APRIL 3, 2023

In this blog, we will upgrade PG10, which has tables with OID columns and some extensions to PG13, as an example, using the native pg_upgrade utility. Using Logical Method: We can refer to Replication Between PostgreSQL Versions Using Logical Replication on upgrading using a logical replication method.

C++ 108

C++ Database Cache Storage 108

HammerDB

MAY 26, 2022

You may want to become familiar with all the underlying source code in C or wish to build a distribution where you can verify every single line of source code that goes into HammerDB. X Linux, with the following example from Red Hat Linux. The build has been tested on x64 Red Hat 8.X X and Ubuntu 20.04.X yum install p7zip-16.02-20.el8.x86_64.rpm

C++ 113

C++ Database Open Source Servers 113

Percona

AUGUST 21, 2023

While trying to be as complete yet succinct as possible, I’m detailing how to enable TLS between a PostgreSQL and the OpenLDAP server. Username accounts, but not passwords, are created on the Postgres server. Both username accounts and passwords are configured on the LDAP server. 0 ldap ldapserver=127.0.0.1

C++ 73

C++ Servers Open Source Testing 73

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. In this blog post, I will show you a particular example I faced when working with an upgrade exercise using pg_upgrade. These are not in this blog’s scope to keep this example simple.

C++ 84

C++ Open Source Database Programming 84

Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. for this example. The Ruby version used in both the examples below is 2.6.3. to learn more about this offer. ssl_verify.

C++ 100

C++ Servers Database Network 100

Percona

DECEMBER 29, 2023

For example, many such incidents will have a common root cause” ” something like unexpected, sudden connection explosion — a big bang of connections with hundreds or thousands of idle connections. These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive.

Servers 85

Servers Database C++ Airlines 85

Percona

APRIL 21, 2023

Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 So let’s jump into generating and fixing an errant transaction. On 192.168.56.20:3306,

C++ 88

C++ Monitoring Database Open Source 88

Percona

JULY 5, 2023

For example, while it is possible to test read workload, it is pretty difficult to test things write-related. Checking server version. For example, you can’t dump and restore user definition: mysql 80 > show create user msandbox_ro@localhostG 1. Any changes in system tables made since the 8.0

C++ 122

C++ Database Servers Testing 122

Dynatrace

JUNE 7, 2023

Our example dashboard below visualizes OpenAI token consumption. How Dynatrace traces OpenAI model requests Let’s use a simple NodeJS example service to show how Dynatrace OneAgent automatically traces OpenAI model requests. OneAgent can automatically monitor all C#,NET, Java, Go, and NodeJS bindings.

Monitoring 164

Monitoring Latency Metrics Azure 164

SQL Performance

JULY 13, 2022

At the time of writing, T-SQL doesn’t support it, but PostgreSQL—for example—does. In my examples, I’ll use a table called Orders. L0 AS ( SELECT 1 AS c. This article is dedicated to such a case—specifically, a standard SQL feature related to window functions called the GROUPS window frame option. Sample Data.

C++ 112

C++ Code Azure Database 112

SQL Performance

SEPTEMBER 9, 2020

For example, given the employee ID of some manager, return the input employee, as well as all subordinates of the input employee in all levels; i.e., direct and indirect subordinates. FROM C AS M INNER JOIN dbo. Instead of using ON S.mgrid = M.empid, you used ON S.mgrid = S.mgrid, like so: DECLARE @root AS INT = 3 ; WITH C AS. (

C++ 143

C++ Code Servers Availability 143

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. T-SQL supports it starting with SQL Server 2005. Here’s an example demonstrating this: SELECT custid , country FROM Sales. Let’s start with the term common table expression.

C++ 140

C++ Code Design Database 140

ACM Sigarch

OCTOBER 12, 2020

These, let’s call them metal languages , include FORTRAN (introduced in 1957), C (1972), and C++ (1985). Programmers continue to write applications in them, and they continue to evolve: the just approved C++20 standard is the latest example. Despite their age, these languages are far from dead! As Leiserson et al.

C++ 108

C++ Benchmarking Hardware Architecture 108

SQL Performance

MAY 11, 2022

In my examples, I’ll use the sample database PerformanceV5. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. SQL Server doesn't currently support an efficient combination of a parallel order-preserving input prior to a parallel batch-mode Window Aggregate operator.

C++ 133

C++ Database Servers Code 133

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 93

Database Servers Open Source C++ 93

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries.

C++ 140

C++ Servers Code Efficiency 140

Percona

JUNE 5, 2023

For example, suppose you have a system where you’ve installed multiple data clusters onto a single host. The problem is you either don’t or can’t refactor your application servers; something, maybe, about not having enough time in the day. between multiple instances of PostgreSQL data clusters.

Database 124

Database Open Source Servers C++ 124

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61

IoT Servers Development Cache 61