2016, Database and Servers - Technology Performance Pulse

MongoDB Rollback: How to Minimize Data Loss

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

Database Network Servers Monitoring

Use Physical Backups With MySQL InnoDB Redo Log Archiving

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.

C++

C++ Servers Storage Speed

The DBCC_OBJECT_METADATA Latch

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

C++ Servers Database Code

"0 to 60" : Switching to indirect checkpoints

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions.

C++

C++ Database Servers Storage

The challenge is on! Community call for creating the fastest number series generator

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. Requirements: Implement your solution as an inline table-valued function (iTVF) named dbo.GetNumsYourName with parameters @low AS BIGINT and @high AS BIGINT. As an example, see the ones I submit at the end of this article. You can add hints as needed.

C++

C++ Servers Testing Processing

MariaDB vs MySQL: Key Differences and Use Cases

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

Open Source Servers Storage Scalability

The challenge is on! Community call for creating the fastest number series generator

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. Requirements: Implement your solution as an inline table-valued function (iTVF) named dbo.GetNumsYourName with parameters @low AS BIGINT and @high AS BIGINT. As an example, see the ones I submit at the end of this article. You can add hints as needed.

C++

C++ Servers Testing Processing

Analyzing "death by a thousand cuts" workloads

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). In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it.

C++

C++ Database Servers Tuning

The ANY Aggregate is Broken

SQL Performance

JULY 1, 2019

The results are technically non-deterministic since SQL Server could validly return any one of the rows in each group. Nevertheless, if you run this query yourself, you are quite likely to see the same result I do: The execution plan depends on the version of SQL Server used, and does not depend on database compatibility level.

C++

C++ Servers Database Performance

SQL Mysteries: SQL Server Login Timeouts – A Debugging Story

SQL Server According to Bob

FEBRUARY 10, 2019

. · Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM. Here is an example of a valid SQL Server login. – sqlclr.

Servers

Servers Network Database Systems

Row Pattern Recognition in SQL

SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. 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. LAST ( C. NULL NULL 151.00

C++

C++ Virtualization Servers Code

How It Works: SQL Server DTC (MSDTC and XA Transactions)

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). Once the connection to SQL Server is established the APP executes the odbc! Microsoft specific implementation for DTC using (OLE-TX).

Servers

Servers Azure Engineering Java

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting. ( SELECT *.

C++

C++ Servers Code Efficiency

SQL Server On Linux: Forced Unit Access (Fua) Internals

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. “. The Back Story.

Servers

Servers Media Cache Storage

How To Use systemd in Linux to Configure and Manage Multiple MySQL Instances

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

Programming Servers Database Hardware

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting. ( SELECT *.

C++

C++ Servers Code Efficiency

Please help with STRING_SPLIT improvements

SQL Performance

MARCH 20, 2020

We're mid-cycle between releases, where we're not yet hearing about any of the features planned for SQL Server vNext. In SQL Server 2016, STRING_SPLIT solved a long-missing gap in a language that, admittedly, was not intended for complicated string processing. And that is what I want to bring up today.

Database

Database Servers C++ AWS

Which is the Best MongoDB GUI? — 2019 Update

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Should have an excellent way to measure server and query performance. Import data from RDBMS like MySQL, PostgreSQL, and SQL Server.

Database

Database Servers Monitoring Availability

Using Parallel Query with Amazon Aurora for MySQL

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, 84.1 | | version_comment | Percona Server (GPL), Release 84.1, AWS Aurora (based on MySQL 5.6) MySQL on ec2. MySQL on ec2.

Cache

Cache C++ AWS Airlines

Split strings the right way – or the next best way

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1.

C++

C++ Servers Testing Database

Headless WordPress: The Ups And Downs Of Creating A Decoupled WordPress

Smashing Magazine

OCTOBER 26, 2018

When it comes down to how WordPress is programmed, one thing is certain: it doesn’t follow the M odel- V iew- C ontroller (MVC) design pattern that many developers are familiar with. on December 6th, 2016. This will be run on the save_post hook and will overwrite the transient in the database with the JSON data of our post.

Cache

Cache Website Speed Database

Introducing The Component-Based API

Smashing Magazine

JANUARY 21, 2019

An API is the communication channel for an application to load data from the server. This relationship can be expressed through an associative array (an array of key => property) on the server-side, in which each module states its name as the key attribute and its inner modules under the property modules. Large preview ).

Social Media

Social Media Database Media Website

A Management Maturity Model for Performance

Alex Russell

MAY 9, 2022

This blindspot usually extends up to the C-suite. Teams achieving this level of discipline about performance begin to eliminate variance from their lab data by running tests in "less noisy" environments than somewhere like a developer's laptop, a shared server, or a VM with underlying system variance.

Performance

Performance Latency Metrics Engineering

Should You Use ClickHouse as a Main Operational Database?

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Processed 4.15

Database

Database Analytics Blockchain Healthcare

Technology Performance Pulse

MongoDB Rollback: How to Minimize Data Loss

Use Physical Backups With MySQL InnoDB Redo Log Archiving

Trending Sources

The DBCC_OBJECT_METADATA Latch

"0 to 60" : Switching to indirect checkpoints

The challenge is on! Community call for creating the fastest number series generator

MariaDB vs MySQL: Key Differences and Use Cases

The challenge is on! Community call for creating the fastest number series generator

Analyzing "death by a thousand cuts" workloads

The ANY Aggregate is Broken

SQL Mysteries: SQL Server Login Timeouts – A Debugging Story

Row Pattern Recognition in SQL

How It Works: SQL Server DTC (MSDTC and XA Transactions)

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

SQL Server On Linux: Forced Unit Access (Fua) Internals

How To Use systemd in Linux to Configure and Manage Multiple MySQL Instances

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

Please help with STRING_SPLIT improvements

Which is the Best MongoDB GUI? — 2019 Update

Using Parallel Query with Amazon Aurora for MySQL

Split strings the right way – or the next best way

Headless WordPress: The Ups And Downs Of Creating A Decoupled WordPress

Introducing The Component-Based API

A Management Maturity Model for Performance

Should You Use ClickHouse as a Main Operational Database?

Stay Connected