Our MySQL support engineers encountered a rather unusual cause of replication lag. We covered the most common causes of replication lag in our previous article about MySQL parallel replication. In this particular case, the root cause was more strange. The servers were very high spec with NVMe disks and 10Gbit Ethernet. Analysis showed that the […] The post DBAs’ Inconceivable Tales: A Rare Cause of Replication Lag appeared first on Shattered Silicon ..read more

Troubleshooting performance degradation caused by pileup of queries stuck in "Waiting for query cache lock" state in MySQL and MariaDB. The post MySQL / MariaDB: Waiting for query cache lock appeared first on Shattered Silicon ..read more

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. The post MariaDB Performance Tuning and MySQL Performance Tuning appeared first on Shattered Silicon ..read more

How our MariaDB / MySQL Support engineers resolved a mysterious problem of MariaDB freezing every few hours for no apparent reason. The post DBAs’ Inconceivable Tales: Mystery of the Freezing MariaDB Database appeared first on Shattered Silicon ..read more

New Shattered Silicon Monitoring (SSM) 8.8.1.17.5.3 release is now available with additional features and fixes The post SSM 8.8.1.17.5.3 Released appeared first on Shattered Silicon ..read more

MySQL parallel replication is a useful feature, but there are some pitfalls to watch out for. Getting it wrong can cripple performance. The post MySQL Parallel Replication Pitfalls: Group Commit Sync Delay appeared first on Shattered Silicon ..read more

MariaDB and MySQL performance tuning, theory and primer. The post MariaDB / MySQL Performance Tuning appeared first on Shattered Silicon ..read more

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. The post SSM – PMM 1.x Fork with Additional Features appeared first on Shattered Silicon ..read more

The post 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; appeared first on Shattered Silicon ..read more

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. The post MariaDB and MySQL DROP / TRUNCATE Lock / Stall Bug, Mitigations and Workarounds appeared first on Shattered Silicon ..read more