Ive started my long journey from Florian'opolis, Brazil, to Santa Clara, California and I type this words while waiting for a connection flight. Next Wednesday, Daniel Guzm'an Burgos and I will be presenting in the Percona Live MySQL Conference and Expo (PLMCE). Im so excited with the new MySQL 101 program that has been added [&]

The post Staying ahead of MySQL operational problems at Percona Live appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/13/staying-ahead-of-mysql-operational-problems-at-percona-live/

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 you have to make the [&]

The post Measuring the impact of tcpdump on Very Busy Hosts appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/10/measuring-impact-tcpdump-busy-hosts/

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 test case about how SELECT ..FOR UPDATE (with and without limit) behave [&]

The post InnoDB locks and deadlocks with or without index for different isolation level appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/09/innodb-locks-deadlocks-without-index-different-isolation-level/

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. (If you havent heard about pquery yet, read the pquery introduction blog post, come and [&]

The post pquery binaries with statically included client libs now available! appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/09/pquery-binaries-with-statically-included-client-libs-now-available/

In April and May, Percona will hold and participate in two OpenStack events: OpenStack Live and the 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 guest instances. Next week (April [&]

The post More on OpenStack Live and our talks at OpenStack Summit Vancouver appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/08/more-on-openstack-live-and-our-talks-at-openstack-summit-vancouver/

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 even software developers that target recent MySQL versions. Ive decided to [&]

The post More on (transactional) MySQL metadata locks appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/07/more-on-transactional-mysql-metadata-locks/

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 associated with allowing these unhealthy systems to continue to exist. Let’s look at some. The setup: [&]

The post The cost of not properly managing your databases appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/06/cost-not-properly-managing-databases/

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 the bulk of their retrieval are PK [&]

The post Illustrating Primary Key models in InnoDB and their impact on disk usage appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/03/illustrating-primary-key-models-in-innodb-and-their-impact-on-disk-usage/

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 the incident happens  in fact most places [&]

The post The value of MySQL Support appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/02/the-value-of-mysql-support/

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 would love seeing a much more modern mysql [&]

The post MySQL shell prompt vs MongoDB shell prompt appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/01/mysql-shell-prompt-vs-mongodb-shell-prompt/

Percona is glad to announce the release of Percona XtraBackup 2.2.10 on March 31, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered [&]

The post Percona XtraBackup 2.2.10 for MySQL hot backups is now available (free!) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/31/percona-xtrabackup-2-2-10-is-now-available/

Percona is glad to announce the new release of Percona XtraDB Cluster 5.5 on March 30th 2015. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.5.41-37.0 including all the bug fixes in it, Galera Replicator 2.11, and on Codership wsrep API 25.11, Percona XtraDB Cluster 5.5.41-25.11 is now [&]

The post Percona XtraDB Cluster 5.5.41-25.11 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/30/percona-xtradb-cluster-5-5-41-25-11-is-now-available/

Heres your chance to get on stage with Woz! Sort of. Apple co-founder and Silicon Valley icon and philanthropist Steve Wozniak will participate in a moderated Q&A on creativity and innovation April 14 during the Percona Live MySQL Conference and Expo in Santa Clara, California. Woz once said that he never intended to change the world. [&]

The post Woz on your mind? Share your questions for Steve Wozniak during his Percona Live keynote! appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/27/woz-on-your-mind-share-your-questions-for-steve-wozniak-during-his-percona-live-keynote/

TechCrunch reported yesterday that Apple has acquired FoundationDB. And while I didnt see any mention if this news on the FoundationDB website, they do have an announcement saying: We have made the decision to evolve our company mission and, as of today, we will no longer offer downloads. This is an unfortunate development  I [&]

The post FoundationDB is acquired by Apple: My thoughts appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/27/foundationdb-is-acquired-by-apple-my-thoughts/

Founded in 2004 to help people find great local businesses, Yelp has some 135 million monthly unique visitors. With those traffic volumes Yelps 300+ engineers are constantly working to keep things moving smoothly – and when you move that fast you learn many things. Fortunately for the global MySQL community, three Yelp DBAs will be [&]

The post Yelp IT! A talk with 3 Yelp MySQL DBAs on Percona Live & more appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/25/yelp-it-a-talk-with-3-yelp-mysql-dbas-heading-to-percona-live-2015/

Percona Toolkit is one of our most mature open source applications. Derived from Maatkit and Aspersa, Percona Toolkit has evolved significantly over the years. The software now contains 32 tools, over 4,000 tests, and has been downloaded over 250,000 times. Anyone who manages a database  from DBAs to system administrators to even software developers [&]

The post Calling all MySQL DBAs: How do you use Percona Toolkit? appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/24/calling-all-mysql-dbas-how-do-you-use-percona-toolkit/

MongoDB 3.0 was recently released. Instead of focusing on whats new  that is so easy to find, lets rather talk about something that has not changed a lot since the early MongoDB days. This topic is sharding and most specifically: how to choose a good sharding key. Note that most of the discussion will also [&]

The post Choosing a good sharding key in MongoDB (and MySQL) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/19/choosing-a-good-sharding-key-in-mongodb-and-mysql/

So you want to contribute to OpenStack? I can help! For the last year or so I have been involved with OpenStack and more specifically the Trove (DBaaS) project as sort of an ambassador for Percona, contributing bits of knowledge, help and debugging wherever I could and thought I would share some of my experience [&]

The post Getting started guide for OpenStack contributors appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/18/getting-started-guide-for-openstack-contributors/

MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun This episode consists of 13 parts, and an introduction. See videos below In HD quality (set your player to 720p!) Introduction Part 1: echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname, date, time, cat, mkdir Part 2: find, wc, sort, [&]

The post MySQL QA Episode 1: Bash/GNU Tools & Linux Upskill & Scripting Fun appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/17/mysql-qa-linux-upskill-bash-gnu-tools-scripting-fun/

Welcome to the MySQL QA Training Series! If you have not read our introductory blog post on pquery yet, Id recommend reading that one first to get a bit of background. The community is enthuastic about pquery, and today I am happy to announce a full training series on pquery and more. Whether you are [&]

The post Free MySQL QA & Bash/Linux Training Series appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/17/free-mysql-qa-and-bash-linux-training-series/