Emergency

Search Results for: mysql performance and health

Optimizing PXC Xtrabackup State Snapshot Transfer

State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize.  This is analogous to …


The cost of not properly managing your databases

Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both …


Testing backup locks during Xtrabackup SST on Percona XtraDB Cluster

Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH …


What’s new in TokuMX 1.4, Part 2: Partitioned oplog

We just released version 1.4.0 of TokuMX, our high-performance distribution of MongoDB. There are a lot of improvements in this version (release notes), the most of any release yet. In this series of blog posts, …


SwRI Chooses TokuDB to Tackle Machine Data for an 800M+ Record Database

Tackling machine data on the ground to ensure successful operations for NASA in space Issues addressed: Scaling MySQL to multi-terabytes Insertion rates as InnoDB hit a performance wall Schema flexibility to handle an evolving data …


kernel_mutex problem cont. Or triple your throughput

This is to follow up my previous post with kernel_mutex problem. First, I may have an explanation why the performance degrades to significantly and why innodb_sync_spin_loops may fix it. Second, if that is correct ( …