Monthly Archives - February 2016

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

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

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!)

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 […]

Read more

MongoDB, security, and how not to get stung

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. […]

Read more

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

Geir Hoydalsvik What’s New in MySQL

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 well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to […]

Read more

MySQL Auditing with MariaDB Auditing 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 deter […]

Read more

Measuring Docker IO overhead

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

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 […]

Read more

Estimating potential for MySQL 5.7 parallel replication

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 assume […]

Read more

EXPLAIN FORMAT=JSON: buffer_result is not hidden!

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:

MySQL

mysql> explain select * from salariesG
*************************** 1. row ***************************
[…]

Read more