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 row Database: test Create Database: CREATE DATABASE `test` /*!40100

Database 114

Database Servers Engineering Testing 114

High Scalability

JANUARY 11, 2022

We will use a graph database such as Neo4j to store the information. Additionally, we can use columnar databases like Cassandra to store information like user feeds, activities, and counters. Sample Queries supported by Graph Database. Subsequently, the data entities C and D denote the different actions which users may take.

Design 334

Design Media Storage Logistics 334

HammerDB

JULY 14, 2021

However, as the two databases diverged from a shared common codebase, this presented a challenge in that it was not possible to modify the workload for MySQL or MariaDB without also changing the other. Checking database library for MariaDB Error: failed to load mariatcl - couldn't load file "/home/HammerDB-4.2/lib/mariatcl0.1/libmariatcl0.1.so":

Testing 57

Testing C++ Virtualization Tuning 57

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

HammerDB

FEBRUARY 27, 2024

The HammerDB TPROC-C and TPROC-H workloads are derived from the TPC-C and TPC-H workloads respectively. Although the HammerDB workloads are not identical to TPC-C and TPC-H it is still important that the workloads implemented maintain the same data consistency as the official workloads. Database Exists. Tables Exist.

C++ 62

C++ Database Virtualization Testing 62

Percona

OCTOBER 13, 2023

Visual Studio Code (VS) supports memory dump debugging via C/C++ extension: [link]. Installing c/c++ extension We need to install the c/c++ extension. ext install ms-vscode.cpptools Once we install the c/c++ extension, we can find it in extensions. Here are the instructions for doing so.

Code 98

Code C++ Storage Programming 98

HammerDB

JULY 15, 2021

Instead, however, this was an imposed limit to encourage right-sizing of the test database instead of over-sizing. In the example below, the value 5000 can be seen as the fourth argument to the function do_tpcc. However, the precision of some numeric data types may not have been sufficient for larger values in some databases.

C++ 52

C++ Virtualization Database Testing 52

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. These are not in this blog’s scope to keep this example simple.

C++ 81

C++ Open Source Database Programming 81

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. This earlier functionality has the advantage that there are no intermediate staging files required, and data is inserted into the database with multi-row inserts as soon as it is created.

Servers 62

Servers C++ Benchmarking Virtualization 62

Percona

APRIL 10, 2023

During export, mydumper sends SELECT statements to the database. The new function has this syntax: random_format { <{file|string n|number n}> | DELIMITER | 'CONSTANT' }* This are some examples: `phone`=random_format '+1 ('<number 3>') '<number 3>'-'<number 4> `emails`=random_format <file names.txt>'.'<file

Testing 102

Testing C++ Open Source Database 102

SQL Performance

MAY 24, 2022

I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. The WINDOW Clause.

Servers 145

Servers C++ Code Database 145

Percona

SEPTEMBER 29, 2023

sec) mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP , REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE,CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE on *.* mysql> create user app_user identified by 'App@!234TEst';

C++ 92

C++ Servers Open Source Database 92

HammerDB

JUNE 22, 2023

Configuring the Jobs Database The base configuration is set in the xml files in the config directory with the jobs SQLite database being set in the commandline section of generic.xml by specifying the filename. So for example to change this to hammer.db So for example to change this to hammer.db DATA/hammer.db TMP/hammer.DB

Benchmarking 57

Benchmarking C++ Virtualization Database 57

Scalegrid

JUNE 18, 2019

for this example. The Ruby version used in both the examples below is 2.6.3. servers.mongodirector.com:27017,SG-example-17027.servers.mongodirector.com:27017,SG-example-17028.servers.mongodirector.com:27017/test?replicaSet=RS-example-0&ssl=true" servers.mongodirector.com:27017,SG-example-17028.servers.mongodirector.com:27017/test?replicaSet=RS-example-0&ssl=true"

C++ 100

C++ Servers Database Network 100

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 Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 3306 0s ok 5.7.41-44-log 3306 0s ok 5.7.41-44-log

C++ 81

C++ Monitoring Database Open Source 81

Percona

JUNE 20, 2023

In order to understand “segmentation fault,” it is a must to know the basic idea of segmentation and its implementation in C programming. However, this blog is written from the database perspective; hence, I would not prefer to dive into those scenarios as they are very high-level programming concepts.

Programming 81

Programming C++ Database Virtualization 81

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. 132:39: warning: unused parameter ‘initid’ [-Wunused-parameter] extern "C" void ulid_deinit(UDF_INIT *initid) {} ~~~~~~~~~~^~~~~~ [100%] Linking CXX shared module././plugin_output_directory/ulid.so

C++ 78

C++ Servers Benchmarking Best Practices 78

Scalegrid

JANUARY 19, 2024

For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines. To traditional relational databases, where rollbacks are less likely to cause data loss, MongoDB differs significantly.

Database 130

Database Network Servers Monitoring 130

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. 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. Sample Data.

C++ 112

C++ Code Azure Database 112

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. Copyright (c) 2016, 2023, Oracle and/or its affiliates. Press ^C to stop.

C++ 101

C++ Servers Storage Speed 101

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. As such, it is generally recommended to disable THP for most database workloads.

Database 85

Database Servers Open Source C++ 85

SQL Performance

MAY 11, 2022

In my examples, I’ll use the sample database PerformanceV5. You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. For simplicity’s sake, you can prevent parallelism in all examples shown in this article.

C++ 133

C++ Database Servers Code 133

Dynatrace

JULY 21, 2020

W ith the Dynatrace CICS SDK and IMS SDK for z/OS , m ainframe programmers can instrument their applications written in Assembler, C, COBOL, or PL/I to gain those required insights. The IMS service flow traverses the IMS SOAP Gateway and different IMS regions, finally hitting a DL/I database. JDBC database connections.

Java 182

Java Government Database Programming 182

HammerDB

DECEMBER 1, 2022

For example on Windows an example of opening a new database. Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB For example, we will run the following script to build a TPROC-C schema.

Virtualization 57

Virtualization C++ Storage Database 57

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency.

C++ 109

C++ Database Servers Code 109

HammerDB

NOVEMBER 22, 2021

HammerDB included a graphical performance metrics view for the Oracle database only. HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. This example uses a PostgreSQL source based build with the pg_stat_statements extension found in the contrib directory.

Metrics 62

Metrics Benchmarking C++ Database 62

HammerDB

JULY 17, 2019

The next step is to see if there is an Issue already created for the database we want to add or whether we should create one. In this example using MariaDB there is already an Issue created Add MariaDB as a separate database #54 although note that this can be for any database you choose. <? . <mariadb>

Database 40

Database C++ Testing Metrics 40

HammerDB

OCTOBER 17, 2018

The official TPC-C test has a fixed number of users per warehouse and uses keying and thinking time so that the workload generated by each user is not intensive. Also depending on your chosen database some database software will not scale to fully utilise all cores, see the best practice guides for guidance on your chosen database.

C++ 40

C++ Testing Virtualization Cache 40

SQL Performance

OCTOBER 9, 2019

If you have examples of your own of T-SQL gems that are often overlooked, please do share those in the comments section of this article. In my examples I'll use a sample database called TSQLV5. In my examples I'll use a sample database called TSQLV5. EOMONTH has a second parameter.

C++ 111

C++ Database Servers Code 111

Percona

OCTOBER 12, 2023

An example of a flame graph can be found below: Each box is a function in the stack, and wider boxes mean more time the system was busy on CPU on these functions. An example is kubectl-flame ( [link] ). For example, if you specify the NodeJS language, it produces the flame graph based on perf output. ✔ Launching profiler.

Code 106

Code Tuning C++ Benchmarking 106

Dynatrace

JULY 12, 2022

The platform might identify, for example, that a SQL database “leverages [a particular] node when we do our Tlog [transaction log] backups,” he says. “We After implementing Dynatrace’s observability platform, though, the C suite has gained confidence in its IT teams to fix problems efficiently.

Innovation 224

Innovation Infrastructure DevOps Azure 224

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency.

C++ 93

C++ Database Servers Code 93

SQL Performance

JULY 1, 2021

Let's create a simple database with a few tables: CREATE DATABASE BadIdeas ; GO. name , [ Column ] = c. name , [ Data Type ] = TYPE_NAME ( c. system_type_id <> c. THEN N' (' + TYPE_NAME ( c. columns AS c INNER JOIN sys. objects AS o ON c. [ USE BadIdeas ; GO.

C++ 58

C++ Database Servers Performance 58

HammerDB

NOVEMBER 30, 2022

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. Vuser 1:Writing timing data to C:/Users/Hdb/AppData/Local/Temp/hdbxtprofile.log Vuser 1:FINISHED SUCCESS ALL VIRTUAL USERS COMPLETE vudestroy success TEST SEQUENCE COMPLETE hammerdb>>> Python Performance and the GIL. Use a different Browser.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Dynatrace

APRIL 11, 2023

For example, the open source Java library at the heart of the Log4Shell crisis in 2021 was patched within days given the pervasiveness of the code. For example, in a recent study , 55% of security teams say they don’t trust developers, and 49% of developers perceive security teams as a blocker to innovation.

Cloud 192

Cloud DevOps Open Source Retail 192

Dynatrace

OCTOBER 7, 2020

Seamlessly report and be alerted on non-topology-related custom metrics, using Dynatrace as a metric database. Topology metrics are related to specific entities in your Smartscape topology (for example, the number of successful and failed batch jobs processed by a host). Topology and non-topology metrics—what’s the difference?

Metrics 246

Metrics Analytics Storage Monitoring 246

Percona

DECEMBER 5, 2022

The need to audit who is using a database and their activities is crucial in many environments. 22 Percona Server (GPL), Release '22', Revision '7e301439b65' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'c' to clear the current input statement.

Open Source 67

Open Source C++ Servers Database 67