MySQL Performance Blog

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

Percona's Data performance and scalability blog

How to Mitigate DROWN CVE-2016-0800

MySQL Performance Blog - Fri, 04/03/2016 - 11:50pm

This blog post will discuss how to Mitigate DROWN CVE-2016-0800. Unless you’ve been living in a cave you’ll have heard (or likely to hear about soon) the drown attack. From the Red Hat site: “A ...

Virtual columns in MySQL and MariaDB

MySQL Performance Blog - Fri, 04/03/2016 - 8:14pm

In this blog post, we’ll compare virtual columns in MySQL and MariaDB. Virtual columns are one of my top features in MySQL 5.7: they can store a value that is derived from one or several ...

Percona Server 5.5.48-37.8 is now available

MySQL Performance Blog - Fri, 04/03/2016 - 3:18pm

Percona is glad to announce the release of Percona Server 5.5.48-37.8 on March 4, 2016.

Deals of a “Live” time: $5 Percona Live Keynote Passes!

MySQL Performance Blog - Thu, 03/03/2016 - 5:55pm

Percona Live featured talk with Mark Callaghan – Keynote speaker: RocksDB

MySQL Performance Blog - Wed, 02/03/2016 - 11:43pm

Percona Live featured talk Mark Callaghan Facebook

How MaxScale monitors servers

MySQL Performance Blog - Wed, 02/03/2016 - 3:56pm

In this post, we’ll address how MaxScale monitors servers. We saw in the We saw in the previous post how we could deal with high availability (HA) and read-write split using MaxScale. If you remember ...

EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent

MySQL Performance Blog - Mon, 29/02/2016 - 10:38pm

Graphing MySQL performance with Prometheus and Grafana

MySQL Performance Blog - Mon, 29/02/2016 - 7:49am

This post explains how you can quickly start using such trending tools as Prometheus and Grafana for monitoring and graphing of MySQL and system performance. I will try to keep as short as possible so ...

Monitoring MongoDB Response Time

MySQL Performance Blog - Fri, 26/02/2016 - 11:52pm

In this blog post, we’ll discuss how using Prometheus can help with monitoring MongoDB response time. I am currently comparing the performance of different storage engines on Percona Server for MongoDB, using a slightly customized version of ...

Percona Back to Basics: MongoDB updates

MySQL Performance Blog - Thu, 25/02/2016 - 10:25pm

High availability with asynchronous replication… and transparent R/W split

MySQL Performance Blog - Thu, 25/02/2016 - 6:54pm

Percona Live featured talk with Kat Styons – Shifting the Paradigm: MongoDB and the MEAN Stack

MySQL Performance Blog - Wed, 24/02/2016 - 8:23pm

Welcome to the next installment of our talks with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss ...

Percona Server for MongoDB 3.0.8-1.3 is now available

MySQL Performance Blog - Wed, 24/02/2016 - 2:26pm

MySQL connection using SSL… or not ?

MySQL Performance Blog - Tue, 23/02/2016 - 11:20pm

In this blog post, we’ll discuss how we can determine if

Percona Server 5.7.10-3 GA is now available

MySQL Performance Blog - Tue, 23/02/2016 - 1:33pm

Percona is glad to announce the first GA release of Percona Server 5.7.10-3 on February 23, 2016.

Percona XtraBackup 2.4.1 GA is now available

MySQL Performance Blog - Tue, 23/02/2016 - 1:30pm

Percona is glad to announce the first GA release of Percona XtraBackup 2.4.1 on February 23rd 2016.

EXPLAIN FORMAT=JSON: cost_info knows why optimizer prefers one index to another

MySQL Performance Blog - Mon, 22/02/2016 - 4:41pm

Time for another entry in the EXPLAIN FORMAT=JSON is cool! series of blog posts. This time we’ll discuss how using EXPLAIN FORMAT=JSON allows you to see that [crayon-56cb5ab40ea2e161297961-i/] knows why the optimizer prefers one index to ...

Upcoming Webinar Wednesday: Using Grafana for MySQL Monitoring

MySQL Performance Blog - Sun, 21/02/2016 - 3:30pm

Myth Busting: MongoDB Scalability (it scales!)

MySQL Performance Blog - Fri, 19/02/2016 - 6:15pm

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to ...

MongoDB, security, and how not to get stung

MySQL Performance Blog - Fri, 19/02/2016 - 12:49am

In a recent article over at The Inquirer, Microsoft got roundly savaged for a database security leak. Apparently their third-party database operator didn’t correctly secure the backdoor to their “careers “database, leaving it open for ...

Percona Live featured talk with Geir Hoydalsvik: What’s New in MySQL

MySQL Performance Blog - Tue, 16/02/2016 - 5:32pm

Welcome to the next installment of our talks with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the talks that will happen at this year’s conference, as ...

MySQL Auditing with MariaDB Auditing Plugin

MySQL Performance Blog - Mon, 15/02/2016 - 11:49pm

This blog will address how the MariaDB Auditing Plugin can help monitor database activity to help with security, accountability and troubleshooting. Why Audit Your Databases? Auditing is an essential task for monitoring your database environment. ...

Measuring Docker IO overhead

MySQL Performance Blog - Thu, 11/02/2016 - 8:38pm

This will be another post on using Percona Server via a Docker image.

Percona Live featured talk with Sergej Jurecko: ActorDB — an alternative view of a distributed database

MySQL Performance Blog - Wed, 10/02/2016 - 9:28pm

Estimating potential for MySQL 5.7 parallel replication

MySQL Performance Blog - Wed, 10/02/2016 - 6:19pm

Unlike MySQL 5.6, where parallel replication can only be used when replicas have several schemas, MySQL 5.7 replicas can read binlog group commit information coming from the master to replicate transactions in parallel even when ...

Main menu

You are here