If you spend all day every day looking after hundreds of MySQL servers, the chances are that you have encountered this problem. And the chances are that if your servers are configured properly (i.e. you have the same configuration the master and the slaves), the error is almost certainly spurious and doesn’t mean what it […]
A summary of basics of MariaDB and MySQL performance tuning, along with a few more advanced hints and tips. Beyond these, further tuning becomes very workload specific.
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:092022-05-12 16:11:45MariaDB 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:522022-05-12 16:08:15MariaDB / 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-12-21 07:29:22MariaDB / 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
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.
MySQL / MariaDB: Waiting for table flush
by Gordan BobicTroubleshooting performance degradation caused by pileup of queries stuck in “Waiting for table flush” state in MySQL and MariaDB.
MySQL / MariaDB: Waiting for query cache lock
by Gordan BobicTroubleshooting performance degradation caused by pileup of queries stuck in “Waiting for query cache lock” state in MySQL and MariaDB.
MySQL – Fixing: Got fatal error 1236 from master when reading data from binary log: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master;
by Gordan BobicIf you spend all day every day looking after hundreds of MySQL servers, the chances are that you have encountered this problem. And the chances are that if your servers are configured properly (i.e. you have the same configuration the master and the slaves), the error is almost certainly spurious and doesn’t mean what it […]
MariaDB Performance Tuning and MySQL Performance Tuning
by Aaron StapleA summary of basics of MariaDB and MySQL performance tuning, along with a few more advanced hints and tips. Beyond these, further tuning becomes very workload specific.
MariaDB and MySQL DROP / TRUNCATE Lock / Stall Bug, Mitigations and Workarounds
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
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
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
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.