LINUX SERVICES:
Linux Consulting
Linux Support
System Analysis and Configuration
Performance Tuning and Optimisation
High Availability Solutions
Distaster Recovery Solutions
DATABASE SERVICES:
CONTACT US:
Email: [email protected]
Tel:+44 7740 195136
MariaDB / MySQL Performance Tuning and Optimization: Avoiding ORs in Queries
by Gordan BobicORs 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 AWS
by Jonathan LevinAWS, 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 BobicPMM fix for missing disk stats/metrics on newer kernels.
Virtualization Performance Impact – Part 3 – Zen2 EPYC and CPU Flaw Mitigations
by Gordan BobicVirtualization Performance Overheads – Part 2 – Nehalem and Sandy Bridge
by Gordan BobicPMM Client on Raspberry Pi (or Anything Else, PMM Client from Source)
by Gordan BobicMySQL / MariaDB InnoDB and File System Alignment
by Gordan BobicMariaDB / MySQL on ZFS
by Gordan BobicPodcast Relational Databases – Coding with Holger
by Gordan BobicVirtualization Performance – or lack thereof
by Gordan Bobic