Posts

Shattered Silicon

MariaDB / MySQL Performance Tuning and Optimization: How to Delete Faster on MySQL

DELETE statements can have a disproportionately high impact on performance of a database server. Here we explore techniques for optimizing them.

Shattered Silicon

MariaDB / MySQL Performance Tuning and Optimization: Data Types

Data types matching between the table columns and queries is important – mismatch usually prevents the use of indexes.

Shattered Silicon

MariaDB / MySQL Performance Tuning and Optimization: Sub-SELECTs are Evil

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.

Shattered Silicon

MariaDB / MySQL Performance Tuning and Optimization: Best Practices for Writing High Performance SQL Queries

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.

Shattered Silicon

MariaDB / MySQL Performance Tuning and Optimization: Avoiding ORs in Queries

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.

Shattered Silicon

How to Reduce RDS Costs on AWS

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.