by Stephane Combaudon | Apr 28, 2015 | Insight for DBAs, MySQL, Percona Software
I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not...
by Stephane Combaudon | Apr 27, 2015 | Insight for DBAs, MySQL
I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize various kinds of single-table...
by Tom Diederich | Apr 24, 2015 | MySQL, Percona Events, Percona Live
With highlights that included news of Percona’s acquisition of Tokutek, a lively keynote discussion with Apple legend Steve “Woz” Wozniak, scores of technical sessions, tutorials and a festive MySQL community dinner and game night, last week’s...
by Peter Zaitsev | Apr 21, 2015 | Insight for DBAs, MySQL, Webinars
MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic. As such, I’m hosting a live webinar tomorrow...
by Jervin Real | Apr 16, 2015 | MySQL
When optimizing queries and investigating performance issues, MySQL comes with built in support for profiling queries aka SET profiling = 1; . This is already awesome and simple to use, but why the PERFORMANCE_SCHEMA alternative? Because profiling will be removed soon...
by Miguel Angel Nieto | Apr 15, 2015 | MySQL
Data inconsistencies in replication environments are a pretty common. There are lots of posts that explain how to fix those using pt-table-checksum and pt-table-sync. Usually we only care about the data but from time to time we receive this question in support: How...
by Peter Zaitsev | Apr 14, 2015 | MySQL
It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability...
by Craig Clark | Apr 14, 2015 | MySQL, Percona Live
If you haven’t already heard, on the Tuesday morning of the 2015 Percona Live MySQL Conference and Expo it was announced that Tokutek is now part of the Percona family. This means TokuDB® for MySQL, and TokuMX™ for MongoDB are Percona products now; and that the...
by Peter Zaitsev | Apr 14, 2015 | MySQL
It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability...
by Hrvoje Matijakovic | Apr 14, 2015 | MySQL, Percona Events, Percona Software
Percona is pleased to announce the availability of Percona Toolkit 2.2.14. Released April 14, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to...
by Fernando Laudares Camargos | Apr 13, 2015 | Insight for DBAs, MySQL, Percona Live, Percona Software
I’ve started my long journey from Florianópolis, Brazil, to Santa Clara, California and I type this words while waiting for a connection flight. Next Wednesday, Daniel Guzmán Burgos and I will be presenting in the Percona Live MySQL Conference and Expo (PLMCE)....
by Jervin Real | Apr 10, 2015 | Benchmarks, MySQL, Percona Software
A few years back Deva wrote about how to use tcpdump on very busy hosts. That post sparked my interest about exploring how to measure the impact of tcpdump on very busy hosts. In this post, I wanted to highlight how much of an impact there really is and what options...
by Nilnandan Joshi | Apr 9, 2015 | MySQL, Percona Live
Recently, I was working on one of the issue related to locks and deadlocks with InnoDB tables and I found very interesting details about how InnoDB locks and deadlocks works with or without index for different Isolation levels. Here, I would like to describe a small...
by Roel Van de Paar | Apr 9, 2015 | Insight for DBAs, Insight for Developers, MySQL
After we released pquery to the community, and as we started logging bug reports with pquery testcases, it quickly became clear that pquery binaries with statically compiled-in client libraries would be of great convenience, both for ourselves and for the community....
by Matt Griffin | Apr 8, 2015 | Insight for DBAs, MySQL, Percona Live, Percona Software
In April and May, Percona will hold and participate in two OpenStack events: OpenStack Summit. Join our talks at these events in Santa Clara and Vancouver for new insights into the MySQL operations of the core of OpenStack as well as the latest information on MySQL...
by Valerii Kravchuk | Apr 7, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona Services
Two years ago Ovais Tariq had explained in detail what kinds of problems existed before MySQL introduced metadata locks in 5.5.3 and how these locks help to prevent them. Still, some implications of metadata locking in MySQL remain unclear for users – DBAs and...
by Matt Yonkovit | Apr 6, 2015 | MySQL, Percona Services
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 direct and indirect costs...
by Michael Coburn | Apr 3, 2015 | MySQL
On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to over 1 billion rows. The table is INSERT-only (no UPDATEs or DELETEs), and...
by Peter Zaitsev | Apr 2, 2015 | MySQL, Percona Services
Years ago when I worked for the MySQL Support organization at the original MySQL AB, we spoke about MySQL Support as insurance and focused on a value proposition similar to that of car insurance. For your car to be fully covered, you must purchase car insurance before...
by Stephane Combaudon | Apr 1, 2015 | MySQL
Recently Todd Farmer shared an interesting story about the mysql command line prompt in MySQL 5.7: how it was changed to provide more context and why the change was finally reverted. This made me think that after using the command line client for MongoDB for awhile, I...
