by Tibor Korocz | Feb 28, 2018 | Monitoring, MySQL, Percona Software
In this blog post, we’ll checkout Percona Monitoring and Management vs. gnuplot when it comes to creating great metrics graphs. gnuplot is great, but PMM might provide graphs that are easier to read. Percona Monitoring and Management (PMM) is our free and...
by Peter Zaitsev | Feb 28, 2018 | Insight for DBAs, Monitoring, MySQL
In this blog post, I’ll look at how you can analyze raw MySQL query logs with ClickHouse. For typical query performance analyses, we have an excellent tool in Percona Monitoring and Management. You may want to go deeper, though. You might be longing for the...
by Borys Belinsky | Feb 27, 2018 | MySQL, Percona Events, Percona Software
The latest release of Percona Monitoring and Management (PMM) 1.8.0 is available as of February 27, 2018. Percona Monitoring and Management is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own...
by Tibor Korocz | Feb 27, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll look at how to catch slow and frequent queries with ProxySQL. More and more people are using ProxySQL because it is a great tool and it can help DBAs a lot. But many people do not realize that it is more powerful than it looks. It has...
by Marcelo Altmann | Feb 26, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery. I recently wrote a blog post describing a different way of doing Point-In-Time Recovery (PITR). If you want to know the step by step, please visit the mentioned blog...
by Dmitriy Kostiuk | Feb 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.39-26.25 (PXC) on February 26, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.39-26.25 is now the current release, based on the following:...
by Mykola Marzhan | Feb 23, 2018 | Cloud, MariaDB, Monitoring, MySQL, Percona Software
Please join Percona’s Build / Release Engineer, Mykola Marzhan, as he presents Monitoring Amazon RDS with Percona Monitoring and Management on February 27, 2018, at 7:00 am PST (UTC-8) / 10:00 am EST (UTC-5). Register Now Are you concerned about how you are monitoring...
by Dave Avery | Feb 22, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
Welcome to the first interview blog for the upcoming Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog...
by Dave Avery | Feb 21, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Live
The conference session schedule for the seventh annual Percona Live 2018 Open Source Database Conference, taking place April 23-25 at the Santa Clara Convention Center in Santa Clara, CA is now live and available for review! Advance Registration Discounts can be...
by Alexander Rubin | Feb 19, 2018 | Hardware and Storage, Insight for DBAs, MySQL
In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics. Why Archive? Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. To name just a few...
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 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 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 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 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 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...
