HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. 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. What is a stored procedure?

Benchmarking 62

Benchmarking Database Network C++ 62

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 If you are not passing this parameter explicitly with the createIndex command, it will use the default settings on a replica set or sharded cluster and start building the index simultaneously across all data-bearing voting replica set members. Starting from PSMDB 4.4,

Servers 83

Servers C++ Storage Best Practices 83

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers 142

Servers Testing C++ Code 142

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment.

C++ 98

C++ Open Source Servers Database 98

Percona

DECEMBER 20, 2023

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information.

C++ 103

C++ Virtualization Benchmarking Database 103

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 109

Servers C++ Storage Systems 109

High Scalability

JANUARY 11, 2022

When the server receives a request for an action (post, like etc.) from a client it performs two parallel operations: i) persisting the action in the data store ii) publish the action in a streaming data store for a pub-sub model. The streaming data store makes the system extensible to support other use-cases (e.g.

Design 334

Design Media Storage Logistics 334

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. Type 'c' to clear the current input statement. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02

Database 100

Database Performance C++ Engineering 100

Percona

DECEMBER 5, 2022

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it.

Servers 60

Servers Cache C++ Metrics 60

Percona

SEPTEMBER 19, 2023

In the world of data backup and security, physical backups play an extremely important role. 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.

C++ 110

C++ Servers Storage Speed 110

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. The gist of it: create multiple data files that are sized the same, with the same auto-growth settings, enable trace flag 1118 (and maybe 1117), and reduce your tempdb use.

Servers 95

Servers C++ Testing Systems 95

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

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. for lib in $(psql -qtA pgbench -c"select extname||'.so'

C++ 84

C++ Open Source Database Programming 84

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++ 88

C++ Monitoring Database Open Source 88

High Scalability

SEPTEMBER 3, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker.

Open Source 55

Open Source Cache C++ Database 55

Percona

FEBRUARY 16, 2023

Recently, one of our clients was considering encrypting their data at rest using the Percona file-based keyring plugin. So even if someone gets host access, the data files are still protected because they do not have access to the master key used to encrypt the keys for the tables running Encryption at Rest. Let me show you why.

Database 121

Database Servers Engineering Testing 121

Dynatrace

JULY 12, 2022

Ultimately, this IT automation helps organizations garner real-time data for precise troubleshooting, robust application performance, and solid customer experience. These data insights became critical for Park ‘N Fly as it moved infrastructure to the cloud; IT resources became more dynamic and less visible.

Innovation 219

Innovation Infrastructure DevOps Azure 219

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. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Dynatrace

MAY 6, 2020

Readers who share our privacy concerns, please note, all the data we monitor is publicly available. . The insights in this b log rely heavily on data captured by Dynatrace’s proactive synthetic monitoring capabilities. A deeper investigation into industry-specific data reveals several interesting findings. . seconds to 2.78

Website 215

Website Monitoring Retail Media 215

Percona

NOVEMBER 9, 2023

With this data, we’ll be able to better understand and tune our Postgres servers. The first step is to include a new query that will gather data on WAL usage because this is not yet collected by default on the latest version of PMM. PMM already collects the configurations, so we will only miss data from the graphs.

Monitoring 94

Monitoring Tuning Metrics Servers 94

Percona

AUGUST 31, 2018

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters. shared_buffer.

Tuning 58

Tuning Database Performance Benchmarking 58

SQL Performance

MAY 11, 2022

Similarly, what if other elements in the query besides window functions also require arranging input data as ordered in the plan, such as a presentation ORDER BY clause? These can result in different parts of the plan needing to process the input data in different orders. In my examples, I’ll use the sample database PerformanceV5.

C++ 133

C++ Database Servers Code 133

SQL Performance

JUNE 10, 2020

Recall from Part 1 the physical data independence principle of relational theory. In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. The physical treatment in other database platforms can be quite different.

C++ 109

C++ Database Servers Code 109

HammerDB

MARCH 25, 2023

Docker build, example CLI scripts were added to build and run the TPROC-C workload in the Tcl language. these were enhanced to also add Python based scripts, and to include scripts for both TPROC-C and TPROC-H and a driver script for Linux environments. With the HammerDB v4.5 In HammerDB v4.6 With HammerDB v4.7

C++ 83

C++ Virtualization Benchmarking Database 83

Percona

DECEMBER 5, 2022

The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL.

Open Source 70

Open Source C++ Servers Database 70

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. Sample Data. To test the performance of the solutions, you’ll need a larger set of sample data. L0 AS ( SELECT 1 AS c. So you have to come up with a supported alternative.

C++ 112

C++ Code Azure Database 112

Percona

MARCH 24, 2023

You might want to use binlog compression with MySQL/ Percona Server for MySQL , but it can come with drawbacks. 000053', MASTER_LOG_POS=274; START SLAVE; But you have an error: #GTID replication Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Cannot replicate because the master purged required binary logs.

Open Source 89

Open Source Database C++ Servers 89

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

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?! virtual = 2.2G

Cache 104

Cache Database Virtualization Servers 104

SQL Performance

JUNE 10, 2020

Recall from Part 1 the physical data independence principle of relational theory. In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. The physical treatment in other database platforms can be quite different.

C++ 93

C++ Database Servers Code 93

SQL Performance

OCTOBER 9, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. The EOMONTH function was introduced in SQL Server 2012. One to replace periods with a neutral character that you know that cannot normally appear in the data (say, ~).

C++ 111

C++ Database Servers Code 111

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

Percona

APRIL 17, 2023

Still, as DBA, you want to use Percona Monitoring and Management (PMM) for better database insights and maintain a common policy of Datadog as a standard alerting or high-level observability tool. We’ll use here “up” metrics for different databases to reflect database status. 1 Complete! openmetrics.d/conf.yaml

Monitoring 73

Monitoring Metrics Database Open Source 73

HammerDB

DECEMBER 1, 2022

In particular, after a running a test it would be ideal to have a repository where we could verify the configuration of the workload that was run, the results and any timing or transaction count data generated to bring all the log output into a central location. For example on Windows an example of opening a new database. HammerDB v4.6

Virtualization 57

Virtualization C++ Storage Database 57

HammerDB

OCTOBER 17, 2018

For a really quick answer create a schema with 250-500 warehouses per server CPU socket for more details size as follows. . 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.

C++ 40

C++ Testing Virtualization Cache 40