EmergencyEMERGENCY? Get 24/7 Help Now!

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

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

Percona Server 5.7 performance improvements

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 cost_info  knows why the optimizer prefers one index to another. Tables often have more than one index. Any of these indexes can be used to resolve query. The optimizer has […]

Read More

Upcoming Webinar Wednesday: Using Grafana for MySQL Monitoring

 | February 21, 2016 |  Posted In: MySQL

Grafana MySql monitoring

Grafana is the leading graph and dashboard builder for visualizing time series, which is a great tool for visual monitoring of MySQL databases. Come learn how to use Grafana for MySQL monitoring. In this webinar, Torkel Odegaard, Grafana Founder and Creator, will provide an introduction to Grafana and talk about adding data sources, creating dashboards […]

Read More

Myth Busting: MongoDB Scalability (it scales!)

 | February 19, 2016 |  Posted In: MongoDB, Solutions Engineering

MongoDB Scalability

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 my attention: he mentioned to me that several customers he has been in contact with have been telling him that “MongoDB […]

Read More

MongoDB, security, and how not to get stung

 | February 18, 2016 |  Posted In: MongoDB

MongoDB security

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 anybody to ransack for personal information. When it was discovered (by a user), it was quickly acknowledged and remedied. So […]

Read More

MySQL Auditing with MariaDB Auditing Plugin

 | February 15, 2016 |  Posted In: MariaDB, MySQL, MySQL Audit Log Plugin

MySQL MariaDB audit

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. By auditing your database, you can achieve accountability for actions taken or content accessed within your environment. You will also […]

Read More

Measuring Docker IO overhead

 | February 11, 2016 |  Posted In: Docker, MySQL, Percona Server for MySQL

Docker

This will be another post on using Percona Server via a Docker image. I want to follow up on my previous post regarding CPU/Network overhead in Docker “Measuring Percona Server Docker CPU/network overhead” by measuring  if there is any docker IO overhead on operations. After running several tests, it appears (spoiler alert) that there is no Docker IO overhead. […]

Read More

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

 | February 10, 2016 |  Posted In: Percona Live

Welcome to the first of several discussions with some of our upcoming 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 well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the […]

Read More

Estimating potential for MySQL 5.7 parallel replication

 | February 10, 2016 |  Posted In: MySQL

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 a single schema is used. Now the question is: how many replication threads should you use? A simple benchmark Let’s […]

Read More

EXPLAIN FORMAT=JSON: buffer_result is not hidden!

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

MongoDB System Tuning

Time for another entry in the EXPLAIN FORMAT=JSON is cool! series. Today we’re going to look at how you can view the buffer result using JSON (instead of the regular EXPLAIN command. Regular EXPLAIN does not identify if SQL_BUFFER_RESULT was used at all. To demonstrate, let’s run this query:

Now, let’s compare it to this query:

Notice there […]

Read More