System Analysis and Configuration
Performance Tuning and Optimisation
High Availability Solutions
Distaster Recovery Solutions
Email: [email protected]
Tel:+44 7740 195136
MariaDB / MySQL Performance Tuning and Optimization: Sub-SELECTs are Evilby Gordan Bobic
Most DBAs know that sub-selects are typically bad for performance, but this example we encountered in the wild illustrates very well just how bad for performance sub-selects can be.
MariaDB / MySQL Performance Tuning and Optimization: Best Practices for Writing High Performance SQL Queriesby Gordan Bobic
In this article we discuss a list of best practices to help you write queries that perform well and avoid writing queries that end up being unoptimizable.
MariaDB / MySQL Performance Tuning and Optimization: Avoiding ORs in Queriesby Gordan Bobic
ORs in SQL queries are bad for performance. Here we describe a technique for doing away with the ORs to improve performance while still retaining functional equivalence of the query.
How to Reduce RDS Costs on AWSby Jonathan Levin
AWS, and RDS in particular, can be very expensive. In this article we discuss techniques that can be used to reduce costs without compromising performance.
PMM Missing Disk Stats Fix with Kernels 4.19+by Gordan Bobic
PMM fix for missing disk stats/metrics on newer kernels.
Virtualization Performance Impact – Part 3 – Zen2 EPYC and CPU Flaw Mitigationsby Gordan Bobic
Virtualization Performance Overheads – Part 2 – Nehalem and Sandy Bridgeby Gordan Bobic
PMM Client on Raspberry Pi (or Anything Else, PMM Client from Source)by Gordan Bobic
MySQL / MariaDB InnoDB and File System Alignmentby Gordan Bobic
MariaDB / MySQL on ZFSby Gordan Bobic