SSM is a fork of PMM 1.x with additional features, updates and fixes. Notable new features in the initial release include QAN query harvesting via slow log in RDS, manual node cleanup functionality, and ARM64 builds.
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:092023-05-24 09:05:03MariaDB and MySQL DROP / TRUNCATE Lock / Stall Bug, Mitigations and Workarounds
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.
DBAs’ Inconceivable Tales: Mystery of the Freezing MariaDB Database
by Gordan BobicHow our MariaDB / MySQL Support engineers resolved a mysterious problem of MariaDB freezing every few hours for no apparent reason.
SSM 8.8.1.17.5.3 Released
by Gordan BobicNew Shattered Silicon Monitoring (SSM) 8.8.1.17.5.3 release is now available with additional features and fixes
MySQL Parallel Replication Pitfalls: Group Commit Sync Delay
by Gordan BobicMySQL parallel replication is a useful feature, but there are some pitfalls to watch out for. Getting it wrong can cripple performance.
MariaDB / MySQL Performance Tuning
by Charlotte RuddickMariaDB and MySQL performance tuning, theory and primer.
SSM – PMM 1.x Fork with Additional Features
by Gordan BobicSSM is a fork of PMM 1.x with additional features, updates and fixes. Notable new features in the initial release include QAN query harvesting via slow log in RDS, manual node cleanup functionality, and ARM64 builds.
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 BobicMariaDB Performance Tuning and MySQL Performance Tuning
by Gordan BobicA 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.