SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 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.

Servers 145

Servers C++ Code Database 145

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

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

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. About YCSB.

Benchmarking 308

Benchmarking Latency C++ Database 308

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

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

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. Percona XtraBackup 8.1

C++ 95

C++ Open Source Servers Database 95

Percona

APRIL 3, 2023

SET WITHOUT OIDS; A list of tables with the problem is in the file: tables_with_oids.txt Failure, exiting postgres@xx.xx.xx.xx:~$ more tables_with_oids.txt In database: abs_test public.craft public.ports In database: postgres public.oid_test We can use the below SQL to find tables with OID, and it also generates the DDL to remove.

C++ 104

C++ Database Cache Storage 104

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

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 106

Servers C++ Storage Systems 106

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

C++ Virtualization Benchmarking Database 101

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

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. When the server receives a request for an action (post, like etc.) High Level Design. Architecture.

Design 334

Design Media Storage Logistics 334

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. Java #Python #C Click To Tweet.

Strategy 182

Strategy Cloud Java Open Source 182

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 96

C++ Database Servers Open Source 96

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.

Tuning 57

Tuning Database Performance Benchmarking 57

Scalegrid

JULY 29, 2020

In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting ! PgBouncer defines one pool per user+database combination. PgBouncer allows limiting connections per-pool, per-database, per-user or per-client.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

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

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

C++ Servers Open Source Database 97

Percona

OCTOBER 3, 2023

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. As such, it is generally recommended to disable THP for most database workloads.

Database 90

Database Servers Open Source C++ 90

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

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Also, it is a helpful method for version upgrades since the target database can run on a different (minor or major) PostgreSQL version. and a v15.4.

Database 78

Database Traffic C++ Servers 78

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. 29 will let you set up redo log directory while performing a backup.

C++ 107

C++ Servers Storage Speed 107

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

Highly Scalable

SEPTEMBER 18, 2012

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. Data Placement. System Coordination. Read/Write latency.

Database 213

Database Latency C++ Scalability 213

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. Among the different components of modern software solutions, the database is one of the most critical. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

MAY 8, 2023

In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication. Instead of copying the entire database, logical replication focuses on replicating changes made to individual rows or transactions. 12 Replica1 10.0.0.80

C++ 102

C++ Servers Database Open Source 102

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive. These leaks can quickly deplete the available connection pool, hindering system performance and potentially leading to crashes.

Servers 82

Servers Database C++ Airlines 82

HammerDB

MAY 26, 2022

If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. The database installation must include both the include and lib directories. linux-glibc2.12-x86_64/bin.

C++ 113

C++ Database Open Source Servers 113

Percona

JANUARY 4, 2023

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance schema. I realized that it is important to understand the insights of the performance schema and how we can make effective use of it.

Performance 98

Performance C++ Monitoring Servers 98

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. In case of hardware failure, first, we need to fix the hardware issue or migrate our database to new hardware and then perform a restore, as mentioned below. Perform PITR if we have backup configured with proper archive backup.

Hardware 77

Hardware C++ Database Open Source 77

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

C++ Open Source Database Programming 83

Percona

JUNE 5, 2023

Sooner or later, one must address this issue; otherwise, one can suffer the consequences of handicapping your entire database infrastructure. Let’s now move forward in time: your system has scaled, of course, and this shortcut of using multiple data clusters on a single host has now become a performance bottleneck.

Database 122

Database Open Source Servers C++ 122

HammerDB

JULY 16, 2021

One of the most important concepts in analysing database performance is that of understanding scalability. When a system ‘scales’ it is able to deliver higher levels of performance proportional to the system resources available to it. In this example, we will compare MySQL 5.7.33 and MySQL 8.0.25 and MySQL 8.0.25

Virtualization 57

Virtualization Performance C++ Database 57

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? Why not just create another database on the same instance? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. ln -s /usr/local/Percona-Server-8.0.19-10-Linux.x86_64.ssl101/

Programming 86

Programming Servers Database Hardware 86

Dynatrace

JULY 21, 2020

Although these COBOL applications operate with consistent performance, companies and governments are forced to transform them to new platforms and rewrite them in modern programming languages (like Java) for several reasons. The IMS service flow traverses the IMS SOAP Gateway and different IMS regions, finally hitting a DL/I database.

Java 176

Java Government Database Programming 176