DBAs’ Inconceivable Tales: Mystery of the Freezing MariaDB Database

by

How our MariaDB / MySQL Support engineers resolved a mysterious problem of MariaDB freezing every few hours for no apparent reason.

Read more

SSM 8.8.1.17.5.3 Released

by

New Shattered Silicon Monitoring (SSM) 8.8.1.17.5.3 release is now available with additional features and fixes

Read more

MySQL Parallel Replication Pitfalls: Group Commit Sync Delay

by

MySQL parallel replication is a useful feature, but there are some pitfalls to watch out for. Getting it wrong can cripple performance.

Read more

SSM – PMM 1.x Fork with Additional Features

by

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.

Read more

MySQL / MariaDB: Waiting for table flush

by

Troubleshooting performance degradation caused by pileup of queries stuck in “Waiting for table flush” state in MySQL and MariaDB.

Read more

MySQL / MariaDB: Waiting for query cache lock

by

Troubleshooting performance degradation caused by pileup of queries stuck in “Waiting for query cache lock” state in MySQL and MariaDB.

Read more

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
Read more

MariaDB Performance Tuning and MySQL Performance Tuning

by

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.

Read more

MariaDB and MySQL DROP / TRUNCATE Lock / Stall Bug, Mitigations and Workarounds

by

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.

Read more

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

by

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

Read more