Percona announces the release of Percona Monitoring and Management 1.3.0 on September 26, 2017. Percona Monitoring and Management 1.3.0 introduces basic support for the MyRocks storage engine. There is a special dashboard in Metrics Monitor that presents the essential metrics of MyRocks as separate graphs. Also, Metrics Monitor graphs now feature on-demand descriptions that remain visible as long […]
Read More
In this blog post, we’ll look at how to avoid shared locks from subqueries. I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query:
|
1 |
update ibreg set k=1 where id in (select id from ibcmp where id > 90000); |
This query, when executed with autocommit=1, is normally harmless. However, this can have bad effects when combined with other statements in the […]
Read More
Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! Technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies. Today attendees went to training sessions taught by open source database […]
Read More
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 […]
Read More
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.
Read More
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! […]
Read More
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, […]
Read More
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 […]
Read More
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 […]
Read MorePercona 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 […]
Read MorePercona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.
No, thank you. Please do not ask me again.
