You are here

MySQL Performance Blog

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

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

How Big Can Your Galera Transactions Be

MySQL Performance Blog - Mon, 26/10/2015 - 6:17pm

While we should be aiming for small and fast transactions with Galera, it is always possible at some point you might want a single large transaction, but what is involved? First, this is supposed to be ...

The post How Big Can Your Galera Transactions Be appeared first on MySQL Performance Blog.

State of Percona Server 5.6, MySQL 5.6 and MySQL 5.7 RC

MySQL Performance Blog - Mon, 26/10/2015 - 2:39pm

This week Oracle will release MySQL 5.7 GA, so it’s a perfect time to do a quick review of the current state of Percona Server 5.6.26, MySQL 5.6.26 and MySQL-5.7.8 RC. We used two boxes ...

The post State of Percona Server 5.6, MySQL 5.6 and MySQL 5.7 RC appeared first on MySQL Performance Blog.

Internet of Things, Messaging and MySQL

MySQL Performance Blog - Fri, 23/10/2015 - 8:56pm

Personal Projects with the Internet of Things So you want to do a personal project with the Internet of Things (maybe a home automation or metrics collection or something else)? In this blog post I will tell about my ...

The post Internet of Things, Messaging and MySQL appeared first on MySQL Performance Blog.

Percona XtraBackup 2.3.2 GA is now available

MySQL Performance Blog - Thu, 22/10/2015 - 4:12pm

Percona is glad to announce the release of Percona XtraBackup 2.3.2 GA on October 22nd, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user ...

The post Percona XtraBackup 2.3.2 GA is now available appeared first on MySQL Performance Blog.

Percona XtraBackup 2.2.13 is now available

MySQL Performance Blog - Thu, 22/10/2015 - 4:12pm

Percona is glad to announce the release of Percona XtraBackup 2.2.13 on October 22nd, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, ...

The post Percona XtraBackup 2.2.13 is now available appeared first on MySQL Performance Blog.

RocksDB 101

MySQL Performance Blog - Wed, 21/10/2015 - 2:30pm

After we announced that Percona offers support for RocksDB, we saw many people looking for more details about this storage engine. Here is a quick list of some of the most frequent questions we get. Q: ...

The post RocksDB 101 appeared first on MySQL Performance Blog.

Slow query graphs using Performance Schema and Graphite

MySQL Performance Blog - Tue, 20/10/2015 - 1:25pm

I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the ability to known what is going on inside the database is priceless. How about having ...

The post Slow query graphs using Performance Schema and Graphite appeared first on MySQL Performance Blog.

Percona Live 2016 Call for Papers Open! Introducing: Community Voting

MySQL Performance Blog - Tue, 20/10/2015 - 10:56am

The Call for Papers for the fifth annual Percona Live Data Performance Conference and Expo (formerly MySQL Conference and Expo) taking place April 18-21, 2016, in Santa Clara, California, is now officially open! Ask yourself… “Do I have…” Fresh ideas? ...

Percona Welcomes David Murphy as Practice Manager for MongoDB

MySQL Performance Blog - Mon, 19/10/2015 - 5:35pm

We are excited this week to welcome David Murphy to Percona as our Practice Manager for MongoDB®. A veteran of ObjectRocket, Electronic Arts, and Rackspace, David is a welcome addition to our team and will ...

The post Percona Welcomes David Murphy as Practice Manager for MongoDB appeared first on MySQL Performance Blog.

Percona Live Amsterdam Recap

MySQL Performance Blog - Sun, 18/10/2015 - 2:00pm

This year’s Percona Live for Europe proved to be a turning point for the conference. First and most obvious was the change of venue. After several years in London we decided to move the show ...

The post Percona Live Amsterdam Recap appeared first on MySQL Performance Blog.

MySQL 101 Videos – A Must Have Starter Kit for a MySQL DBA

MySQL Performance Blog - Fri, 16/10/2015 - 6:35pm

The MySQL 101 track was introduced at the 2015 Percona Live MySQL Conference & Expo in Santa Clara, California. This track was tailored specifically for software developers and other specialists with technical backgrounds wanting to ...

The post MySQL 101 Videos – A Must Have Starter Kit for a MySQL DBA appeared first on MySQL Performance Blog.

Gartner, Thank You for Recognizing Percona in the Magic Quadrant for ODBMS!

MySQL Performance Blog - Fri, 16/10/2015 - 6:11pm

But mostly thank you to our customers who said more about Percona than we ever could have. There are many milestones in the life of the company, and being included in the Gartner Magic Quadrant ...

The post Gartner, Thank You for Recognizing Percona in the Magic Quadrant for ODBMS! appeared first on MySQL Performance Blog.

