Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version 5.5, is a really powerful tool. It is actively under development, and each new version provides […]
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 open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance, and is […]
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 ability to query raw MySQL “slow” query logs with SQL. […]
My favorite way of MySQL installation is to go with tar ball.It is easy, simple and manageable.There is also other thoughts people would think the tarball has many limitations and restrictions in terms of package dependency and functional incompatibility with the OS. If certain functions are not available in generic tarball but they are available in rpm or package bundle, tarball may not be the choice. The platform to go for is for those with the package repository (yum or apt_get) support. Steps for installation (This is only my way!!!)1. Remove any MySQL package from the OS There is a chance the OS may come with packages of MySQL installation from community. To make sure we have a clean environment, it is good to remove all of them.2. Using OS’s package installer (yum / apt_get) to install the proper MySQL package with the same version. This is to ensure that any other package dependency can be resolved easily and automatically. 3. Remove the MySQL package but not any dependency packages. This clean up MySQL installation and the OS has no more MySQL binary.4. Untar the tarball to MySQL binary folder (e.g. export MYSQL_BINARY=/opt/mysql cd $MYSQL_BINARY; tar -zxvf <tarball> 5. link the /usr/local/mysql as the latest to the MYSQL_BINARY ln -s $MYSQL_BINARY/<mysql version binary> /usr/local/mysql6. Change ownership for /usr/local/mysql and the $MYSQL_BINARY/<mysql version binary>Within the $MYSQL_BINARY folder, it may contain more than one version of MySQL binary. If the system supports multiple version of MySQL, it is doable. In some cases, testing of upgrade from version to version, more than one version of MySQL binary installations is required. There is also chance to recover data from old data backup which may require old version of MySQL.
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 environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently […]
Today the call for participation for Oracle Open World 2018 has started.
The 2018’s edition will take place in San Francisco as usual, from October 22nd to 25th.
As every year, MySQL will be present and if you want to participate, we encourage you to submit a session. We encourage the submission on the following topics:
case studies / user stories of your use of MySQL
lessons learned in running web scale MySQL
Production DBA/DevOps perspectives into Architecture, Performance, Replication, InnoDB, Security, etc
The call for paper is open until March 22nd, don’t miss the chance to be part of this amazing event ! Submit now() !
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 post highlights Bill Karwin, Database Developer at Square. His talk […]
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 many features and possibilities. […]
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 post. Here is a quick summary of the approach: Restore the […]
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: Percona Server for MySQL 5.6.39 Galera/Codership WSREP API Release 5.6.39 Galera Replication library 3.23 Starting from this […]