Monthly Archives - June 2015

Percona Monitoring Plugins 1.1.5 release

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.5.
Changelog:

Added more DB instance classes to pmp-check-aws-rds.py (issue 1398911)
Added configurable query period and average time to pmp-check-aws-rds.py (issue 1436943)
Added region support to pmp-check-aws-rds.py (issue 1442980)
Added an option to alert when server is not configured as replica to pmp-check-mysql-replication-delay (issue 1357017)
Added an option to […]

Read more

Q&A: High availability when using MySQL in the cloud

Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that page.
We had several excellent questions and we didn’t have time […]

Read more

Getting EXPLAIN information from already running queries in MySQL 5.7

When a new version of MySQL is about to be released we read a lot of blog posts about the performance and scalability improvements. That’s good but sometimes we miss some small features that can help us a lot in our day-to-day tasks. One good example is the blog post that Aurimas wrote about […]

Read more

Update on the InnoDB double-write buffer and EXT4 transactions

IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data.
In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on the post mentioning […]

Read more

Speed up MySQL Queries GROUP BY with subselects

Speed up queries on MySQL

We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect?
This example was tested over table a (1310723 rows), b, c and d ( 5 rows each) and with MySQL version 5.5 and 5.6.
Let’s suppose […]

Read more