by Borys Belinsky | Oct 11, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.3.2. This release only contains bug fixes related to usability. For install and upgrade instructions, see Deploying Percona Monitoring and Management. Bug fixes PMM-1529: When the user selected...
by Emily Ikuta | Oct 10, 2017 | MongoDB, MySQL, Percona Software, Storage Engine, Webinars
Join Percona’s Product Manager Michael Coburn as he presents a Percona Monitoring and Management (PMM) Demonstration on Wednesday, October 11, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now How can you optimize database performance if you can’t see what’s...
by Colin Charles | Oct 6, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Events, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week: a quick roundup of releases, a summary of my thoughts about Percona Live Europe 2017 Dublin, links to look at and...
by Borys Belinsky | Oct 5, 2017 | MariaDB, MongoDB, Monitoring, MySQL, Percona Software
The Metrics Monitor of Percona Monitoring and Management 1.3.0 (PMM) provides graph descriptions to display more information about the monitored data without cluttering the interface. Percona Monitoring and Management 1.3.0 is a free and open-source platform for...
by Lorraine Pocklington, Community Manager | Oct 4, 2017 | MongoDB, MySQL, Percona Live
One for the road… The social events at Percona Live Europe provide the community with more time to catch up with old friends and make new contacts. The formal sessions provided lots of opportunities for exchanging notes, experiences and ideas. Lunches and coffee...
by Vadim Tkachenko | Oct 4, 2017 | MySQL
I will be presenting at the ClickHouse MySQL Silicon Valley Meetup on Wednesday, October 25, 2017, at 6:30 PM. ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved itself...
by Colin Charles | Sep 29, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe 2017 Dublin We’ve spent a lot of time in the last few months organizing Percona Live Europe...
by Borys Belinsky | Sep 29, 2017 | MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.3.1. This release only contains bug fixes related to usability. For install and upgrade instructions, see Deploying Percona Monitoring and Management. Bug fixes PMM-1271: In QAN, when the user...
by Lorraine Pocklington, Community Manager | Sep 28, 2017 | Cloud, MySQL, Percona Live
One of the widely discussed technologies at Percona Live Europe was the logistics of running MySQL in containers. Containers – particularly Docker – have become a hot topic, so there was a good-sized crowd on day one of the conference for Ashraf Sharif, Senior Support...
by Lorraine Pocklington, Community Manager | Sep 27, 2017 | MongoDB, MySQL, Percona Live, Storage Engine
Black coffee was flowing this morning for day two Percona Live Europe 2017 Keynotes after many of the delegates had spent a good few hours the night before enjoying Irish hospitality at the Community Dinner. So today Laurie Coffin, Chief Marketing Officer for Percona,...
by Borys Belinsky | Sep 26, 2017 | MongoDB, MySQL, Percona Events, Percona Live, Percona Software
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...
by Jervin Real | Sep 25, 2017 | Insight for DBAs, MySQL
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: MySQL update ibreg set k=1 where id in (select id from ibcmp where id >...
by Lorraine Pocklington, Community Manager | Sep 25, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live
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...
by Yves Trudeau | Sep 22, 2017 | Insight for DBAs, MySQL
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...
by Colin Charles | Sep 22, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Events, Percona Live
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...
by Dave Avery | Sep 21, 2017 | Benchmarks, MySQL, Percona Live
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....
by Peter Zaitsev | Sep 20, 2017 | Insight for DBAs, Monitoring, MySQL
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....
by Jervin Real | Sep 19, 2017 | Insight for DBAs, ProxySQL, Security
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,...
by Colin Charles | Sep 15, 2017 | Insight for DBAs, Insight for Developers, Percona Events, Percona Live, Percona Software
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. What a long, packed week! Spent most of it at Open Source Summit North America, while still enjoying the myriad phone calls...
by Jervin Real | Sep 14, 2017 | Insight for DBAs, MySQL, Webinars
Hello again! On August 16, we delivered a webinar on MySQL backups. As always, we’ve had a number of interesting questions. Some of them we’ve answered on the webinar, but we’d like to share some of them here in writing. What is the best way to...
