MariaDB's optimistic parallel replication doesn't often make a significant difference over conservative, but in some cases the improvement can be huge. The post MariaDB Replication – slave_parallel_mode Difference appeared first on Shattered Silicon ..read more

Optimising even just one single query on a poorly performing database system can sometimes have a big overall impact. Here we explore a client success story arising from optimising just one query on a client's system. The post Query Optimisation Effect – Before and After appeared first on Shattered Silicon ..read more

How to reduce InnoDB storage costs for MySQL or MariaDB by 4x without major re-architecting of database structures. The post How to Reduce MariaDB / MySQL Storage Costs by 4x appeared first on Shattered Silicon ..read more

How to tune out furious flushing of the redo log and sawtooth pattern checkpoint age on MariaDB 10.5+ and achieve smooth performance. The post Tuning Out MariaDB’s Furious Flushing in 10.5+ appeared first on Shattered Silicon ..read more

One of our MySQL support engineers encountered a peculiar problem during work on a data migration for a client that was moving their membership survey system from MariaDB 10.3 to MySQL 8. A query that returned data in 5ms on MariaDB 10.3 was going away for minutes on MySQL 8. The query itself didn’t look […] The post DBA’s Inconceivable Tales: The Optimizer Anomaly appeared first on Shattered Silicon ..read more

How we fixed replication lag caused by large scale data processing. Excluding intermediate processing tables can make a big difference The post Fixing Replication Lag due to Large Scale Data Processing appeared first on Shattered Silicon ..read more

How to quickly install MariaDB 10.4 on Alma / Rocky / RedHat EL9 The post MariaDB 10.4 on EL9 appeared first on Shattered Silicon ..read more

Significance of MySQL support and consulting services for efficient database management, particularly focusing on optimizing performance, ensuring security, and handling scalability challenges. Rising demand for professional MySQL consulting due to the complexity of managing expanding databases and the scarcity of MySQL expertise. Details of various optimization techniques, capacity planning strategies, and comprehensive DBA services offered by MySQL consultants. Importance of monitoring, alerting, and security measures such as access control and encryption. Discussion of emergency support cha ..read more

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