Subscribe: MySQL Performance Blog
http://www.mysqlperformanceblog.com/feed/
Preview: MySQL Performance Blog

Percona Database Performance Blog





Last Build Date: Fri, 22 Sep 2017 22:34:28 +0000

 



Percona XtraDB Cluster 5.7.19-29.22 is now available

Fri, 22 Sep 2017 22:34:28 +0000

(image) Percona announces the release of Percona XtraDB Cluster 5.7.19-29.22 on September 22, 2017. Binaries are available from the downloads section or our software repositories. NOTE: You can also run Docker containers from the images in the Docker Hub repository. Percona XtraDB Cluster 5.7.19-29.22 is now the current release, based on the following: Percona Server 5.7.19-17 Galera […]



How to Deal with XA Transactions Recovery

Fri, 22 Sep 2017 18:38:13 +0000

(image) For most people (including me until recently) database XA transactions are a fuzzy concept. In over eight years with Percona, I have never had to deal with XA transactions. Then a few weeks ago I got two customers having issues with XA transactions. That deserves a post. XA 101 What are XA transactions? XA transactions […]



This Week in Data with Colin Charles #7: Percona Live Europe and Open Source Summit North America

Fri, 22 Sep 2017 18:05:59 +0000

(image) Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe Dublin Are you affected by the Ryanair flight cancellations? Have you made alternative arrangements? Have you registered for the community dinner? Even speakers have to register, so this is a separate ticket cost! […]



Percona Support with Amazon RDS

Thu, 21 Sep 2017 21:35:18 +0000

(image) This blog post will give a brief overview of Amazon RDS capabilities and limitations, and how Percona Support can help you succeed in your Amazon RDS deployments. One of the common questions that we get from customers and prospective customers is about Percona Support with Amazon RDS. As many companies have shifted to the cloud, […]



Percona Live Europe Featured Talks: Modern sysbench – Teaching an Old Dog New Tricks with Alexey Kopytov

Thu, 21 Sep 2017 16:40:43 +0000

(image) 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 Alexey Kopytov, sofware […]



sysbench Histograms: A Helpful Feature Often Overlooked

Wed, 20 Sep 2017 20:11:10 +0000

(image) In this blog post, I will demonstrate how to run and use sysbench histograms. One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers. Looking at histograms together with throughput or latency over time […]



Percona XtraDB Cluster 5.6.37-26.21 is Now Available

Wed, 20 Sep 2017 18:03:38 +0000

(image) Percona announces the release of Percona XtraDB Cluster 5.6.37-26.21 on September 20, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.37-26.21 is now the current release, based on the following: Percona Server for MySQL 5.6.37-82.2 Galera Replication library 3.21 wsrep API version 26 All Percona software is open-source and […]



Percona Live Europe Featured Talks: Automatic Database Management System Tuning Through Large-Scale Machine Learning with Dana Van Aken

Tue, 19 Sep 2017 23:09:25 +0000

(image) 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 Dana Van Aken, […]



ProxySQL Improves MySQL SSL Connections

Tue, 19 Sep 2017 18:47:39 +0000

(image) In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance. When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with PHP, mysql.connector.pooling in Python, etc.). Closing and making new connections over and over can greatly impact […]



Webinar Tuesday, September 19, 2017: A Percona Support Engineer Walkthrough for pt-stalk

Mon, 18 Sep 2017 19:02:29 +0000

(image) Join Percona’s, Principal Support Engineer, Markus Albe as he presents A Percona Support Engineer Walkthrough for pt-stalk on Tuesday, September 19, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now As a support engineer, I get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE […]