You are here

MySQL Performance Blog

MySQL Performance Blog
Checked: 3 years 9 months ago
Updated: 3 years 9 months ago
Update every: 2 hours

Percona's Data performance and scalability blog
Subscribe to MySQL Performance Blog

Illustrating Primary Key models in InnoDB and their impact on disk usage

MySQL Performance Blog - Fri, 03/04/2015 - 10:00am

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 […]

More on (transactional) metadata locks

MySQL Performance Blog - Fri, 03/04/2015 - 4:18am

Two years ago Ovais Tariq had explained in details 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 both users, DBAs and even software developers that target recent MySQL versions. I’ve decided to […]

The value of MySQL Support

MySQL Performance Blog - Thu, 02/04/2015 - 1:00pm

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.

MySQL shell prompt vs MongoDB shell prompt

MySQL Performance Blog - Wed, 01/04/2015 - 7:00am

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.

Percona XtraBackup 2.2.10 for MySQL hot backups is now available (free!)

MySQL Performance Blog - Tue, 31/03/2015 - 3:34pm

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 […]

Percona XtraDB Cluster 5.5.41-25.11 is now available

MySQL Performance Blog - Mon, 30/03/2015 - 4:22pm

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 […]

‘Woz on your mind?’ Share your questions for Steve Wozniak during his Percona Live keynote!

MySQL Performance Blog - Fri, 27/03/2015 - 9:34pm

Here’s 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. […]

FoundationDB is acquired by Apple: My thoughts

MySQL Performance Blog - Fri, 27/03/2015 - 1:00pm

TechCrunch reported yesterday that Apple has acquired FoundationDB. And while I didn’t 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 […]

Yelp IT! A talk with 3 Yelp MySQL DBAs on Percona Live & more

MySQL Performance Blog - Wed, 25/03/2015 - 10:00am

Founded in 2004 to help people find great local businesses, Yelp has some 135 million monthly unique visitors. With those traffic volumes Yelp’s 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 […]

Calling all MySQL DBAs: How do you use Percona Toolkit?

MySQL Performance Blog - Tue, 24/03/2015 - 7:00am

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 […]

Choosing a good sharding key in MongoDB (and MySQL)

MySQL Performance Blog - Thu, 19/03/2015 - 7:00am

MongoDB 3.0 was recently released. Instead of focusing on what’s new – that is so easy to find, let’s 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 […]

Getting started guide for OpenStack contributors

MySQL Performance Blog - Wed, 18/03/2015 - 1:00pm

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 […]

MySQL QA Episode 1: Bash/GNU Tools & Linux Upskill & Scripting Fun

MySQL Performance Blog - Tue, 17/03/2015 - 4:12pm

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, […]

Free MySQL QA & Bash/Linux Training Series

MySQL Performance Blog - Tue, 17/03/2015 - 1:00pm

Welcome to the MySQL QA Training Series! If you have not read our introductory blog post on pquery yet, I’d 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 […]

Deep dive into MySQL’s innochecksum tool

MySQL Performance Blog - Mon, 16/03/2015 - 7:00am

One of our Percona Support customers recently reported that Percona XtraBackup failed with a page corruption error on an InnoDB table. The customer thought it was a problem or bug in the Percona XtraBackup tool. After investigation we found that an InnoDB page was actually corrupted and a Percona XtraBackup tool caught the error as […]

Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7

MySQL Performance Blog - Fri, 13/03/2015 - 3:45pm

My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7″ on February 25 generated several excellent questions following the presentation (available here for playback along with the slides). I didn’t have time to answer many of the questions during the session and so in this post I answer all of them. Thanks to everyone who attended! Q: […]

MySQL and geospatial programming: An introduction to GIS

MySQL Performance Blog - Fri, 13/03/2015 - 10:00am

Geographic information systems (GIS) are used by application developers to incorporate geographic information into their datasets to create apps with cool features such finding the address to the best steakhouse in town or the locations of local points of historical interest (the list is endless). In a nutshell, GIS captures, store, checks and displays data […]

Easy query metrics with MySQL Performance Schema

MySQL Performance Blog - Thu, 12/03/2015 - 7:00am

The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks: Click “Apply” and about two minutes later you’ll have query metrics from Performance Schema, collected and […]

Advanced JSON for MySQL

MySQL Performance Blog - Tue, 10/03/2015 - 10:00am

What is JSON JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use JSON (and the related BSON) for storing and transmitting data. Problems with JSON in MySQL It […]

5 free handy tools for monitoring and managing MySQL replication

MySQL Performance Blog - Mon, 09/03/2015 - 3:50pm

MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication. What is MySQL Replication? It’s the process of copying the (real-time events) data from one master instance to another slave instance and maintaining the redundant consistent data in a different […]

What stopped MySQL? Tracing back signals sent to MySQL

MySQL Performance Blog - Fri, 06/03/2015 - 4:59pm

Have you ever had a case where you needed to find a process which sent a HUP/KILL/TERM or other signal to your database? Let me rephrase. Did you ever have to find which process messed up your night? If so, you might want to read on. I’m going to tell you how you can find […]

The post What stopped MySQL? Tracing back signals sent to MySQL appeared first on MySQL Performance Blog.

How to test if CVE-2015-0204 FREAK SSL security flaw affects you

MySQL Performance Blog - Thu, 05/03/2015 - 4:45pm

The CVE-2015-0204 FREAK SSL vulnerability abuses intentionally weak “EXPORT” ciphers which could be used to perform a transparent Man In The Middle attack. (We seem to be continually bombarded with not only SSL vulnerabilities but the need to name vulnerabilities with increasing odd names.) Is your server vulnerable? This can be tested using the following GIST […]

Steve ‘Woz’ Wozniak to speak at Percona Live MySQL Conference & Expo 2015

MySQL Performance Blog - Thu, 05/03/2015 - 1:00pm

I am thrilled to announce that 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 this year’s Percona Live MySQL Conference and Expo in Santa Clara, California. In addition to “The Woz,” as Steve is nicknamed, we have a great lineup […]

Percona XtraDB Cluster 5.6.22-25.8 is now available

MySQL Performance Blog - Thu, 05/03/2015 - 12:30pm

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on March 5th 2015. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.22-72.0 including all the bug fixes in it, Galera Replicator 3.9, and on Codership wsrep API 25.8, Percona XtraDB Cluster 5.6.21-25.8 is now […]

Percona Server 5.6.23-72.1 is now available

MySQL Performance Blog - Wed, 04/03/2015 - 5:29pm

Percona is glad to announce the release of Percona Server 5.6.23-72.1 on March 4, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.23, including all the bug fixes in it, Percona Server 5.6.23-72.1 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Pages

Subscribe to MySQL Performance Blog