by Peter Zaitsev | Oct 10, 2014 | MySQL, Percona Software
MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it...
by Stephane Combaudon | Sep 29, 2014 | Insight for DBAs, MySQL
MySQL is the database of choice for most OpenStack components (Ceilometer is a notable exception). If you start with a small deployment, it will probably run like a charm. But as soon as the dataset grows, you will suddenly face several challenges. We will write a...
by Tim.Callaghan | Sep 25, 2014 | MySQL
The biggest innovation in TokuDB v7.5 is Read Free Replication (RFR). I blogged a few days ago posting a benchmark showing how much additional throughput can be achieved on a replication slave, while at the same time lowering the read IO operations to almost zero. The...
by Tim.Callaghan | Sep 23, 2014 | MySQL
New to TokuDB® v7.5 is a feature we’re calling “Read Free Replication” (RFR). RFR allows TokuDB replication slaves to process insert, update, and delete statements with almost no read IO. As a result, the slave can easily keep up with the master (no...
by Tim.Callaghan | Sep 18, 2014 | MySQL
Today we released TokuDB® v7.5, the latest version of Tokutek’s storage engine for MySQL and MariaDB. I’ll be publishing two blogs next week to go into more details about our new “Read Free Replication”, but here are high level descriptions of...
by Rich.Prohaska | Aug 6, 2014 | MySQL
Covering indexes can result in orders of magnitude performance improvements for queries. Bradley’s presentation on covering indexes describes what a covering index is, how it can effect performance, and why it works. However, the definition of a covering index...
by Bill Karwin | Jul 17, 2014 | Insight for Developers, MySQL, Webinars
On Wednesday I gave a presentation on “How to Avoid Even More Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and...
by Martin Arrieta | Jul 11, 2014 | Insight for DBAs, MySQL
by Michael Coburn | Jul 2, 2014 | Cloud, Insight for DBAs, MySQL
I recently had an opportunity to migrate a customer from a physical server into Amazon’s RDS environment. In this particular case the customers’ platform makes extensive use of MySQL triggers and views. I came across two significant issues that prevented...
by Zardosht.Kasheff | Jun 13, 2014 | MySQL
In my last post, I gave a technical explanation of the performance characteristics of partitioned collections in TokuMX 1.5 (which is right around the corner) and partitioned tables in relational databases. Given those performance characteristics, in this post, I will...
by Zardosht.Kasheff | Jun 10, 2014 | MySQL
In TokuMX 1.5 that is right around the corner, the big feature will be partitioned collections. This feature is similar to partitioned tables in Oracle, MySQL, SQL Server, and Postgres. A question many have is “why should I use partitioned tables?” In short, it’s...
by Dave Rosenlund | May 9, 2014 | MySQL
Background: If you did not read my first blog post about why I am sharing my thoughts on the benchmarks published by Mark Callaghan on Small Datum you may want to skim through it now for a little context: “Thoughts on Small Datum – Part 1”...
by Dave Rosenlund | May 1, 2014 | MySQL
The title of this post should really be, “Maybe He Should Try Taking a Walk in Your Shoes.” The he I’m referring to is economist and author, Tim Harford. The you is the people who use NewSQL and NoSQL approaches to mine big data with database platforms...
by Dave Rosenlund | Apr 29, 2014 | MySQL
If you did not read my first blog post about Mark Callaghan’s (@markcallaghan) benchmarks as documented in his blog, Small Datum, you may want to skim through it now for a little context. ——————- On March 11th, Mark, a former Google and now Facebook database guru,...
by Daniel Nichter | Apr 23, 2014 | MySQL, Percona Live
I started using MySQL 11 years ago. That’s not too long compared to other people in the industry, but nonetheless here’s my perspective on the state of the MySQL industry after attending Percona Live MySQL Conference & Expo 2104. In short, the...
by Jon Tobin | Apr 21, 2014 | MySQL
Three weeks ago I had the privilege of attending my first Percona Live MySQL conference, which was incredible! In particular, there were two things that I found impressive about the conference. First, was the amount of knowledge sharing and support that MySQL users...
by Dave Rosenlund | Apr 18, 2014 | MySQL
A little background… When I ventured into sales and marketing (I’m an engineer by education) I learned I would often have to interpret and simply summarize the business value that is sometimes hidden in benchmarks. Simply put, the people who approve the purchase...
by Matt Griffin | Apr 16, 2014 | Insight for DBAs, MySQL, Percona Events, Percona Live, Percona Software
To kick off the Percona Live MySQL Conference & Expo 2014, Percona held the first “Open Source Appreciation Day” on Monday, March 31st. Over 210 people registered and the day’s two free events focused on CentOS and OpenStack. The OpenStack Today...
by Zardosht.Kasheff | Apr 15, 2014 | MySQL
As I’ve mentioned in previous posts, TokuMX replication differs quite a bit from MongoDB’s replication. The differences are large enough such that we’ve completely redone some of MongoDB’s existing algorithms. One such area is how secondaries apply oplog data from a...
by Joel.Epstein | Apr 10, 2014 | MySQL
During a typical release cycle for TokuDB at Tokutek, we spend time qualifying and hardening the product using numerous tools. For example, we run stress and unit tests directly on the Fractal Tree indexes, MySQL Test Runner (MTR) tests on the storage engine as well...
