by Jervin Real | Feb 16, 2018 | MySQL
In this blog post, we’ll look at how ZFS affects MySQL performance when used in conjunction. ZFS and MySQL have a lot in common since they are both transactional software. Both have properties that, by default, favors consistency over performance. By doubling...
by Colin Charles | Feb 16, 2018 | Cloud, MariaDB, MongoDB, MySQL, Open Source, Percona Events, Percona Software, PostgreSQL, ProxySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. In case you missed last week’s column, don’t forget to read the fairly lengthy FOSDEM MySQL & Friends...
by Dmitriy Kostiuk | Feb 15, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.5, 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...
by Sveta Smirnova | Feb 15, 2018 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Crashes webinar. First, I want to thank everybody for attending our January 25, 2018, webinar. The recording and slides for the webinar are available here. Below is the list of your...
by Peter Zaitsev | Feb 14, 2018 | MySQL
In this blog post, we’ll review additional Amazon Aurora MySQL monitoring capabilities we’ve added in Percona Monitoring and Management (PMM) 1.7.0. You can see them in action in the MySQL Amazon Aurora Metrics dashboard. Amazon Aurora MySQL Transaction...
by Krunal Bauskar | Feb 13, 2018 | Insight for DBAs, MySQL, Percona Software
What if we tell you that there is a sure way to get IST not SST for node rejoins? You can guarantee that a new node rejoins using IST. Sound interesting? Keep reading. Normally when a node is taken out of the cluster for a short period of time (for maintenance or...
by Dmitriy Kostiuk | Feb 13, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.6.39-83.1 on February 13, 2018. Based on MySQL 5.6.39, including all the bug fixes in it, Percona Server for MySQL 5.6.39-83.1 is now the current stable release in the 5.6 series. Percona Server for MySQL is...
by Sveta Smirnova | Feb 12, 2018 | Insight for DBAs, MySQL, Open Source, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents “Basic Internal Troubleshooting Tools for MySQL Server” on Thursday, February 15, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now MySQL Server has...
by Borys Belinsky | Feb 12, 2018 | MariaDB, MongoDB, Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Nickolay Ihalainen | Feb 9, 2018 | Monitoring, Percona Software, PostgreSQL
In this article, we’ll describe how to collect PostgreSQL metrics with Percona Monitoring and Management (PMM). We designed Percona Monitoring and Management (PMM) to be the best tool for MySQL and MongoDB performance investigation. At the same time, it’s...
by Colin Charles | Feb 9, 2018 | Insight for DBAs, MariaDB, MySQL, Percona Events, Percona Live, Percona Software, ProxySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 update: tutorials have been announced. The committee rated over 300+ talks, and easily 70% of...
by Yves Trudeau | Feb 8, 2018 | Hardware and Storage, Insight for DBAs, MySQL
While preparing a post on the design of ZFS based servers for use with MySQL, I stumbled on the topic of fsync call performance. The fsync call is very expensive, but it is essential to databases as it allows for durability (the “D” of the ACID acronym)....
by Dave Avery | Feb 8, 2018 | Cloud, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live
Percona has revealed the line-up of in-depth tutorials for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, Calif. Secure your spot now with Advanced Registration prices...
by Ananias Tsalouchidis | Feb 7, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For...
by Michael Coburn | Feb 6, 2018 | Monitoring, MySQL, Open Source, Percona Software
In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools...
by Borys Belinsky | Feb 5, 2018 | MongoDB, MySQL, Percona Events
Percona announces the release of Percona Monitoring Plugins 1.1.8. Changelog Add MySQL 5.7 support Changed a canary check to use timestamp.now() and return a timedelta.seconds Remove an additional condition for the Dictionary memory allocated Fixed a...
by Peter Zaitsev | Feb 5, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look into four ways MySQL executes GROUP BY. In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be...
by Colin Charles | Feb 2, 2018 | Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Events, Percona Live, Percona Software, PostgreSQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 update: tutorials have been picked, and the schedule/press release should be announced by next...
by Vadim Tkachenko | Feb 1, 2018 | MySQL
Percona recently released Percona Server with MyRocks as GA. You can see how Facebook explains wins they see in production with MyRocks. Now if you use Percona repositories, you can simply install MyRocks plugin and enable it with ps-admin –enable-rocksdb. There...
by Borys Belinsky | Jan 31, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.7.0. (PMM ) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides...
