EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live Europe Featured Talks: NoSQL Best Practices for PostgreSQL with Dmitry Dolgov

 | September 7, 2017 |  Posted In: JSON, MySQL, Percona Live, PostgreSQL

Colin Charles

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post is with Dmitry Dolgov, a […]

Read More

Percona Live 2017 Tutorials Day

 | April 25, 2017 |  Posted In: Benchmarks, Big Data, Cloud and MySQL, Cloud and NoSQL, InnoDB, JSON, MariaDB, MongoDB, MyRocks, MySQL, Percona Live

Percona Live Keynotes

Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies. Today attendees went to training sessions taught by […]

Read More

Services Monitoring with Probabilistic Fault Detection

 | March 9, 2017 |  Posted In: Database Monitoring, JSON, MongoDB, MySQL

Services Monitoring

In this blog post, we’ll discuss services monitoring using probabilistic fault detection. Let’s admit it, the task of monitoring services is one of the most difficult. It is time-consuming, error-prone and difficult to automate. The usual monitoring approach has been pretty straightforward in the last few years: setup a service like Nagios, or pay money to […]

Read More

Elasticsearch Ransomware: Open Source Database Security Part 2

and  | January 18, 2017 |  Posted In: Big Data, JSON

Elasticsearch Ransomware

In this blog post, we’ll look at a new Elasticsearch ransomware outbreak and what you can do to prevent it happening to you. Mere weeks after reports of MongoDB servers getting hacked and infected with ransomware, Elasticsearch clusters are experiencing the same difficulties. David Murphy’s blog discussed the situation and the solution for MongoDB servers. In this […]

Read More


 | April 6, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL


This blog is an EXPLAIN FORMAT=JSON wrap-up for the series of posts I’ve done in the last few months. In this series, we’ve discussed everything unique to EXPLAIN FORMAT=JSON. I intentionally skipped a description of members such as table_name, access_type  or select_id, which are not unique. In this series, I only mentioned in passing members that […]

Read More

JSON document fast lookup with MySQL 5.7

 | March 7, 2016 |  Posted In: JSON, MySQL

In this blog post, we’ll discuss JSON document fast lookup with MySQL 5.7. Recently I attended Morgan Tocker’s talk on MySQL 5.7 and JSON at FOSDEM, and I found it awesome. I learned some great information from the talk. Let me share one of them here: a very useful trick if you plan to store JSON […]

Read More

EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent

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


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