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...
by Dave Avery | Sep 14, 2017 | MongoDB, Monitoring, 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 Dave Avery | Sep 13, 2017 | MongoDB, Monitoring, 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 Vadim Tkachenko | Sep 13, 2017 | Insight for DBAs, Monitoring, MySQL
In this blog, I’ll look at how to use ClickHouse for parallel log processing. Percona is seen primarily for our expertise in MySQL and MongoDB (at this time), but neither is quite suitable to perform heavy analytical workloads. There is a need to analyze data...
by Agustín | Sep 12, 2017 | Insight for DBAs, MariaDB, MySQL
In this post, we will discuss how to search code with the help of cscope. Let’s begin by checking its description and capabilities (quoting directly from http://cscope.sourceforge.net/): Cscope is a developer’s tool for browsing source code. Allows...
by Emily Ikuta | Sep 12, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Webinars
Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot ClickHouse is a...
by Sveta Smirnova | Sep 11, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL
In this post, we will discuss the best way to update an InnoDB table manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default....
by Emily Ikuta | Sep 11, 2017 | MariaDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles (@bytebot) as he presents Differences Between MariaDB and MySQL on Tuesday, September 12, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Reserve Your Spot Are they syntactically similar? Where do these two query...
by Manjot Singh | Sep 7, 2017 | MySQL
In this blog post, I’ll look at a comparison of PostgreSQL and MySQL. I came across a post from Hans-Juergen Schoenig, a Postgres consultant at Cybertec. In it, he dismissed MySQL and showed Postgres as better. While his post ignores most of the reasons why...
by Emily Ikuta | Sep 6, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Software, Webinars
Join Percona’s Product Manager, Michael Coburn as he presents Using Percona Monitoring and Management to Troubleshoot MySQL Performance Issues on Thursday, September 7, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot Successful applications often...