Proxy Protocol and Percona XtraDB Cluster: A Quick Guide

MySQL Performance Blog - Thu, 15/10/2015 - 5:23pm

On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0. With this blog post, I want to promote a new feature ...

The post Proxy Protocol and Percona XtraDB Cluster: A Quick Guide appeared first on MySQL Performance Blog.

Percona XtraDB Cluster 5.6.26-25.12 is now available

MySQL Performance Blog - Thu, 15/10/2015 - 3:35pm

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on October 15th 2015. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.26-74.0 including all ...

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

MySQL query digest with Performance Schema

MySQL Performance Blog - Tue, 13/10/2015 - 9:12pm

Query analysis is a fantastic path in the pursuit to achieve high performance. It’s also probably the most repeated part of a DBA’s daily adventure. For most of us, the weapon of choice is definitely ...

The post MySQL query digest with Performance Schema appeared first on MySQL Performance Blog.

Online DDL and Percona XtraDB Cluster 5.6

MySQL Performance Blog - Fri, 09/10/2015 - 2:11pm

I presented a talk at Percona Live Amsterdam a few weeks ago (simple recipes for your Galera cluster), and one of the topics was schema changes. I discussed the drawbacks and benefits of Total Order ...

The post Online DDL and Percona XtraDB Cluster 5.6 appeared first on MySQL Performance Blog.

When mysqld kills mysqld

MySQL Performance Blog - Fri, 09/10/2015 - 1:40pm

The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had to track down the process shutting down MySQL. This blog is based on the discussion ...

The post When mysqld kills mysqld appeared first on MySQL Performance Blog.

Using Apache Spark and MySQL for Data Analysis

MySQL Performance Blog - Wed, 07/10/2015 - 10:49pm

What is Spark Apache Spark is a cluster computing framework, similar to Apache Hadoop. Wikipedia has a great description of it: Apache Spark is an open source cluster computing framework originally developed in the AMPLab ...

The post Using Apache Spark and MySQL for Data Analysis appeared first on MySQL Performance Blog.

Capture database traffic using the Performance Schema

MySQL Performance Blog - Thu, 01/10/2015 - 12:42pm

Capturing data is a critical part of performing a query analysis, or even just to have an idea of what’s going on inside the database. There are several known ways to achieve this. For example: Enable ...

The post Capture database traffic using the Performance Schema appeared first on MySQL Performance Blog.

Percona XtraDB Cluster 5.6.25-25.12 is now available

MySQL Performance Blog - Mon, 21/09/2015 - 9:20pm

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on September 21st 2015. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.25-73.1 including all ...

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

Containing your logical backups: mydumper in docker

MySQL Performance Blog - Mon, 21/09/2015 - 8:54pm

Even with software like Percona Xtrabackup, logical backups remain an important component of a thorough backup strategy. To gather a logical backup in a timely fashion we rely on a tool called mydumper. In the Percona Managed Services ...

The post Containing your logical backups: mydumper in docker appeared first on MySQL Performance Blog.

Percona Server for MongoDB 3.0.5-rc7 is now available

MySQL Performance Blog - Mon, 21/09/2015 - 8:29pm

Percona is pleased to announce the release of Percona Server for MongoDB 3.0.5-rc7 on September 21, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, ...

The post Percona Server for MongoDB 3.0.5-rc7 is now available appeared first on MySQL Performance Blog.

VividCortex Agent Benchmark

MySQL Performance Blog - Fri, 18/09/2015 - 6:42pm

Intro The purpose of this project was to measure the potential overhead of VividCortex Agent, which is used by vividcortex.com database monitoring system. This benchmark is part of a consulting engagement with VividCortex and paid ...

The post VividCortex Agent Benchmark appeared first on MySQL Performance Blog.

Clarification on “Call me Maybe: MariaDB Galera Cluster”

MySQL Performance Blog - Thu, 17/09/2015 - 6:41pm

Recently Aphyr (Kyle Kingsbury) published https://aphyr.com/posts/327-call-me-maybe-mariadb-galera-cluster The article is technically valid, I am not going to dispute a conclusion Aphyr made, but it is also quite technically involved, so users who just jump to conclusion ...

The post Clarification on “Call me Maybe: MariaDB Galera Cluster” appeared first on MySQL Performance Blog.

Webinar: Introduction to MySQL SYS Schema follow up questions

MySQL Performance Blog - Wed, 16/09/2015 - 9:57pm

Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the extra questions I didn’t have time to answer on the stream. Can i have the ...

The post Webinar: Introduction to MySQL SYS Schema follow up questions appeared first on MySQL Performance Blog.

Pages

Subscribe to MySQL Performance Blog