When you DROP or TRUNCATE a table or partition in MySQL and you have a large buffer pool, you may noticed a complete server lock-up or stall of multiple seconds. Mitigation and Workarounds.
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-11-27 11:42:092021-11-27 11:48:38MariaDB and MySQL DROP / TRUNCATE Lock / Stall Bug, Mitigations and Workarounds
https://shatteredsilicon.net/wp-content/uploads/2020/09/ssl.jpg500500Jonathan Levinhttps://shatteredsilicon.net/wp-content/uploads/2021/06/Shattered-Silicon-Logo-Landscape-300x37.pngJonathan Levin2021-07-12 08:38:462021-07-12 08:40:45MariaDB / MySQL Performance Tuning and Optimization: How to Delete Faster on MySQL
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-07-11 12:19:522021-07-11 12:50:16MariaDB / MySQL Performance Tuning and Optimization: Data Types
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:212021-07-11 12:45:35MariaDB / 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:232021-11-27 11:08:35MariaDB / 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:262021-06-29 18:44:20MariaDB / 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.
MariaDB and MySQL DROP / TRUNCATE Lock / Stall Bug, Mitigations and Workarounds
/in Databases (MySQL, MariaDB, PostgreSQL) /by Gordan BobicWhen you DROP or TRUNCATE a table or partition in MySQL and you have a large buffer pool, you may noticed a complete server lock-up or stall of multiple seconds. Mitigation and Workarounds.
MariaDB / MySQL Performance Tuning and Optimization: How to Delete Faster on MySQL
/in Databases (MySQL, MariaDB, PostgreSQL) /by Jonathan LevinDELETE statements can have a disproportionately high impact on performance of a database server. Here we explore techniques for optimizing them.
MariaDB / MySQL Performance Tuning and Optimization: Data Types
/in Databases (MySQL, MariaDB, PostgreSQL) /by Gordan BobicData types matching between the table columns and queries is important – mismatch usually prevents the use of indexes.
MariaDB / MySQL Performance Tuning and Optimization: Sub-SELECTs are Evil
/in Databases (MySQL, MariaDB, PostgreSQL) /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
/in Databases (MySQL, MariaDB, PostgreSQL) /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
/in Databases (MySQL, MariaDB, PostgreSQL) /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
/in Databases (MySQL, MariaDB, PostgreSQL) /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+
/in Databases (MySQL, MariaDB, PostgreSQL) /by Gordan BobicPMM fix for missing disk stats/metrics on newer kernels.
Virtualization Performance Impact – Part 3 – Zen2 EPYC and CPU Flaw Mitigations
/in Systems (Linux, Virtualization) /by Gordan BobicVirtualization Performance Overheads – Part 2 – Nehalem and Sandy Bridge
/1 Comment/in Databases (MySQL, MariaDB, PostgreSQL), Systems (Linux, Virtualization) /by Gordan Bobic