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.
https://shatteredsilicon.net/wp-content/uploads/2020/09/ssl.jpg500500Gordan Bobichttps://shatteredsilicon.net/wp-content/uploads/2021/06/Shattered-Silicon-Logo-Landscape-300x37.pngGordan Bobic2021-06-24 17:02:212023-05-24 09:10:21MariaDB / MySQL Performance Tuning and Optimization: Sub-SELECTs are Evil
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.
https://shatteredsilicon.net/wp-content/uploads/2020/09/ssl.jpg500500Gordan Bobichttps://shatteredsilicon.net/wp-content/uploads/2021/06/Shattered-Silicon-Logo-Landscape-300x37.pngGordan Bobic2021-06-24 16:32:232023-05-24 09:13:34MariaDB / MySQL Performance Tuning and Optimization: Best Practices for Writing High Performance SQL 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.
https://shatteredsilicon.net/wp-content/uploads/2020/09/ssl.jpg500500Gordan Bobichttps://shatteredsilicon.net/wp-content/uploads/2021/06/Shattered-Silicon-Logo-Landscape-300x37.pngGordan Bobic2021-06-23 17:45:262023-05-24 09:16:19MariaDB / MySQL Performance Tuning and Optimization: Avoiding ORs in Queries
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.
https://shatteredsilicon.net/wp-content/uploads/2020/09/ssl.jpg500500Gordan Bobichttps://shatteredsilicon.net/wp-content/uploads/2021/06/Shattered-Silicon-Logo-Landscape-300x37.pngGordan Bobic2020-06-05 20:21:212023-05-24 09:30:37MariaDB / MySQL on ZFS
We use cookies to optimize our website and our service.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
MariaDB / MySQL Performance Tuning and Optimization: Sub-SELECTs are Evil
by Gordan BobicMost 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 Queries
by Gordan BobicIn 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 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 Bobic