EmergencyEMERGENCY? Get 24/7 Help Now!

EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent

 | February 29, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

EXPLAIN FORMAT=JSON

Once again it’s time for another EXPLAIN FORMAT=JSON is cool! post. This post will discuss how EXPLAIN FORMAT=JSON allows the nested_loop command to make the JOIN operation hierarchy transparent. The regular EXPLAIN  command lists each table that participates in a  JOIN  operation on a single row. This works perfectly for simple queries:

You can see […]

Read More

Graphing MySQL performance with Prometheus and Grafana

 | February 29, 2016 |  Posted In: Database Monitoring, MySQL, Prometheus

  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. Update, February 20, 2017: Since this blog post was published, we have released Percona Monitoring and Management (PMM), which is the easiest way to monitor MySQL and MongoDB using Grafana […]

Read More

Monitoring MongoDB Response Time

 | February 26, 2016 |  Posted In: MongoDB, Prometheus

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 Tim Callaghan’s sysbench-mongodb. Since I’m interested in measuring response time for database operations, I created a very simple exporter of response time […]

Read More

Percona Back to Basics: MongoDB updates

 | February 25, 2016 |  Posted In: MongoDB

Welcome to the first in a new series of MongoDB blogs. These blogs will cover a selection of topics, including: How-tos New release and new features Getting back to the basics Solutions from the field In this first blog, we’ll discuss MongoDB updates. You can use the update method to update documents in a collection. […]

Read More

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

 | February 25, 2016 |  Posted In: GTID, High-availability, MariaDB, Maxscale, MySQL

High availability with asynchronous replication

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication. When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ? Description: […]

Read More

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

 | February 24, 2016 |  Posted In: MongoDB

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 the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona […]

Read More

MySQL connection using SSL… or not ?

 | February 23, 2016 |  Posted In: MySQL

MySQL connection using SSL

In this blog post, we’ll discuss how we can determine if a MySQL connection is using SSL. Since MySQL 5.7.5 the server generates SSL certificates (see auto_generate_certs) by default if compiled with SSL, or uses mysql_ssl_rsa_setup if compiled with YaSSL. But how can we check to see if our MySQL client connection uses SSL ? When using an […]

Read More

Percona Server 5.7.10-3 GA is now available

 | February 23, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

Percona Server

Percona is glad to announce the first GA release of Percona Server 5.7.10-3 on February 23, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.7.10, including all the bug fixes in it, Percona Server 5.7.10-3 is the current GA release in the Percona Server 5.7 series. All […]

Read More

Percona XtraBackup 2.4.1 GA is now available

 | February 23, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona XtraBackup

Percona is glad to announce the first GA release of Percona XtraBackup 2.4.1 on February 23rd 2016. Downloads are available from our download site and from apt and yum 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 […]

Read More