Planet MariaDB Server

DTrace Basics and Tracing Every MariaDB Server Function Call

In my previous post I’ve explained how to build MariaDB Server 10.8 from GitHub source on macOS. This kind of (totally unsupported by both MariaDB Corporation and Foundation) build may…

Blog of (former?) MySQL Entomologist 2022-01-30

DTrace Basics and Tracing Every MariaDB Server Function Call

In my previous post I’ve explained how to build MariaDB Server 10.8 from GitHub source on macOS. This kind of (totally unsupported by both MariaDB Corporation and Foundation) build may…

Blog of (former?) MySQL Entomologist 2022-01-30

First steps with MariaDB Server and DTrace on macOS

FOSDEM 2022 is going to happen on the next weekend and I am still missing blog posts supporting my unusual upcoming talk there, this time devoted to building and using…

Blog of (former?) MySQL Entomologist 2022-01-27

First steps with MariaDB Server and DTrace on macOS

FOSDEM 2022 is going to happen on the next weekend and I am still missing blog posts supporting my unusual upcoming talk there, this time devoted to building and using…

Blog of (former?) MySQL Entomologist 2022-01-27

5 Steps to Improve Performance of Default MySQL Installation

Let’s say you have a fresh MySQL installation. Are there any possible steps to improve performance right away? Yes, there are! Recently, Marcos Albe (Principal Support Engineer, Percona) did an…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2022-01-27

PMM 2.26.0 Preview Release

PMM 2.26.0 Preview Release Percona Monitoring and Management 2.26.0 is now available as a Preview Release. PMM team really appreciates your feedback! We encourage you to try this PMM Preview…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2022-01-27

iibench (aka the Index Insertion Benchmark) implemented as a sysbench workload

Our team has reimplemented iibench as a sysbench workload. You can read more about it on the project Github page.

MySQL Performance Blog MySQL Performance Blog 2022-01-19

Configuring MySQL Query Metrics

Editors and technical reviewers suggested that I cover how to configure MySQL query metrics in chapter 1 of Efficient MySQL Performance, but I deferred because it was out of scope…

Hack MySQL 2022-01-16

Accessing Complex Structures in MariaDB Server Code in bpftrace Probes – First Steps

I had already written many blog posts about bpftrace. All my public talks devoted to bpftrace included a slide about “problems”, and one of them usually sounded like this:…access to…

Blog of (former?) MySQL Entomologist 2022-01-15

Accessing Complex Structures in MariaDB Server Code in bpftrace Probes – First Steps

I had already written many blog posts about bpftrace. All my public talks devoted to bpftrace included a slide about “problems”, and one of them usually sounded like this:…access to…

Blog of (former?) MySQL Entomologist 2022-01-15

What is a database connection pool?

An explanation of database connection pools and how to use them in Java applications.

Programming Brain 2022-01-14

How to execute SQL queries from Java (and prevent SQL injections)

Instructions on executing SQL queries in Java and preventing SQL injections.

Programming Brain 2022-01-12

How to open and close JDBC connections

Guide on opening and closing JDBC connections in Java.

Programming Brain 2022-01-12

New YouTube channel on programming (mostly Java)

New YouTube channel focused on programming, especially Java.

Programming Brain 2022-01-04

Pedal to the metal or what else can speedup your CPU-bound application?

TL;DR Moving code and data sections to huge pages increases application performance without any source code modification. We are able to get +10%. It’s possible to quickly estimate the effect…

Dmitriy Philimonov MySQL Performance Blog 2021-12-29