by Vadim Tkachenko | Jan 9, 2014 | Insight for DBAs, MySQL, Percona Software
One of our primary focuses at Percona is performance. Let me make some statements on what is “performance.” In doing so I will refer to two pieces of content: Carry Millsap’s talk “Performance Instrumentation: Beyond What You Do Now” [1]...
by Dave Rosenlund | Jan 8, 2014 | MySQL
MongoDB includes several powerful features like high availability, read scaling, and horizontal scalability in an easy-to-use, schema-free database platform. But, what if you could retain those properties, improve performance, and ensure scalability without...
by Jay Janssen | Jan 8, 2014 | MySQL
Gcache and IST The Gcache is a memory-based cache of recent Galera transactions that is local to each node in a cluster. If a node leaves and rejoins the cluster, it can use the gcache from another node that stayed in the cluster (i.e., its donor node) to fetch the...
by Alexander Rubin | Jan 7, 2014 | MySQL
MySQL and Scaling-up (using more powerful hardware) was always a hot topic. Originally MySQL did not scale well with multiple CPUs; there were times when InnoDB performed poorer with more CPU cores than with fewer CPU cores. MySQL 5.6 can scale significantly better;...
by Przemysław Malkowski | Jan 6, 2014 | Insight for DBAs, MySQL, Percona Services
Sometimes there is a need for keeping large amounts of old, rarely used data without investing too much on expensive storage. Very often such data doesn’t need to be updated anymore, or the intent is to leave it untouched. I sometimes wonder what I should really...
by Miguel Angel Nieto | Jan 2, 2014 | Insight for DBAs, MySQL
MySQL table structures are stored in .frm files and in the InnoDB Data Dictionary. Sometimes, usually in data recovery issues, we need to recover those structures to be able to find the lost data or just to recreate the tables. There are different ways to do it and...
