Subscribe: MySQL Performance Blog
Preview: MySQL Performance Blog

Percona Database Performance Blog

Last Build Date: Fri, 19 Jan 2018 16:17:13 +0000


Percona Monitoring and Management (PMM) 1.6.0 Is Now Available

Fri, 19 Jan 2018 15:51:19 +0000

(image) Percona announces the release of Percona Monitoring and Management (PMM) 1.6.0. In this release, Percona Monitoring and Management Grafana metrics are available in the Advanced Data Exploration dashboard. We’ve improved the integration with MyRocks, and its data is now collected from SHOW GLOBAL STATUS. The MongoDB Exporter now features two new metrics: mongodb_up to inform if the MongoDB Server is […]

This Week in Data with Colin Charles 24: more Meltdown, FOSDEM, Slack and reminiscing

Fri, 19 Jan 2018 11:27:42 +0000

(image) Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There is still much going on when it comes to Meltdown/Spectre in our world. Percona’s Vadim Tkachenko and Alexey Stroganov recently published Does the Meltdown Fix Affect Performance for MySQL on Bare Metal?. You also […]

Does the Meltdown Fix Affect Performance for MySQL on Bare Metal?

Thu, 18 Jan 2018 23:18:00 +0000

(image) In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers. Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects MySQL (Percona Server for MySQL) under a sysbench workload. […]

ProxySQL 1.4.4 and Updated proxysql-admin Tool Now in the Percona Repository

Thu, 18 Jan 2018 16:55:44 +0000

(image) ProxySQL 1.4.4, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created […]

Troubleshooting Percona Monitoring and Management (PMM) Metrics

Wed, 17 Jan 2018 16:28:51 +0000

(image) In this blog post, I’ll look at some helpful tips on troubleshooting Percona Monitoring and Management metrics. With any luck, Percona Monitoring and Management (PMM) works for you out of the box. Sometimes, however, things go awry and you see empty or broken graphs instead of dashboards full of insights. Before we go through troubleshooting steps, let’s […]

Updating/Deleting Rows From Clickhouse (Part 2)

Tue, 16 Jan 2018 19:44:23 +0000

(image) In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the second of two parts. In the first part of this post, we described the high-level overview of implementing incremental refresh on a ClickHouse table as an alternative support for UPDATE/DELETE. In this part, we will show you the actual steps and […]

Webinar January 18, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2

Tue, 16 Jan 2018 17:25:20 +0000

(image) Join Percona’s Product Manager Michael Coburn as he presents MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2 on Thursday, January 18, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Register Now Tags: Percona Monitoring and Management, PMM, Monitoring, MySQL, Performance, Optimization, DBA, SysAdmin, DevOps Experience Level: Expert Optimizing […]

ProxySQL Firewalling

Mon, 15 Jan 2018 22:57:10 +0000

(image) In this blog post, we’ll look at ProxySQL firewalling (how to use ProxySQL as a firewall). Not long ago we had an internal discussion about security, and how to enforce a stricter set of rules to prevent malicious acts and block other undesired queries. ProxySQL came up as a possible tool that could help us in achieving […]

Sneak Peek of the Percona Live 2018 Open Source Database Conference Breakout Sessions!

Mon, 15 Jan 2018 17:50:27 +0000

(image) Take a look at the sneak peek of the breakout sessions for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, California. Early Bird registration discounts are available until February 4, 2018, and sponsorship opportunities are still available. Conference breakout sessions will feature a range […]

Compare Current and Past Time Series Graphs in Percona Monitoring and Management (PMM)

Sat, 13 Jan 2018 00:35:22 +0000

(image) In this short blog post, I will show you how you can compare current and past time series in Percona Monitoring and Management (PMM). Recently, a support customer shared a graph with us that compared query throughput between today and yesterday as a confirmation that optimizing their server variables improved performance. Do you want to […]