2016, Servers and Software - Technology Performance Pulse

Use Physical Backups With MySQL InnoDB Redo Log Archiving

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

C++ Servers Storage Speed

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.

Open Source

Open Source Servers Storage Scalability

bpftrace (DTrace 2.0) for Linux 2018

Brendan Gregg

OCTOBER 8, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. Attaching 2 probes. ^C bcc is powerful but laborious to program. eBPF does more.

C++

C++ Virtualization Programming Latency

SQL Server on Linux: ELF and PE Images Just Work

SQL Server According to Bob

JANUARY 5, 2017

Last March I moved from 22 years in SQL Server support to the SQL Server development team, working on SQL Server on Linux project and reporting to Slava Oks. As Slava highlights in his recent blog post , he also contacted me in early 2015 to assist with supportability of SQL Server on Linux. There are no burning secrets.

Servers

Servers Operating System C++ Software Engineering

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

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers

Servers Azure Engineering Java

bpftrace (DTrace 2.0) for Linux 2018

Brendan Gregg

OCTOBER 7, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. Attaching 2 probes. ^C bcc is powerful but laborious to program. eBPF does more.

C++

C++ Virtualization Programming Latency

Create Table – Disk vs In-Memory Optimized

SQL Server According to Bob

AUGUST 23, 2016

The creation of the XTP, common access DLL requires SQL Server to generate C code, invoke the C compiler and save the DLL into the XTP directory. Bob Dorr – Principal Software Engineer SQL Server. These are additional steps that a disk based table does not perform.

C++

C++ Software Engineering Servers Code

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? 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. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming

Programming Servers Database Hardware

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

Solaris to Linux Migration 2017

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. Hit Ctrl-C to end. ^C C operation = 'read' usecs : count distribution 0 -> 1 : 0 | | 2 -> 3 : 0 | | 4 -> 7 : 4479 | *| 8 -> 15 : 1028 | | 16 -> 31 : 14 | | 32 -> 63 : 1 | | [.]. Oracle VM Server is based on Xen. amazon").

Virtualization

Virtualization AWS Engineering Hardware

How To Choose A Headless CMS

Smashing Magazine

JULY 6, 2021

With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. The CMS itself is provided on a Software-as-a-Service (SaaS) model which I like to term Content-as-as-Service (CaaS). Omnichannel.

Cache

Cache Website Mobile Google

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

Smashing Magazine

OCTOBER 26, 2018

However, being an easy-to-use inclusive and versatile piece of software, WordPress comes with a plethora of options that are not necessarily utilized in each and every project. on December 6th, 2016. For example, simple presentational sites or sites that use WordPress as a backend are the main candidates for the decoupled approach.

Cache

Cache Website Speed Database

A Management Maturity Model for Performance

Alex Russell

MAY 9, 2022

No other aspect of modern software is as poorly managed in otherwise functional engineering organisations. This blindspot usually extends up to the C-suite. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016. This is why server issues reliably get fixed, but JavaScript bloat has continued unabated for a decade.

Performance

Performance Latency Metrics Engineering

Technology Performance Pulse

Use Physical Backups With MySQL InnoDB Redo Log Archiving

MariaDB vs MySQL: Key Differences and Use Cases

Trending Sources

bpftrace (DTrace 2.0) for Linux 2018

SQL Server on Linux: ELF and PE Images Just Work

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

bpftrace (DTrace 2.0) for Linux 2018

Create Table – Disk vs In-Memory Optimized

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

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

Which is the Best MongoDB GUI? — 2019 Update

Solaris to Linux Migration 2017

How To Choose A Headless CMS

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

A Management Maturity Model for Performance

Stay Connected